Who's On?

	Membership:
	Latest: Pat
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5296

	People Online:
	Visitors: 483
	Members: 0
	Total: 483

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244

Report Tooltip in underlying data table?

6 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

David Levine

Basic Member

Posts: 6

3/26/2012 5:59 PM

Hello,

The report Tooltip - the report description that appears as you hover your mouse cursor over the report name is derived from the "Description" text box in the "Main" tab, when selecting "Edit..." from the report. Does anyone know where this description can be found in the underlying table structure?

By the way, I've determined that it's NOT rsuserprd.ers_reports.description - this is the report description derived from Tools-->Reporting Services Report Administration-->Maintain Reports. Then, upon clicking "[Details]" for the report, under "Report Options"-->"General Properties"-->"Description".

Thanks in advance.

Matthew Nye

Veteran Member

Posts: 514

3/26/2012 6:37 PM

thats going to be in the Framework Services database. not sure what table though. ill take a look later and see if i can find it. Report back if you find it.

David Levine

Basic Member

Posts: 6

3/30/2012 2:04 PM

Thanks, Matthew. I've gone through each table under the fsuserprd schema with no luck. Any guidance you can provide would be appreciated.

Thanks again.

Chris Martin

Veteran Member

Posts: 277

3/30/2012 2:44 PM

It's not where I would expect it to be (entrydesc field in enpbatree table). As Matt said, it should be somewhere in the FS database, but I can't find it yet.

Patrick Dowd

Advanced Member

Posts: 25

3/30/2012 3:49 PM

I would assume it's in ENPBATREE as well but at least for me, the ENTRYDESC field only shows "Untitled Option".

I set up a test where I added a link description of "findme" and searched the entire EFS database for that string. I received no results.

Matthew Nye

Veteran Member

Posts: 514

3/30/2012 3:53 PM

It looks like this is gunna be stored in one of the binary fields.

Chris, dont you have a script for converting binary codes? I never fine tuned mine to be very useful. Keep in mind if you are using SQL server to view these tables it will show binary fields as being NULL when they actually arent.

Chris Martin

Veteran Member

Posts: 277

3/30/2012 3:56 PM

Something along these lines should work:

SELECT CAST(CAST(fieldname as varbinary(200)) as varchar(200))
FROM table_name