This SSRS article shows how to display all the table rows or records on a single page. To work with this, right-click on the Datasets folder to create a new DataSet. Writing the below code inside the SSMS shows the data set we use for this example.
The Sql query that we used above SSRS example is:
SELECT Prod.EnglishProductName AS ProductName, Prod.Color,
SUM(Fact.OrderQuantity) AS Orders, SUM(Fact.TotalProductCost) AS ProductCost,
SUM(Fact.SalesAmount) AS Sales, SUM(Fact.TaxAmt) AS Tax
FROM FactInternetSales AS Fact
INNER JOIN DimProduct AS Prod ON Fact.ProductKey = Prod.ProductKey
GROUP BY Prod.EnglishProductName, Prod.Color
We have designed a simple table report of product sales and formatted the font and colors. If you observe the report review, it has rows of four pages, and our job is to display all those four pages’ records in a single page.
How to Display SSRS Table Rows on a Single Page?
Go to the properties window and select Report. If you don’t find the Report (by default, the body is selected), please use the drop-down arrow beside the Body and choose the Report from the list of objects. Now, you can see the report properties. To display all the table rows on a single page, we have to change that InteractiveSize property, so expand it.
Set the InteractiveSize property from the default value (Width as 21 cm and height = 29.7. cm) to 0 cm. We must set the Height to 0 cm to get all rows on a single page.
Now, if you go to the report preview, you can see only one page, which displays all the records or rows within that page.
