all the table data in one page!

23 posts, 0 answers
  1. Fatima Mohey
    Fatima Mohey avatar
    12 posts
    Member since:
    Sep 2009

    Posted 02 Nov 2009 Link to this post

    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?!!!!
  2. Steve
    Steve avatar
    1851 posts
    Member since:
    Dec 2008

    Posted 02 Nov 2009 Link to this post

    You mean in the viewer right?  Exporting to PDF looks okay?
  3. DevCraft banner
  4. Fatima Mohey
    Fatima Mohey avatar
    12 posts
    Member since:
    Sep 2009

    Posted 03 Nov 2009 Link to this post

    yes, right!
  5. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 03 Nov 2009 Link to this post

    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.
  6. Fatima Mohey
    Fatima Mohey avatar
    12 posts
    Member since:
    Sep 2009

    Posted 03 Nov 2009 Link to this post

    sorry, so does it mean there's no way to divide the table into pages?!!!!
  7. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 03 Nov 2009 Link to this post

    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.
  8. David Hunter
    David Hunter avatar
    2 posts
    Member since:
    Jan 2009

    Posted 17 Mar 2010 Link to this post

    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

  9. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 18 Mar 2010 Link to this post

    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.
  10. Steve
    Steve avatar
    1851 posts
    Member since:
    Dec 2008

    Posted 18 Mar 2010 Link to this post

    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
  11. Eduardo
    Eduardo avatar
    2 posts
    Member since:
    Aug 2010

    Posted 01 Mar 2011 Link to this post

    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.
  12. Farid Hayati
    Farid Hayati avatar
    17 posts
    Member since:
    Mar 2011

    Posted 12 Jul 2011 Link to this post

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

    Thanks a lot
  13. Steve
    Steve avatar
    1851 posts
    Member since:
    Dec 2008

    Posted 12 Jul 2011 Link to this post

    @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.
  14. Eduardo
    Eduardo avatar
    2 posts
    Member since:
    Aug 2010

    Posted 12 Jul 2011 Link to this post

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

    Just pray for not getting a timeout exception.
  15. Farid Hayati
    Farid Hayati avatar
    17 posts
    Member since:
    Mar 2011

    Posted 12 Jul 2011 Link to this post

    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.

  16. Steve
    Steve avatar
    1851 posts
    Member since:
    Dec 2008

    Posted 12 Jul 2011 Link to this post

    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
  17. Vassil Petev
    Admin
    Vassil Petev avatar
    1765 posts

    Posted 12 Jul 2011 Link to this post

    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

    Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

  18. Isaac
    Isaac avatar
    21 posts
    Member since:
    Dec 2008

    Posted 18 Nov 2011 Link to this post

    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.
  19. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 21 Nov 2011 Link to this post

    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

    Q2’11 SP1 of Telerik Reporting is available for download (see what's new). Get it today.

  20. Waqas
    Waqas avatar
    2 posts
    Member since:
    May 2014

    Posted 29 May 2014 Link to this post

    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?
  21. Waqas
    Waqas avatar
    2 posts
    Member since:
    May 2014

    Posted 29 May 2014 in reply to Waqas Link to this post

    Edit: you can't do Paging in telerik reports
  22. Stef
    Admin
    Stef avatar
    3044 posts

    Posted 03 Jun 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  23. Sunil
    Sunil avatar
    1 posts
    Member since:
    Oct 2015

    Posted 16 Sep in reply to Stef Link to this post

    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

     

  24. Stef
    Admin
    Stef avatar
    3044 posts

    Posted 16 Sep Link to this post

    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
    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