One page report, One query, displaying multiple pages

[Paul]

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.

[Stef]

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

[Paul]

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

[Stef]

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

[Paul]

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

[Stef]

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

[Paul]

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?

 

[Stef]

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