Oh, i am not working with SSIS, i am working with SSRS that has several reports that shares one data source (=shared). it's a sql server type connection that...

thank you so much!

thank you, it makes sense. so, you don't recommend changing my original script?

thank you.

Hello back,

you are 100% correct: you do not need anything if it is just a report; tool box has everything you need to display it.

however, from your originala post: ...

sure :-).

Well, if you need any combo boxes for the User to filter your report by parameters, let's say, State='CA', do what Robert says :-).

however, if you need...

Hi,

i think i figured it out myself and want to share. use InScope function. for example:

=iif(InScope("group_product"), "Transparent", "LightGrey")

that's assuming we have a group by row called "group_product". this will...

Hi there,

SSRS does not have these type of controls, it's not a web page :-). however, you can place an illusion of a checkbox or any other cute bullet...

wow! this is exactly what i need! i just did all the steps and it works! thank you muchely!!!!!!!!!!!!!!!!

Thank you for writing me back. this is great, but we have around 100 ssis and more coming. it's got to be something more automatic so others in my team...

thank you so, so much, Tommy. it worked! i really appreciate your help and fast response.

this is pretty good :-), i got this done with your help, Tommy, thank you.

now, how do i pass this value of my custom variable MyDate to my sql statement...

it's pretty good, thank you.

i did define custom variable called last_prior_month_date as DateTime under User namespace.

now, how and where do i actually assign a value to it that...

if you have SQL 2000, they will ship you SSRS for $10.

here is the link to SSRS demo: http://www.microsoft.com/sql/prodinfo/previousversions/rs/rs_authoringdemo.mspx 

this will get you started.

SSRS 2005 is a part...

40 hrs or so, unless some production issue comes up and it has to be done today. or, if  i am trying to discover something for myself, just to learn if it...

it really depends on your boss. will he open to listen to you & welcome other ideas? i'd usually started with "this is where we are and what would be...