Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

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