How to set the title of the report

  • hi all

    i am using sql server 2005. i have made some reports by using sql reporting. now i want to add a title for the every report instead of report viewer. and one more thing how can i change the caption of button ("view report").

  • One thing you can try to add a report parameter, and add a textbox in page header, assign the textbox value to parameter's value.

  • yes, that´s right

  • To add the title for the report, assuming it is the same as your report name, add a text box in the header section of the report and set the value of the textbox to : =Globals!ReportName

    To maintain a custom header and footer for all reports created in reporting services, using the report wizard, you will have to modify the XML Report.rdl file found in the following folder:

    C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

  • thanks its working fine...

  • The "view report" button is a Microsoft program thing. I haven't heard of anyone being able to change the caption on it.

    Someone let me know if you've been able to.

    Also, go to Report -> Properties. You can add in report title and author name there. This will NOT display on the report, BTW. You'll have to create a textbox on the Report or Page header with a title in it if you're working for display purposes.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply