sql server reporting services: RS formatting ? -- sql server reporting services

RS formatting ?

aggiechick717
11/10/2006 12:11:34 PM

sql server reporting services:

Hi all,

I have a report that allows users to choose one or more parameter
values and then a report is rendered based off of that input. I have a
table that I want to always have 8 rows, but if the report returns only

2 rows I need to add 6 blank rows to the end of the table. If the
report returns only 5 rows, I need 3 blank rows added to the end of the

table, and so on. Does anyone have any idea how to do this in RS?

Thanks in advance.

Re: RS formatting ?

Oleg Yevteyev
11/10/2006 4:25:06 PM

Quite simple.
Two ways.
One - write custom sql script, count amount of rows and add needed empty
ones to the resulting output.
sql stored procedure or a set of sql statements will do just fine.
Second one - write a custom dataset extension. get a simple dataset from the
sql server ( ore whatever data source of your choice) and within data
processing extesion implementation - just add empty rows
as
dataset.Tables[0].Rows.Add(dataset.Tables[0].NewRow())

[quoted text, click to view]