I'm using SQL Server 2005 Reporting Services (SSRS), and developing my reports using Business Intelligence Development Studio (BIDS)
Is there a way of specifying an expression in the tooltip field for a chart/table/text box that would give the dataset name, or even better, the stored procedure name (assuming the data set is set as 'stored procedure' type)?
I'm curious as to whether this can be done as cleanly as you want. From my experience most ssrs developers have come up with work-arounds to get the more advanced functionality they are looking for. In this case, I think you might have to come up with a work-around.
Here are a few ideas I had:
I'm also kind of curious as to why you need to know the stored procedure used to generate the report. Isn't that kind of information something you don't want to show the user? I've seen some developers add debugging information to their reports by hiding them except when a certain parameter is flagged.
answered Oct 13, 2009 at 05:53 PM