Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Creat sheets in a Excel Report with Report Designer

  1. #1
    Join Date
    Nov 2007
    Posts
    11

    Default Creat sheets in a Excel Report with Report Designer

    Hi

    Can somebody describe me how I can create several sheets in my excel Report?

    Thanks a lot.


  2. #2

    Default

    if you want to use several sheets enter a page break and jfree will automatically add the next report to the next sheet.

    tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  3. #3
    Join Date
    Nov 2007
    Posts
    11

    Default

    Thanks for your advice!

    How can I manually create a pagebreake? Is there a possibility to name the sheets??

    Tanks.

  4. #4

    Talking Sheet Development

    To new sheet and name
    1) Build your report as a sub-report.
    2) Add a style expression to the sub-reports page header for computed_sheetname:="<your tab name>" to name your sheet
    3) Change the subreports report header Page Break Before to True to have the new sheet/tab appear.
    4) To add a hyperlink use #<your tab name>!A1. That will allow you to have navigation between the tabs. So put on the main tab a hyperlink to the subtabs and link on the subtabs back to the main.
    Last edited by alittledog; 03-04-2008 at 12:12 PM. Reason: Skiped a note or two

  5. #5
    Join Date
    Nov 2013
    Posts
    7

    Default

    Hi,

  6. #6
    Join Date
    Nov 2013
    Posts
    7

    Default

    Hi,
    Please help me on 4th point.... how to create hyperlink between she
    ets in pentaho

  7. #7
    Join Date
    Jul 2016
    Posts
    1

    Question Second sheet not created

    I renamed my first sheet,but not able to create the second sheet.Can you help?

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.