all the table data in one page!

[Fatima Mohey]

Hello Guys,
i'm using table to display data from database, but i don't know why all the data of the table is displayed in one page with vertical scrollbar and is not divided in other pages although i'm setting keep together property to false.

any ideas?!!!!

[sitefinitysteve]

You mean in the viewer right?  Exporting to PDF looks okay?

[Fatima Mohey]

yes, right!

[Steve]

Hello Fatima,

As explained in the Design Considerations for HTML Rendering help article, KeepTogether is always true for the HTML rendering extension, due to the fact that it is not a page oriented format.

Greetings,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Fatima Mohey]

sorry, so does it mean there's no way to divide the table into pages?!!!!

[Steve]

Hi Fatima,

That is correct - if you take a look at the help article I've referenced you would notice that all items in a section would be displayed in a single page in the HTML rendering extension.

Greetings,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[David Hunter]

Hi Steve,

So you are saying that this is impossible to be done, or just Telerik refuse to implement it?

I know Crystal Reports can do HTML paging of sections, particulary CrossTabs.

It should not be that hard to split a section accross page, when you already split the report as a whole over pages. So just dividing the section is a problem? I disagree.

Br,

Dave

[Steve]

Hello David,

The output of a report rendered in HTML and PDF differs because both medias are quite different. The 1st (HTML) is dedicated to displaying information on screen and the page is infinite by width and height; in contrast the 2nd format - PDF - supports physical pages and is meant not only for reading on screen but for printing.

According to whether the format supports physical pages, we separate the export formats on two groups: page-oriented (PDF, Image (print preview), print, XPS, RTF) and non-page oriented (HTML/MHTML, Excel, CSV).

For the page-oriented formats the content layout is on horizontal and vertical pages according the the page settings of the report, while for the rest of the formats take into considerations other characteristics of the media like the grid of the Excel worksheet.

That said there is no technical limitation that we're trying to work around with the current implementation but our understanding on the matter.

Anyway we will appreciate if you can share with us why do you need "physical pages" when viewing the report in the browser. I'm asking this question because our current goals are to start making the viewers more interactive thus giving the end users freedom to manipulate their reports according to their specific needs.

Sincerely yours,
Steve
the Telerik team

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 Public Issue Tracking system and vote to affect the priority of the items.

[sitefinitysteve]

I think it's a strange thing to do...if we wanted a webpage we'd be dropping on some RadControls and showing the data not constrained to a report viewer.

What we're needing to do is show the user what their report page would look like before they print it so they might not even need to print it.  It's a strange behaviour to NOT have it break and separate to another page...

Put up a poll on the subject, I'm sure the majority of users would prefer a hard break to a new page

[Eduardo]

How is this possible?,

Even in the web report controls of Microsoft's reporting services, you can make a table to break in different pages in certain specific points.

Please guys try to add this functionality.

[Farid Hayati]

If its not possible how I suppose to render a table report with more than 100.000 rows?

Thanks a lot

[sitefinitysteve]

@Farid,
  Pretty sure in the next couple releases they're re-doing, or fixing the html viewer to be faster and render better...so I am hoping this also gets fixed....clearly it's something users want.

[Eduardo]

@Farid,
How about waiting a couple of hours :).

Just pray for not getting a timeout exception.

[Farid Hayati]

Telerik html rendering doesn't make sence. all kind of reports should have paging. otherwise we can write our own reporting engine which is just a html table. There should be a solution for large enterprise reports.

[sitefinitysteve]

It looks like the "Whats New" page has been pre-maturely updated :D

What's New in Q2 2011

Version 5.1.11.712, released on July 13, 2011

<admin>content removed, because it could change for the official release</admin>

I see nothing about the viewer changing or adding paging though...so...darn

[Vassil Petev]

Indeed, the What's New in Q2 page for Telerik Reporting was briefly posted on the site (work in progress). We also confirm that Q2 will include many performance optimizations. The release is due tomorrow, and we will update the What's New page with the latest information tomorrow.


Greetings,
Vassil
the Telerik team

[Isaac]

Any update on Paging through millions of records? I am working on a Global project that is connected a very large database. There could be at any time thousands to millions of records returned in the reports we are working on. We switched to Telerik instead of using crystal reports or SSRS. Any help you can provide is great. Thanks.

Sincerely,

Isaac Koss.

[Steve]

Hi Isaac,

In this thread we discuss the way the Web Report Viewer pages the report and not whether Telerik Reporting can handle millions of records. Telerik Reporting is an embedded reporting engine, which primary goal is to analyze data and represent it in a human-readable format that is also suitable for printing. During this process, certain complex layout and paging rules are applied, so the great flexibility offered by the reporting engine comes at a price: increased processing times and memory footprint. You should agree that dumping millions of records from a database at once hardly fit in the category of report generation. Perhaps in your specific scenario another component such as our RadGrid control might be more appropriate, moreover our RadGrid control offers several export options.

Back to the original inquiry in this thread, in Q3 2011 we introduced Interactive view and Print Preview for all report viewers, so for those of you that need to show the report in your app as it would be printed, set the ViewMode property of the viewers to PrintPreview.

Greetings,
Steve
the Telerik team

[Waqas]

Hi Telerik,

What I understand from all of above discussion is you can do Paging in telerik reports. if u want to show hundreds of rows it will all be shown in one page. right?
As far as as interactive view, it still shows all record on one page and Print preview is not preferable to display hundreds of record. Is there any way i can do paging in interactive view?

[Waqas]

Edit: you can't do Paging in telerik reports

[Stef]

Hello Waqas,

The report and the resources required for its generation are processed at once on the server and served to the web viewer.

If in your layout is used a Table/Crosstab/List item, in Interactive Preview the data will be displayed on a single page. If you switch to Print Preview, the reporting engine applies paging on the report according to the set report's PageSettings. For more details check the Interactive vs. Print Layout and Understanding Pagination articles.

In case there is a large amount of data for the report, you can use report parameters and filter it on retrieval or in the report, in order to reduce the time for the report generation - this is similar to the paging in grid controls. For the purpose you can use a custom data retrieval method and an ObjectDataSource component in the report, where the method's controlling parameters are mapped to report parameters - Using Parameters with the ObjectDataSource Component.

I hope this information helps you.

Regards,
Stef
Telerik

 

 

[Sunil]

Hi,

I'm using Telerik Reporting Q3 2015 template for reports. I want display Excel report in different pages like pdf report. Is there any possibility/ Any new feature to achieve this?

Thanks,

Sunil

 

[Stef]

Hello Sunil,

If you are exporting Telerik reports in Excel format, you can place content in separate sheets by using a ReportBook - Design Considerations for Excel Rendering. For more details, please check the ReportBook overview article.

Regards,
Stef
Telerik by Progress