sql server reporting services: producing a report that lists 1 record per page -- sql server reporting services

producing a report that lists 1 record per page

zero
12/23/2004 9:55:33 AM

sql server reporting services:

Greetings,

I am creating a report using VS.NET and SQL Reporting services. The
report I have created is detailed and has images and lines etc. I tied
this report to a stored proc that returns back 7 records in a result
set. When I view the report, the results list out downwards on a page
instead of one record per page!

I was told to draw a table across the entire report and then use the
tables' grouping mechanism to tell it one record per page, but I cannot
drag a line into a table cell! Alas, I did not use any tables, just
text boxes, lines, images etc.

I cannot figure out how to get this report to loop on the records, and
I hope I do not have to redo the whole report into a big table to
accomplish this. It took me 3 hours to precisely lay the text boxes
out how I need them.

I have been searching the groups for my answer but to no avail. I hope
there is a simple solution to this problem. And not a "you did the
whole thing wrong and start over" situation.

Can someone please help me understand how to list the records of my
result set to one per page.

Thanks a million

-Zan

Re: producing a report that lists 1 record per page

Bruce L-C [MVP]
12/23/2004 12:25:12 PM

I'm not sure exactly what you have done here. You could have put textboxes
on the layout design surface but if you do that then it only lets you set it
to an aggregate of the column (like first or sum or count). You can have it
be the value of a column. Same with a rectangle. What you want to do and
what it is designed for is that these items should be put on the design
surface of a list. Then you click on the list, properties, edit details
group, group on one of your fields (hopefull you have some field that is
unique that you can group on), then click on page break at end. You will now
get one page per.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]