This is a migrated thread and some comments may be shown as answers.

One page report, One query, displaying multiple pages

7 Answers 975 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Paul
Top achievements
Rank 1
Paul asked on 31 Oct 2016, 02:51 PM

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.

7 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 31 Oct 2016, 03:46 PM
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
0
Paul
Top achievements
Rank 1
answered on 31 Oct 2016, 04:18 PM

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

0
Stef
Telerik team
answered on 01 Nov 2016, 09:45 AM
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
0
Paul
Top achievements
Rank 1
answered on 01 Nov 2016, 09:51 PM

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

0
Stef
Telerik team
answered on 02 Nov 2016, 04:18 PM
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
0
Paul
Top achievements
Rank 1
answered on 02 Nov 2016, 07:22 PM

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?

 

0
Stef
Telerik team
answered on 03 Nov 2016, 05:42 PM
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
Tags
Report Designer (standalone)
Asked by
Paul
Top achievements
Rank 1
Answers by
Stef
Telerik team
Paul
Top achievements
Rank 1
Share this question
or