dashboard type ssrs report renders with hover over info in some charts

db042190 1,521 Reputation points
2021-11-15T20:24:31.237+00:00

hi we run 2014 enterprise. we are going to 2019 in the coming months.

we have one dashboard style report with about 6 charts and 2 rectangles. the 2 rectangles each have their own tablix.

we will try to trap this in the log next time it happens but on occasion just the charts render with the hover over text in the graphic instead of the chart. any ideas?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. Isabellaz-1451 3,616 Reputation points
    2021-11-16T02:51:58.347+00:00

    Hi @db042190
    149604-message.png

    what is the log,and how did you trap the report ? I am not sure what you want to accomplish,can you descibe more detail?

    Best Regards,
    Isabella


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. db042190 1,521 Reputation points
    2021-11-18T18:15:48.543+00:00

    what is the log,and how did you trap the report ? I am not sure what you want to accomplish,can you descibe more detail?

    thx isabella. the log is Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\LogFiles where presumably some error would be posted the same time this happens. since our logs stick around for 30 days, we have 30 days to "trap" or see the error. once 30 days passes, we dont have a clue and we have to wait till the next time it happens.

    assume you have a chart region hover over that reads "this chart represents year over year sales comparisons for the last 10 years". But instead of your chart's bars rendering in that region, your hover over message renders in that region as if its a textbox. that's what is happening to us on occasion. what we want to accomplish is to determine why. once we determine why (under what conditions is that even possible), maybe we can come up with a solution.


  3. db042190 1,521 Reputation points
    2021-11-19T13:07:10.313+00:00

    thx isabella. i will post redacted pictures. the assumption is that when ssrs renders something in a chart region that it isnt supposed to (in this case a string) instead of a chart, that the log will show some timeout or space errors or warnings.

    0 comments No comments

  4. db042190 1,521 Reputation points
    2021-11-19T13:44:53.463+00:00

    when this report works, the regions being pointed to by red lines render various bar charts. as you can see when the problem occurs, instead of a chart we get the full text of the associated hover over tip instead.

    150978-redactedwithproblem.png


  5. db042190 1,521 Reputation points
    2021-11-22T16:58:45.107+00:00

    thx isabella, i cannot create a new report but below is what we believe to be an error log from the last time this happened.

    151551-error-trace.png


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.