I had the same expereince before.

I have checked the parameters with the SQL Trace function and it seems the reporting services successful pass the @date value to the SQLServer yet...

I am not sure is it work for you.

Try this.

Create a temp. table and store the returned record set. The record set has the @date parameters for the reports. For...

"HideDuplicates" is not available in the Report Designer when user creates a report model. Any advises are welcome.

maya potiyevskaya (2/11/2008)

---

sure, something like this would work:

case when loan_balance > 50 then '> 50'

case when loan_balance <=50 then'<=50'

else ...

Hi maya

Thanks for the reply.

Can you provide me more information on how to create a field that will filter out weekly working hours > 50 in the Report...