Multi tab Excel reports using Birt Designer

tejasri
tejasri
edited February 11, 2022 in Analytics #1
<p>Is there a way to get multitab Excel Reports in Birt ???</p>
<p> </p>
<p>My Req:</p>
<p> </p>
<p>Table1:</p>
<p> A   B    C  D</p>
<p>---  ---  --- ---</p>
<p>          </p>
<p>Table 2:</p>
<p>E     F  G </p>
<p>---  ---  --- </p>
<p> </p>
<p>I want multitabs for B column data and columns A,C,D,E,F,G should group according to pramater B is it possible??Any help appreciated.</p>

Comments

  • G-Man
    G-Man
    #2
    <p>You need to provide Pagebreak at grouping and while downloading excel output make sure you check these options .. Export Content -> Page Settings -> Output to Multiple Sheets = True. </p>
  • PriyaK
    PriyaK
    #3
    <p>Create group for B.</p>
    <p> </p>
    <p>In group details, select below settings for PageBreak section</p>
    <p> </p>
    <p>Before - Auto</p>
    <p>After - Always Excluding Last</p>
    <p>Inside - Avoid</p>
  • tejasri
    tejasri
    #4
    <p>Hi  priya,</p>
    <p> </p>
    <p>Thanks for the reply it worked...</p>
    <p> </p>
    <p>And one more scenario, suppose i have two tables in a report and i want to generate multitabs based on a column .. but when i generate the report first sheet i will have the two tables data.. but in the second tab i ll get only the table which group has been applied. any suggestions for this if i want to get both tables data in each tab..Thankyou</p>
  • tejasri
    tejasri
    #5
    <p>Hi,</p>
    <p>I m facing issues with Multi tab nested report. so many duplicated in the report and Ang getting only one row in 1st table</p>
    <p> </p>
    <p>Ex:</p>
    <p>I want to show case in the report as ...</p>
    <p>Month,Duration,%,Name</p>
    <p> </p>
    <p> </p>
    <p>Start,End,Name,Duration   for each Name ...Attaching the rpt design. Any help plss</p>
    <p> </p>
    <p> </p>
    <p> </p>
    <p> </p>
    <p> </p>

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs