Below is the T-SQL script to query the Report Server Execution Log. You may query either the dbo.ExecutionLog2 or dbo.ExecutionLog3 table (same as dbo.ExecutionLog2 with 2 fields renamed: ReportPath has been renamed to ItemPath and ReportAction has been renamed to ItemAction)
Below is the output of the query.
USE ReportServer GO SELECT * FROM dbo.ExecutionLog3 ORDER BY TimeStart DESC
By default, your SSRS reports are generated in portrait format. The body of your report will be automatically resized when you add report items. When you deploy your reports, it will portray correctly in your browser. But when you export your report to PDF, you will notice that it is in portrait format. It is not presentable and it will have extra pages. You can prevent this from happening by exporting the PDF in landscape format. To do that, just follow the steps below.
2. When you export the report, you will see extra blank pages. To avoid that, the size of the body should be less or equal to the size of the report margins
Set the width of the body to 26.7 cm Set the height of the body to 18 cm
So now, when you export your report to PDF, it will be in landscape format.
