One page report, One query, displaying multiple pages

8 posts, 0 answers
  1. Paul
    Paul avatar
    29 posts
    Member since:
    May 2011

    Posted 31 Oct Link to this post

    Im using Visual Studio telerik report designer.
    Im trying to display a one page report with the following query result:

    ReportName  Office   ReportInstruction  ContactName ContactPhone  Relevant Info
    Report01       Ontario   Print It Out                Tom            123456789      ABC

    Report01       Ontario   Print It Out                Tom            123456789      DEF

    Report01       Ontario   Print It Out                May            987654321      ABC

    Report01       Ontario   Print It Out                May            987654321      DEF


    Report layout:
    Header
    ReportName: Report01
    Office: Ontario
    Contact Information:
    Tom: 123456789
    May: 987654321
    Relevant Info
    ABC
    DEF

    The way Im doing it now is:

    I put [=Fields.ReportName] and [=Fields.Office] in ReportHeaderSection (So these only show up once)
    Then I put Contact Information in GroupHeaderSection (group by ContactName)
    Then I tried to put Relevant Info. In footerSection (Group By Relevent Info)

    The report comes out in many pages and lots of space in between.

  2. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 31 Oct Link to this post

    Hi Paul,

    You can use the Table item that is rendered into a single continuous page in interactive preview. If you switch the viewer's ViewMode to PrintPreview, the content will be paged based on the report's PageSettings properties - Understanding Pagination. As of R3 2016, there is PageSettings.ContinuousPaper property.


    I hope this helps.

    Regards,
    Stef
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
  4. Paul
    Paul avatar
    29 posts
    Member since:
    May 2011

    Posted 31 Oct in reply to Stef Link to this post

    Can you elaborate on this more. Cause I used table and still getting multiple duplicated record. My problem is mainly the multiple duplicated record than the paging.

     

    So for example I might get something like this:

    Header
    ReportName: Report01
    Office: Ontario

     

    Contact Information:
    Tom: 123456789

    Relevant Info:
    ABC

    Contact Information:

    Tom: 123456789

    Relevant Info:
    DEF

     

    Contact Information:

    May: 987654321

    Relevant Info

    ABC

    Contact Information:
    May: 987654321
    Relevant Info:
    DEF

     

     

    I think it's basically showing one entry per page

  5. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 01 Nov Link to this post

    Hi Paul,

    If you use a Table item, please check if by mistake you set both the report and Table DataSource properties. The report and the Table item are separate data items, each repeating its template for the assigned data.
    Check also if sections have their PageBreak set to anything different than None, and if yes - reset the property.

    In order to provide you more accurate suggestions, please post the code generating the report's template.

    Regards,
    Stef
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  6. Paul
    Paul avatar
    29 posts
    Member since:
    May 2011

    Posted 01 Nov Link to this post

    Hi Stef,

     

    I checked that all pageBreak is set to None. KeepTogether all set to True. Table datasource properties is set to nothing. I took it out for now so I can show u the code. 

     

     

    Designer:
    https://imagebin.ca/v/30WTgovOtyGW

    Behind Code :

    http://rextester.com/USLACQ33392

     

    In GroupHeaderSection it is group by ContactCodeDescription.

     

    Im not sure why there will be duplicate entry like the sample I showed u in the earlier posts. It matches the dataSource (the result generated by a basic query, please check example given in earlier post, there are duplicate entries), but shouldnt the grouping group them together?

     

    Thanks

  7. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 02 Nov Link to this post

    Hi Paul,

    Please let us know what changes must be made in the report in the attachment in order to reproduce the problem. The project uses v10.2.16.1025 (R3 2016 SP1) that can be changed by running the Upgrade Wizard.
    The report is connected to test data in the report's constructor.

    Regards,
    Stef
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  8. Paul
    Paul avatar
    29 posts
    Member since:
    May 2011

    Posted 02 Nov in reply to Stef Link to this post

    Im getting a error on designer 'The designer could not be shown for this file because none of the classes within
    it can be designed. The designer inspected the following classes in the file:
    Report1 --- The base class 'System.Object' cannot be designed.'

     

    So in the example I've provided in the first post. It is possible to do without having to create a separate query right?

     

    I think a simpler approach to fixing this is for you to tell me if I'm doing everything correctly, 

    Again a simplified example:

    My query is a simple select from where that output a result similar to:

    ReportName  Office   ReportInstruction  ContactName ContactPhone  Relevant Info
    Report01       Ontario   Print It Out                Tom            123456789      ABC
    Report01       Ontario   Print It Out                Tom            123456789      DEF
    Report01       Ontario   Print It Out                May            987654321      ABC
    Report01       Ontario   Print It Out                May            987654321      DEF

     

    My desired result:

    ReportHeaderSection1
    ReportName: Report01
    Office: Ontario

    Contact Information:
    Tom: 123456789
    May: 987654321

    Relevant Info:
    ABC
    DEF

    Result I get:

    ReportHeaderSection1
    ReportName: Report01
    Office: Ontario

    Contact Information:
    Tom: 123456789
    Relevant Info:
    ABC

    Contact Information:
    Tom: 123456789
    Relevant Info:
    DEF

    Contact Information:
    May: 987654321
    Relevant Info
    ABC

    Contact Information:
    May: 987654321
    Relevant Info:
    DEF

     

    Can you guide me on how I should put everything. For example: Am I right to put the ReportName, OfficeName in the reportHeaderSection? Am I right to put the contact stuff in groupHeaderSection and group it by ContactName? Then Put relevant info in groupFooterSection?

     

  9. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 03 Nov Link to this post

    Hello Paul,

    Please run the Upgrade Wizard to update the project settings.
    About the expected layout, please check the attached video in IE browser (it is a SWF file). It illustrates several approaches based on grouping data and using nested data items.

    the demo reports can be checked in the Standalone Report Designer of Telerik Reporting R3 2016 or newer.

    Regards,
    Stef
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
DevCraft banner