July 25, 2012 at 2:01 pm
Hi all,
New to Report Builder, experienced in SQL. I am on a contract project where I have replicated one of my client's reports, and need to print it out as requested. They would like this one defined report to be replicated over as many students as took their course this semester. So if 10 students took the course, then 10 sheets should be produced that would each contain information specific to a different one of the student's, as far as grades for all homeworks and exams taken that semester, with the final grade.
I have designed the page in Report Builder as given to me, but I am not sure how to tell the application (if I can in fact tell it) to replicate the same report individually over all the students in a query.
Can someone help me with this? First off, is it possible to do this, and if so, how would I go about doing this? If not possible, do I actually have to run the report separately for each student?
Thanks in advance.
July 25, 2012 at 3:07 pm
At a conceptual level, you need to have a group, and then force a page break per grouped item. The group would likely be 'student'. Am reasonably sure I've seen some walk throughs of how to do that, but a quick google search on "report builder" group page break would probably yield some results before I post them.
Steve.
July 25, 2012 at 3:48 pm
Hey Steve, thanks. That was the search line I guess I was looking for. I'll check it out in the morning and post as to my success.
Thanks again.
July 27, 2012 at 9:40 am
Ok, so I created a test report with a table that has only one row, and created a dataset that would return multiple rows, and that dataset is now associated with the table. I went to the tablix preferences and set page breaks to happen between each row of data from the dataset. I then ran that, and printed the output, and I am happy to say that it worked perfectly.
The only thing is that I had to make sure that the width of the report was just less than 8.5 inches. If it was 8.5 (as far as I could tell visually), while individual rows were being printed on their own pages, a blank page was printed between each row page, which happened because report builder is trying to print the extra width of the page, overflowing onto a new page for printout. Also, I found that I needed to reduce the height of the report to just less than 11 inches, so that it wouldn't also print extra blank pages representing the overflow below.
Anyway, that's a whole other thing. The page breaks work fine. Now on to figure other things out.
Thanks again Steve...
July 27, 2012 at 10:14 am
Glad to hear that it worked. Just one quick test I would look at doing is to have that sample set return *two* rows, and that you get as output 2 pages. The one row approach doesn't overly prove that you'll get a page per row/student.
Steve.
July 27, 2012 at 10:26 am
I guess I wasn't clear. What I did was create a table with one row in it, and tie it to a dataset that returns many rows (I made it return 3 rows). Each row would create one row in the table and then do a page break. So I got three pages, each page containing one of the rows from the dataset result, and each of the row pages contained different data, exactly the data I expected them to contain. So I already did do the test you are suggesting.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply