I'm not sure, but I think each cascading parameter causes a post-back when it loads. If that's the case, you might want to try trimming down the page the...

When you run the report on the server's Report Manager, how long does it take for the drop-downs to populate? If the time is significantly less than what it...

Here's what I have for R2, though it's just the 180-day eval: 10.50.1600.1.

Right, because a table in the page footer would just be too simple, wouldn't it? Here's a more educated guess (assuming each report is only one page long): try...

Have you tried putting a duplicate table in the page footer and just showing the total row(s)?

Try looking in the log folder here: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles. There should be complete information there about what went wrong.

As for notification, RS is not...

You can also add the month number of the year to the query and then sort by it in RS without having to show it anywhere in the report.

If you set the page break on the email group and don't page break on priorities, you should get something like this:

email1

priority1

priority2

...

It's okay to have the image in every row. You can set an expression on the visibility property so the image shows only when you want it to. ...

You can also hit F4 to bring up the properties window for the body. This way you can change the width property to exactly the value you want and,...

That's what I was afraid of. It's an issue of...

I think the problem may be what data is in a given row. Can you give me a sample row from the finished report as you'd like it to...

It looks like you need to group the data by row numbers in order to get the percentages. Something like this:

[font="Courier New"]

1 A ...

Sorry, I just assumed you had a SQL back-end, not Cognos. What are the expressions for the two latest year columns? Could you just add those expressions together...

Rather than doing the 2/5 year logic in RS, it seems like a simpler approach would be to do it in the SQL statement.

You could join the table to...