Reporting Services Report Issue

  • Hi,

    I've got an issue where I am able to display some reports but not all of the reports. Some reports were added recently but I need to know which tables to query in RS which will give me an idea of failures of these reports.

    Any advice much appreciated

    Thanks

  • There are 2 places you can look.

    First would be the ExecutionLog view in the reporting services database.

    The second, and I find generally more helpful, is to review the trace files. You can find them on your server in the path \Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles

  • Hi,

    I have had a look in the execution log but it's not registering failures. I will have a look at the other suggestion you've mentioned.

    Thanks

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

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