reporting-services – IT Nursery

How to get rid of blank pages in PDF exported from SSRS

May 30, 2022 by IT Nursery

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the layout size in report properties as width=18in and height =8.5in. It gave me the … Read more

SQL variable to hold list of integers

May 26, 2022 by IT Nursery

I’m trying to debug someone else’s SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One of the parameters the report asks for is a list of integers. This is achieved on the report through a multi-select drop down box. The report’s underlying query uses this integer list … Read more