Don't forget the "=" sign at the front.

Also, you might want to check the number of closing parentheses there 🙂

A data-driven subscription sounds like it might work, also, depending on the results of your dataset and the formatting. However, without a specific scenario that's just a guess.

Could you share that query? I'd be curious to see it!

Cheers,

EJM

Are the groups always exactly the same as the parameter? E.g. Are the users selecting from a list of countries? Are the display values for the Parameter the same as...

To expand on what Mr. Garrison said:

You can refer to objects in the body of the report by object NAME in the header, so a way this is often solved...

Actually, upon even further reflection, I decided I didn't like how the days/weekdays/months were represented as a sum of powers of 2, so I wrote a few more things that...

Actually, I just realized that the URL stuff is old, and working for only SSRS 2005. Here is a new version that includes direct URL links in the SSRS 2008R2...

Howdy! Sounds like you want to use the "ReportSchedule" table, too.

Below is a query I put together a while back that I use to create a "subscriptions dashboard" report that...

I think you need to provide a little more info here: What is the subreport trying to do? If you're clicking an Order Number, possibly to view the details of...

If I were you, I would start by making one dataset that has all the appropriate parameters and conditions on it, and then put it into Table 1 (Summary) and...

Mysorian, I think you may have misunderstood the OP's actual question. It's not that he wants to hide the image if it doesn't exist, but he wants to write a...

Mysorian's suggestions is basically just another way of showing the picture files, which your report is already correctly doing. I'd really recommend that you some how export the list of...

Okay, that being the case I think my recommendation still stands. If you don't know SSIS, this would be a great first project to get you started: read the file...

Well, without knowing how you actually implemented your report, and what you're ULTIMATELY trying to achieve, it seems to me this doesn't need to be a visual SSRS report.

I'm guessing...

This actually sounds like a job better suited to SSIS, since you want to constantly be writing to the same Excel file.

I'd do some Googling on SSIS exporting to Excel;...