x

Use dataset name in tooltip on SSRS report

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)?

more ▼

asked Oct 13, 2009 at 08:49 AM in Default

Kev Riley gravatar image

Kev Riley ♦♦
53.3k 47 49 76

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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:

  • Manually add the name in the tooltip field (obvious)
  • Change your result set to include the name of the stored procedure itself as the first column (kind of a hack, but would work)
  • Create a textbox with a standard name, then write a script that would read the xml to find the CommandType/CommandText and add the name (CommandText) in that textbox's value field

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.

good luck!

more ▼

answered Oct 13, 2009 at 05:53 PM

jjerome gravatar image

jjerome
191

Reason comes from me just wanting a quick way of identifying the source for my reports. I already have a text box that I use to clarify the source, but this is a more user-friendly explanation e.g. 'Source:Datawarehouse' - and I just thought I could use the tooltip to give me more info. That then just prompted me to think how this could be done programtically.
Oct 15, 2009 at 10:08 AM Kev Riley ♦♦
As for the answers: Manually - eurgh, rather not bother!:) Include SP name in result - nice hadn't thought of that. Script - what - xml - what - I'm a DBA you know, not a pesky developer!
Oct 15, 2009 at 10:11 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x555
x35

asked: Oct 13, 2009 at 08:49 AM

Seen: 3872 times

Last Updated: Oct 27, 2009 at 01:38 PM