Cheers
Chris
If you use anonymous access then the user who is accessing the report from the internet does not have to authenticate any type of username to the server.
However, you probably don't want just ANYONE to see your reports, so you may want to develop a secure front-end with Visual Studio to authenticate the user in that fashion. Sort of like a portal on a website. If you go this route, be sure to use a stored procedure and possibly encryption for your password I/O.
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.
