Displaying database information in report header (SSRS2008)
I have a table in my database that stores the date and time the tables I'm using in my report were last updated. I want to display this datetime in my report header. I've created a textbox but can't link this to a dataset to display the time. I've got around this by creating an internal parameter and giving it the value of the appropriate date from the dataset. A search has turned up some similar old queries with this solution, but they're from 2006. Is this still the accepted solution, or is there a way to link a dataset directly to a textbox in the report header? Thanks RayIf this post, or another, answers your question, please click the 'Mark as answer' button so others with the same problem can find a solution more easily.
March 19th, 2011 5:00pm

You cannot link the data set to a textbox. You need to use some aggregate function to call the dataset field in report header. example: =First(Fields!EmpName.Value, "DataSet1") Regards, Senthil
Free Windows Admin Tool Kit Click here and download it now
March 19th, 2011 5:11pm

That seems to be a better solution, thanks. Are there any others?If this post, or another, answers your question, please click the 'Mark as answer' button so others with the same problem can find a solution more easily.
March 19th, 2011 5:43pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics