I did, but as stated above that only gave me a listing of links to the reports on the report server.

Thanks for your input. The only way this works for me is with the following URL:

'http://myreportserver/ReportManager/Pages/Report.aspx?ItemPath=%2fMyReportName&rs:Format=Excel' (although &rs:Format=Excel doesn't seem to have any effect on the outcome...it's the same...

Thank you for your suggestion, Mohamed. I checked and that report property is set to false. I was able to fix the problem by adjusting the text fields...

Thank you for that info, Alan. The query does give me a lot of what I'm looking for. The only thing it doesn't offer is a method of...

I finally got it to work. I had to manually add a parameter to the main dataset that links to the parameter I set up that's associated with the...

Yes, of course. I understand that. Are you inferring that SSRS automatically knows to look for a dataset that has a variable with the same name as the...

Thanks for your reply. You have it spot on. However, the Value field in the dropdown list (CityID in your example) isn't making the connection to the main...

Thank you very much for taking the time to provide step-by-step instructions. They worked beautifully!

Thanks for your suggestion. As a newbie, can you offer some detail in how to to pull and incorporate 2 detail rows in a Tablix? It seems to...

Thank you, Koen, that worked. However, isn't there a more efficient way to handle incorporating query revisions into the report?

When I click "View Report" and enter the case number into the parameter field, it returns an error "The 'CaseID' parameter is missing a value". CaseID is a field...

I created a hidden text box on the report, and entered the following as an expression: =iif(CountRows("CaseData") = 0, "No Data","").

However, during preview the report still errors out probably because...

Sorry...I'm an SSRS newbie...

Where would I access the CountRows function? I don't see it in my dataset properties.

It looks like the "NoRowsMessage" property is only available on a Tablix. I have a main Stored Proc that supplies most of the data to my report, and I...

I think I found an answer:

I ended up creating a parameter pulled from the dataset field. Then, instead of referencing the query field directly, I used the parameter in...