February 24, 2012 at 3:33 pm
I have the RDDs and in the report I hardcoded the report name in the header. Is there any way i can get report name from the DB. If i put the Built in function[&Reportname] i get the Name i specified for the report. But the header has to be different name which is report description. Can i get it from the DB.
February 27, 2012 at 8:38 am
somebody please help me.
February 27, 2012 at 8:42 am
I think you should be able to add the field as a column in your query, and then put a textbox on your report in the header and set it using the Expression Editor to the field under datasets.
February 28, 2012 at 9:44 am
You could create a Dataset called ReportTitle which queries a DB for the Report names but you'd need to include a reference of some kind in the DS query and include the reference mapping column in whichever table contains the report names.
eg. SELECT ReportName FROM dbo.ReportMetaData WHERE ReportCode = <reportcode>
February 29, 2012 at 8:35 am
Thank you guys it helped me a lot.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply