Learn how to a build a cloud-first strategyRegister Now


Row per page in reporting service

Posted on 2009-02-22
Medium Priority
Last Modified: 2012-06-21
I m the begineer for reporting service. Now i m learning and creating report. Now i face a problem in reporting service.
I have two table in dataset. The first data table is for student list and second data table is for module list.
At student list data table(StudentID, StudentName, EnrNo)
At module list data table (EnrNo, Module title, Module code)
I designed main report and subreport at my local report (rdlc).
 main report is binding with student list data table and subreport want to bind with the module list. Main report and sub report linkage is EnrNo.
I would like to show each row for one student in first page and second row for second student in second page and so on.

How can i manage in reporting service for each row per page?
How can i bind with module datatable with subreport?
How can i link with main report and subreport with EnrNo?
Please give me advice?
Question by:THE_KO
1 Comment
LVL 21

Accepted Solution

Yurich earned 2000 total points
ID: 23802007
Sorry, m8, a bit hard to understand what you're talking about :-(

It sounds like you're trying to have a built-in report in your application. In which case you'd just call your report and specify parameters. You don't handle report's datasets and report's datasets can't have multiple tables - they're different from .NET application's datasets.

Nevertheless, to answer your particular question, that's how you can have a break for each row of your data:

Create a group where your group on your primary key (e.g. if you have students, group on student ids). Then in the report, put all details not in the report details, but in the group header (or footer). Then in the properties of your group, tick "page back at end". It may produce an extra blank page at the end of the report - not much you can do about it.

Good luck,

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
How to increase the row limit in Jasper Server.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Screencast - Getting to Know the Pipeline
Suggested Courses
Course of the Month21 days, 6 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question