• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Report Tooltip in underlying data table?

 6 Replies
 0 Subscribed to this topic
 23 Subscribed to this forum
Sort:
Author
Messages
David Levine
Basic Member
Posts: 6
Basic Member
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
Veteran Member
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.
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
David Levine
Basic Member
Posts: 6
Basic Member
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
Veteran Member
New Poster
New Poster
Congrats on posting!
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
Advanced Member
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
Veteran Member
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.
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
Chris Martin
Veteran Member
Posts: 277
Veteran Member
New Poster
New Poster
Congrats on posting!
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