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

avatar image

Kev Riley ♦♦
64.2k 48 62 81

(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

avatar image

jjerome
191 2 1

(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.

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:

x660
x39

asked: Oct 13, 2009 at 08:49 AM

Seen: 4814 times

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

Copyright 2016 Redgate Software. Privacy Policy