ADDING BLACK ROWS TO A SSRS REPORT LAYOUT TABLE BASED ON THE NO OF RECORDS RETURNED BY A DATASET
Posted on 2010-08-25
In ref to adding rows to a table in a SSRS report layout, I have a dataset and the output of that dataset is used to populate a table in the report layout. The issue is the dataset can have a varying no of records output. I want to keep this static in the layout, i.e. I want assign a fixed 25 rows to the output of this dataset. So for eg. if there are 10 records in the dataset, then I want the layout table to display these 10 records and also show (25-10=)15 blank rows. So no matter how many records are returned by the dataset the report layout table always has a fixed 25 rows for display.
Now how can this be achieved at run time/dynamically? thanks in advance