the same post has been addressed:

here

I've never dealt with reporting services but I did find some info/links that you may be able to use to resolve your issue:

from the microsoft site:

1) "When you deploy a...

"I don't like to just copy and paste, I want to understand the theory behind it."...

mike - in magyar's defense - what was meant by this was...sure I'll just copy...

magyar - i just wanted to explain the syntax I was asking you to use...

eg: the next 6 lines of code:

MyParam.Name = "@SRschoolNameFirst"

MyParam.Value = SRschoolNameFirst

MyParam.Size = 150

MyParam.Direction = adParamInput

MyParam.Type =...

hmm - wonder why ?!

http://www.askmen.com/men/may00/24c_larry_ellison.html

great but not good

you mean half of what he makes right ?!

ultimately it's only money...along your lines of "good, fast and cheap" if there were a choice between nice and rich, i'd take...

you can sound like him as much as you want...just don't try to emulate his lifestyle...i think we all like you just the way you are...

noel - you're a nice, kind person to persevere with this stuff that should only be my headache since i'm stuck with it...

Update set new_rate_210 = case...

i think the question is what happens to the deallocated data pages...guess they get reallocated again when needed..........?!?!

magyar - you have to explicitly spell out the name, type, direction, size and value of the parameter....when i sent you my shortcut syntax i was telling you to do...

okay - i hate being yelled at so that's the last time you'll hear it from me!

you can...then you have to pass all the parameters to your procedure!

Yes - but it wasn't I that won that design contest I can assure you...

okay remi (sheesh!)...backing off (& down) real slow here...SORRY if I've stepped on any toes...