Charts not showing in the morning

  • Hi everyone

    So here is the problem

    1. SQL 2012 R1

    2. 15 reports containing charts, another 15 with data, all done in SQL 2008 R2

    Each morning if I run any chart report, all I get is an empty frames (A report may contain 1, 2 or 3 chart, each is in a frame)

    No red x's or any missing icon.

    All the Data reports are ok, the titles of the charts are here, only the charts are missing.

    I have to restart the reporting service each day then everything come to normal.

    I already run the repair from the setup, no effect.

    Any suggestions ????

  • I've heard of the reporting service going to sleep. The resolution was to create a scheduled hourly dummy report to keep it awake. I'm afraid I do not have any more details.

  • I created one each 12 hours but it didn't work, may be I'll try it each hour.

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

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