Tooltip Dilemma

  • I'm developing a report that summarizes inventory for our sales reps. This will be grouped by an aged days category (30, 60, etc.), and also by the type inventory (paid or unpaid). The report has a simple tablix as it is being rendered in our CRM system. Not a lot of real estate to work with...

    I have made several attempts to populate the tooltip with detailed data, but each time I run into the 512 character limit when the report is deployed. I know too much data in a tooltip isn't a good idea, but usually it would involve 8-12 reps with some $$ figures.

    So far I've used a custom assembly, and report custom code to get the data. I've also run across some information about using javascript, but haven't been successful there either.

    Has anyone else attempted this?

    Thanks for any help.

    Bill

  • i've used soem javascript stuff to make a DIV appear based on mouseover; it should be easy to add to the report.

    obviously a DIV is not limited to any specific size, and you can set the div properties to have scrollbars and stuff if you have boatloads of data to present as a tooltip equivilent.

    here's just one example, based on mouseover, but i'd think you'd want it on click so the div sticks around till they "close" it.

    http://www.dynamicdrive.com/dynamicindex5/dhtmltooltip2.htm

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Thanks Lowell. I will see what I can do.

    Bill

  • Have you tried popping up the info via an Action? Here's a discussion about that method:http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/98ad98f8-f557-4efd-9fd4-fd604ef63097/[/url].

    Or use the javascript alert in this article http://qa.sqlservercentral.com/articles/Reporting+Services+(SSRS)/67660/[/url]

    MWise

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply