Wednesday, March 21, 2012

Report Title above parameters (Urgent)

Hi All,

I have created a report in SQL Server Business Intelligence Development Studio 2005. I need to add a report title above the parameters area. Is that possible?. please help me

The output should be like

_

Report Title

_

Report Parameters Section View Report button

Report Body part.

Hi.

Under the current implementation of Reporting Services, any parameters for a report are generated as part of the report viewer controls (i.e. above the page number and export format controls). I do not know of any way of inserting your own title above those.

I can think of a couple of workarounds/solutions.

Firstly you could add another parameter to the report, call it something like Title and make it a string and ensure it is top of the parameter list. Then just give this a single non query value where the label is your report title (e.g. My Report) and set the value to 0; then set the default value to be non query as =0. When the report is generated you will then have a parameter above all the others, with a description of Title and a single (non changeable) value which is your report title.

Not perfect but it might suit your purpose.

The second way would be to create your own web page (e.g. in ASP.NET) which has whatever titles you want at the top then embed the report underneath, so you get your parameters after the title.

Hope this helps,

Gary.

No comments:

Post a Comment