Home
Intelligence (Analytics)
How create multiple sheets in excel output sheet
kesavulu
<p>Hello,</p><p> </p><p>I am new in BIRT design, I am using 3.7.2 version, i need one help for design one report please help ASAP.</p><p>How to create multiple sheets in excel and how to make it names for every sheet.</p><p>Can you please kindly send me how to make report step by step process with screen short?</p><p>I made one query for my report it's coming in single sheet but I need separate with sheet wise.</p><p>Please find attachment for my requirement.</p><p> </p><p>Thanks</p><p>Kesav</p>
Find more posts tagged with
Comments
kclark
<p>Do you need to use 3.7.2? 4.3 has the spudsoft emitter. You can create new tabs by page breaks and name them by using the bookmarks in the grouping UI of the table.</p>
kesavulu
<p>Dear Kclark,</p><p>Thanks for immediate response,</p><p>[font="calibri, sans-serif;"]<span style="font-size:11pt;">Can you please explain me every step by step in 4.3 only, I can upgrade my application from 3.7 to 4.3.[/font]</span></p>
kesavulu
<p>Dear,</p><p>I am able to generate report with sheet wise through BIRT 4.3 using groups with help of AS XLS Spud _Soft, But I need to add sheet break in between two tables can you please help me how it's possible, I have query for each sheet separately.</p><p>Please find out attacthment for my requirement</p><p><a data-ipb='nomediaparse' href='
https://hotfile.com/dl/239388297/f9c4c4d/District_Consolidated_-_DEID.xls.html'>https://hotfile.com/dl/239388297/f9c4c4d/District_Consolidated_-_DEID.xls.html</a></p>
;
kclark
<p>First click on the entire table. Then in the property editor select groups then add. From the drop down choose what you want to group on. Then in the page break section change after to always. Then you need to set the bookmark to name the tabs. Click on the expression builder icon next to it and insert the same row you had grouped on. Then click ok in the groups. Now view your report > export > export to XLS, make sure to use the spudsoft emitter.</p>
kesavulu
<p>Dear Kclark,</p><p> </p><p>It's working fine, thanks a lor for you support</p>
kclark
<p>You're welcome!
</p>
kesavulu
<p>Dear Kclark,</p><p> </p><p>Can you please explan me how to add calendar as a parameter in BIRT 4,3.</p><p> </p><p>Thanks</p><p>Kesav</p>
kclark
<p>Take a look at <a data-ipb='nomediaparse' href='
http://www.birt-exchange.org/forum/index.php?/topic/28327-datepicker-for-the-paramerter-dialog-box-in-2-6-3-version/'>this
post</a>, it shows how you can use JSCal2 as a date picker for your date parameters.</p>
kesavulu
<p>[font="'times new roman', serif;"]<span style="font-size:12pt;">Dear Kclark,[/font]</span></p><p> </p><p>[font="'times new roman', serif;"]<span style="font-size:12pt;">I need one help about cascade parameters[/font]</span></p><p>[font="'times new roman', serif;"]<span style="font-size:12pt;">For example I have 5 levels like[/font]</span></p><ul class='bbcol decimal'><li>[font="'times new roman', serif;"]<span style="font-size:12pt;">Country [/font]</span> </li><li>[font="'times new roman', serif;"]<span style="font-size:12pt;">District[/font]</span> </li><li>[font="'times new roman', serif;"]<span style="font-size:12pt;">CHC[/font]</span> </li><li>[font="'times new roman', serif;"]<span style="font-size:12pt;">PHC[/font]</span> </li><li>[font="'times new roman', serif;"]<span style="font-size:12pt;">SC[/font]</span></li></ul><p> </p><p>[font="'times new roman', serif;"]<span style="font-size:12pt;">I created for these levels as cascade parameters[/font]</span></p><p>[font="'times new roman', serif;"]<span style="font-size:12pt;">I have query with one parameter for level names.[/font]</span></p><p>[font="'times new roman', serif;"]<span style="font-size:12pt;">I can link this parameter only one level like <strong>Country or District or CHC, or PHC or SC</strong> [/font]</span></p><p>[font="'times new roman', serif;"]<span style="font-size:12pt;">But the problem is level selection is dynamic so how to linked that parameter to my query.[/font]</span></p><p>Can you please help me how to do this and please find attachment for screen shorts</p><p> </p><p>Thanks</p><p>Kesav</p><p> </p>
kclark
<p>Take a look at <a data-ipb='nomediaparse' href='
http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/cascade/index.php'>this
page</a> and let me know if you have any questions
</p>
kesavulu
<p>[font="'times new roman', serif;"]<span style="font-size:12pt;">Dear Kclark,[/font]</span></p><p>I followed this link <a data-ipb='nomediaparse' href='
http://terrarum.net/administration/adding-a-calendar-widget-to-birt.html'>http://terrarum.net/administration/adding-a-calendar-widget-to-birt.html</a>
; for adding calender.</p><p>I added calender in BIRT but i am able to see the calender in only web viewer( via Eclipse -> Run -> View Report -> In Web Viewer) option correctly displays the Calendar widget.<br />
But I need the calender when i generate report in as xls format, Here I get the button with … to select calendar widget, but no widget appears<br />
Can you please help me any one I need to add calender here.</p><p> </p><p>Thanks</p><p>Kesav</p>
