Query Parameter question

Hello:

We're using RS2005 and I have the following question:

I have two report parameters that populated by a query within RS2005 and that works fine. Based on what I selected for the two report parameters I need to use these values to retrieve my Client's Name and paste on top of report in the header section of the report. I'm new at working with RS2005 but it appears to be hanging for some reason.

This is what I do to attempt to get the Client's Name. I created two individual datasets and populate with a query within RS2005. I created a third dataset and create parameters @.PCMR, @.PACCTNUM in the edit dataset section. I use parameters @.PCMR and @.PACCTNUM in WHERE clause of SQL statement in third dataset. I hope what I'm saying is making sense.

Best regards

You can have a filter condition for your third dataset. Go to Filters tab in Edit dataset and select "PCMR" under Expression and select "=" under Operator and select "Parameters!PCMR.Value" under Value section.

This should do the trick.

Shyam

|||

Shyam,

Thanks for the response however, I discovered my problem. It had to do with a 4th dataset I partially completed. I deleted the 4th dataset and the report runs fine.

Best regards