Click here to Skip to main content
15,903,388 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have one query in SSRS. i have a report which should be in pdf format. in that i have a table which should have 5 details ( i mean lines).
Here I have question, suppose if my dataset for the table is returing only 2 rows means, I need the report should be like first two rows should be with data and the remaining rows should be empty.

As of now this is not happening, because of this my report alignment is changing.


Eno ename
1 A
2 B

Output should be in Table ( SSRS)

EmployeeNo EmployeeName
1 A
2 B
- -
- -
- -

Suppose if my dataset is returning :
0 roww means, remaining 4 rows should be with "-"
1 row means, remaining 4 rows should be with "-"
2 row means, remaining 3 rows should be with "-"
3 row means, remaining 2 rows should be with "-"
4 row means, remaining 1 rows should be with "-"

If anyone knows the solution, please advise me.
Thanks in Advance.

Sandeep Mewara 18-Sep-10 5:59am    
Couldn't make out what you mean by 'alignment changing'?
mslliviu 22-Sep-10 3:28am    
Wouldn't be easier just to modify the query for the dataset, so it always give you back 5 rows

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900