Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: loops in reports

  1. #1

    Default loops in reports

    heey guys

    missed you from my last posting

    i have something i need to make it, but i don't how or how to start

    i have table in my DB , it contains calculations for bank branches

    and have a report to display that calculations , it consists of cover page and another page contains the calculations

    the thing i wanna to do is

    i have many branches, and it is not logic to make the same report for each branch , "the difference will be only in the where clause in the query , i'll change branch_id value"


    soo, i need to loop on the branch values and print the report for every branch , so if i have 10 branches , the report will be 20 pages , "cover page and calculation page for each one"


    how can i do this ???

    waiting the replies, and thanks in advance

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    Sort and Group by branch_id. Use the group-header for the summary page and then subgroups and itemband as usual for the next page. Just enforce a pagebreak before and after-print on the group header and everything will be fine.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  3. #3

    Default

    Thanks taque , it works


    but i need another thing :$

    is it possible to seperate these reports based on groups in different pdfs ????

  4. #4
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    Yes, but that then has to happen inside an XAction in the platform (or in Java code, if you dont use the platform). The concept behind that is called bursting, and there are samples for that contained in the BI-server download.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  5. #5

    Default

    good it exists in pentaho

    but, i searched alot and i can't find any steps to make burst or any guides, jut telling that pentaho has burst for reports and concept of bursting

    isn't there any tutorials that describes how to do it

    and aboutthe sample you mentioned , is it a seperate sample , "i downloaded the trial version of BI , but which sample exactly ?


    thanks in avance

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.