The query executes quite fast but the render time is slow.

Hi

The dashboard is a live one where the user will open it whenever they want and it will show latest stats.

Your ascertion is correct, the dashboard renders quickly for some...

Mark you are a life saver, I battled with this for a while and your work around did exactly what I wanted.

Thank you for your assistance.:-)

I need it there, just not that collected figure to appear (please see attached).

I used the #VALY but I have changed my chart to the normal because I noticed that the chart legend would have a number for the collected pie and I...

Hi

Please look at the attached picture, I think it is what you are trying to do.

This is how I did it.

1. Created a new report using the wizard.

2. Chose Tabular...

Thank you for your response.

I do not have enough knowledge to know how to play with the css.

You welcome, I hope it worked for you.

Which version of SQL are you using?

Maybe you can consider the NoRowsMessage property; report will still be mailed out but instead of it being blank a message will be shown....

I find what the problem was.

The code above works perfeclty when I select each parameter individually, problem occurs when all parameters are selected at once which occurs when the...

I found a work-around solution by using the case statement in SQL and generated figures for Q1 - Q4 and YTD as individual columns. Then in SSRS I used the...

I will try using the case statement.

I have a report parameter for the querter which is chosen before the report is displayed.

Would I need to cater for each quarter (Q1...

I solved this issue.

So all sorted now?

Debbie Edwards (2/21/2013)

---

Excellent piece and its helped me figure out my problem with adding the files to a folder.

My problem is that my folders arent on the C drive but...