Adding Tooltip for Chart Data slows down performance
I have a suite of reports in a solution. Some the reports use the same expression for a tooltip. For 1 of the reports the report will not load correctly on the server. It just has those picture icons that you have to right click to see(though right clicking does nothing). Anyway when I remove the expression from the tooltip the report will run great in dev and in prod. In debug mode on my client the report will run fine whether the tooltip is there or not. Here is the expression: =Format(DateValue(Fields!ProcessDate.Value)) + vbcrlf + CSTR(FORMAT(Sum(Fields!FS.Value),"#,#")) I also tried pulling the data into my dataset formatted with sql statments and put that in the tooltip and I got the same result. Worked fine in debug mode but not in dev or prod..... I also created the report from scratch and it still tanks in dev and prod....... DBA Developer
August 15th, 2012 2:42pm

Hi, where did you add the Tooltip? Is the image control placed inside the tablix? I have made a test but that issue didn't happen with me. Maybe you can post a screenshot to show the issue more clearly. Regards, Leo
Free Windows Admin Tool Kit Click here and download it now
August 17th, 2012 2:19pm

The tooltip is on the lines on the chart. I failed to mention that the report is a line chart. I am attaching pictures of when the tooltip is included and when it has been removed. First picture without the tooltip. The second is running with the tooltip. DBA Developer
August 17th, 2012 5:42pm

Hi Paul, Thanks for posting on TechNet forum. According to your description, I have tried to reproduce the issue on my test environment, however, everything goes well. At this time, I suggest that you check the issue with a more simple expression for the Tooltip. Besides, you could update the Reporting Services with SQL Server update in your test or development environment. You can get the released builds of SQL Server from the following link: http://sqlserverbuilds.blogspot.com/ Hope this helps. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Mike Yin TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
August 21st, 2012 6:28am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics