Insert new rows after populating the report with fetched data

Hi,
I have a report where i have to display 100 rows in each page. There is an id column in the report.
If the data returned is only 60 rows then i will have to manully insert 40 more rows along with the id.
i figured out a way to increment the id upto 100 but i don't know how to insert a new row and populate it with the generated id.
Can anybody please help me out.

Thanks,
isa.

Find more posts tagged with

Comments

mwilliams

You could just add extra footer rows to your table and hide/show them based on the number of rows returned. This may not be too desired of a solution though since you have so many rows you'd have to add. You could also probably create a scripted dataSet or flat file dataSet that had 100 rows in it and join it with the original dataSet. Then, use computed columns to set your data up how you'd like.

isa

Hello Williams,

I will try to implement your suggestion and get back.

Thank you,
isa.