I am not sure I understand your question, but the page size and orientation of the report is based on the master report that contains the sub reports. So,...

Are you in the Control Flow using Execute SQL Task, or in the Data Flow using OLEDB Command?

You need to look at the group properties. The sort expression probably needs a scope added to it. For example perhaps your current sort expression is =Fields!FieldName.Value

You probably...

Just because you don't have it in the dataset, doesn't mean...

Biclops

Good question on an under used SSIS feature.

I agree. Whenever I am making a stored procedure to be used in a report I always create local variables and set their values to the input parameters and...

I always thought that was just part of Visual Studio. For a live report I always the back button.

If the missing parameter is in your SP already. Go to the dataset properties and click Refresh Fields. This should add the additional parameter to the report. ...

Try creating local variables for all the input parameters in the SP, set the local variables equal to the input parameters and then use the local variables in the body...

Look in your reporting services database for a view ExecutionLog2. There might be something in there that will give you a clue.

Also I find the Report Server trace files...

medior

Query the full month's worth of data into your dataset.

Put a filter on your weekly that is something like Datefield >= Dateadd("d",-7,Today()).

Put a filter on your monthly that is something...

I would use AND rather than &.

Also you might want to check your field values for extra spaces maybe they need to be trimmed.

McGruff