Row per page in reporting service

Posted on 2009-02-22
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

    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

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now