Try the following format:

http://hostname/ReportServer?/folder/report&parameter1=value1&parameter2=value2 etc.

Try a CTE or temp table to get your DISTINCT then join that back to a SELECT where you query the data and constrain on the MIN or MAX of...

in-freakin'-credible

My logic as well....

You only see the static rows when you are in the Advanced mode. On the top of the Group Pane on the far right side is a little drop...

That is pretty cool! Congrats to SSC. I will probably go with one of the editors, but it could be anyone.....even me!

I am not sure I understand your data as you are showing it. But you can add scoping information to fields in a calculation. Generally it is something...

You are close, but you are still NOT looking in the right spot.

You are looking in the Group Properties dialog. I am talking about the properties window...

In short, knowledge is power, the more knowledge someone has, the more power they have. Learning more about SQL, or anything for that matter is always good and right....

I have been to one of these, and I would do another in a heartbeat. Like you I had to wake up very early, and travel far, but the...

Lemon Zinger is my morning brew.

Good question, good forum discussion. Thanks.

I have had a similar issue due to parameter sniffing.

In your stored procedure declare local variables and then set these local variables to the values of your input parameters and...

Is there a reason you can't group the data in your dataset?

If you put a page break "between each instance of a group" for group 1, and "Also at the end of the group" for group 1 and I think it...