RS formatting ?

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.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())
"aggiechick717" <mhoppe@.chkenergy.com> wrote in message
news:1163189494.473934.172880@.f16g2000cwb.googlegroups.com...
> 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.
>