You should probably use STRING data type

Other than using the Foe each loop container, i used a script task to read file name into a variable and used it as an expressions at the file connection...

Just Learning.

I tought it is not possible untill i saw a article and a forum in MSDN and ended up no where.

Thanks All,

i used If/Else to do this...

Sure, Thanks for the feedback!

In the data flow task, configure your source and destination.

Use the Sort transformation to sort the data. On the bottom of sort transformation editor you will have a check box...

This helps,

Thanks!

one way to do it is to use a sub report,

create one summary report and one detail report, and hide the reports based on the parameter value.

Just a tought!

Regards,

=iif(Feilds!FeildName.value is nothing,true,false)

try this expression in the hidden property.

let me know if this works.

This is perfect.

ThankYou again,

Thanks,

You will have an option called Hide Duplicates in the properties,

but doing something in the query will always be the better alternative.

from what i understand u might want to try

something like

startdate = isnull(@startdate,startdate)

and status = isnull(@status,status)

in the where clause of your dataset.

But if you are more clear, i am...

As using subreports is effecting performance, i might end up using multiple data sets and data regions with page breaks in the same report unless there is a better solution.

Thanks,

Jeff Moden (11/7/2009)

Yes, because my situation is more complex than what i have showed here.

Anyway...

Can you explain a little on how to do this? Please!

Thanks,