Look for a sort elsewhere on the report, on the tablix, a group column, etc..

The Great American Pastime

Have you cleared your browser cache?

My guess is that there is something wrong with the way your report server is configured. I believe that available formats is part of the config file, perhaps yours...

If I understand you want to make the StartDate parameter dependant on the choice you make in your Yesterday/LastWeek/LastMonth Parameter.

In the StartDate Parameter make the default/available date based on a...

http://YourServerNameHere/Reports

So a week is the current date - 7 days, what is a month? Current date -1 month, or current date - x days, etc.?

I looked at your query again. This really may be more of a formatting issue. Spend a few minutes Googling SSRS TimeSpan formatting, SSRS Time Formats, etc.. ...

Sun

I am not sure I understand what you are asking, but if I do, I would probably use a rectangle (not a tablix) and group it on a row. ...

From an SSRS point of view there is really no reason to separate your data into separate datasets by some kind of date criteria, just group your report by the...

Yellow Submarine

I would probably use an IF to decide whether or not to run the code for the dataset for the sub report. For example:

IF ParameterValue = RunMe

BEGIN

Your dataset...

Don't use FLOOR in your MAX expression.

To quote BOL:

add the following to the end of your URL

&rs:command=Render&rs:Format=render.excel