Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Creating Muliple page reports with same heading
Sudhi
Hi,
I am creating report uisng scripted datasource. I wanted to know that how we can create reports that having muliple pages with same titles in all pages.Ex i want to create a report of all employees payslips for a month.It should display all the employees payslips for the month that having same types of titles.
And also i wanted to know is there any way to create a report using scripted datasource that having dynamic tables.
Thanks
Sudhi
Find more posts tagged with
Comments
mwilliams
Hi Sudhi,
I'm not sure if I'm understanding correctly, but as long as the title information is in the master page header or the header of the table or list, the title information would be able to be repeated on each page of the report.
Can you explain more about the dynamic tables?
Sudhi
Hi,
Thanks for your reply. Headings are in Master page only.But it is not a table.And Every
page contains different employee records(payslip).
In the normal simple reports We are using table that contains header row and detail row.
Here i cant use table.Because every page should contain different employee records.
And also i want to know how to create dynamic tables using scripted data source.
Waiting for your reply
Sudhi
mwilliams
Sudhi,
You should be able to group your table by employee, which would allow you to have each individual employee's information on their own table, on their own page if you use page breaks. Then you could use a table.
Can you explain what you mean by dynamic table? Scripted datasource shouldn't make a difference.
Sudhi
Hi,
In the Scripted datasource report we have predefined set of output parameters. But in my case some output parameters will change employee to employee.
For example Suppose One employee has a payroll output parameter 'A' but other employee will not have 'A' output parameter for them variable B is applicable.
Thanks
Sudhi
mwilliams
Sudhi,
So, your data would come in something like the following?
Employee | Value A | Value B
E1 | A1 | null
E2 | null | B2
E3 | null | B3
E4 | A4 | null
And you'd like it to just display the employee with the applicable value A or B? Do any employees ever have A and B? Just want to make sure I understand the issue before leading you down the wrong path.
Sudhi
Hi,
Sorry for the late reply.
My requirement is matching with your assumption.What i want is For different employees some of the components will differ,For eg : For emp1 ,components(output parameters) are A,B,C,D,E,F .For emp2 output parameter will be A,B,C .
The no of output columns will vary for different employees.It should come dynamically.
Waiting for your reply
Sudhi
mwilliams
Sudhi,<br />
<br />
If your data was like this:<br />
<br />
Employee,ValueType,Value<br />
emp1,A,1<br />
emp1,B,1<br />
emp1,C,1<br />
emp1,D,1<br />
emp1,E,1<br />
emp1,F,1<br />
emp2,A,1<br />
emp2,B,1<br />
emp2,C,1<br />
emp3,A,1<br />
emp3,B,1<br />
emp3,C,1<br />
emp3,D,1<br />
emp4,A,1<br />
emp4,B,1<br />
emp4,C,1<br />
emp4,D,1<br />
emp4,E,1<br />
emp5,A,1<br />
<br />
You could easily use a crosstab filtered by employee in a grouped table.<br />
<br />
With it like this:<br />
<br />
Employee,ValueA,ValueB,ValueC,ValueD,ValueE,ValueF<br />
emp1,1,1,1,1,1,1<br />
emp2,1,1,1,,,<br />
emp3,1,1,1,1,,<br />
emp4,1,1,1,1,1,<br />
emp5,1,,,,,<br />
<br />
It's a little more difficult. This post in the devShare may help you with dynamic tables of this type.<br />
<br />
<a class='bbc_url' href='
http://www.birt-exchange.com/devshare/designing-birt-reports/262-birt-dynamic-adding-tables-and-columns/#'>BIRT
: Dynamic Adding Tables and Columns - Designs & Code - BIRT Exchange</a>
