Anil, this property does not exist in SSRS 2005. You really need to analyze the size properties for Body,  and the margins and page size for Report. Also do you have a matrix or something that is expanding horizontally to push the body size out too much when factoring in the margins.

Hi Lidou123 - Do you really mean MDX script? That term applies to the calculations, named sets, and KPIs that one adds to the cube definition and doesn't involve the SSRS query builder in any way. Is that what you mean or do you mean something else? If you mean the MDX script, the answer is no - it is not possible to use parameters there. Now if ...

RD, Your question isn't very clear on what you mean, but perhaps this post is helpful: http://sqlblog.com/blogs/stacia_misner/archive/2011/02/04/33208.aspx

Hi Solomon - If you have to click View Report to run your report, does your report run correctly? If so, then your report query is fine. If you have to click View Report, that means one or more of the report parameters does not have a default value set (or does not have it set correctly).

Normally I run SQL queries against the source and validate against the corresponding results in the OLAP data.

Happy to help! :)

Joanne, this feature is not available in Reporting Services 2005. You must have 2008 or higher.

Thanks,  Suhas!

Thanks, Davide and Jason - I was hoping to spark a conversation about other tools, and I succeeded! I appreciate the time you took to read this post ad your suggestions for other tools. SharePoint Experts London - I'm glad you found the post useful.

Thanks, Boyan - the astute reader will notice that point when they check out the link for clearing the file system cache. I just have old habits that die hard, and will admit I don't always clear the file system cache depending on what I'm up to, so I didn't think to point it out. Anyway, you're right - if someone is going to register an ASSP ...