nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Repeating the Page Layout for List of Data Set Values.

SiddamS

Hi all,
We have a requirement to repeating the Layout for List of Data set Values.

Our DataSource is Xml file.
Xml DataSource is Formatting as below :-

<employee-scorecard-list>
<employee-scorecard-report>
<user-fullname>Vamsi</user-fullname>
<overview-portlet>
<portlet-title>Overview</portlet-title>
<user-title>Director, Corporate Human Resources</user-title>
<overall-rating-label>Overall Rating</overall-rating-label>
<overall-rating/>
</overview-portlet>
<perf-history-portlet>
<portlet-title>Performance History</portlet-title>
<form-source-label>Form/Source</form-source-label>
<overall-rating-label>Performance</overall-rating-label>
<potential-rating-label>Potential</potential-rating-label>
<competency-rating-label>Success Factor</competency-rating-label>
<objective-rating-label>Objective</objective-rating-label>
<form-due-date-label>Due Date</form-due-date-label>
</perf-history-portlet>
<obj-ratings-portlet>
<portlet-title>Objective Ratings</portlet-title>
<obj-name-label>Objective</obj-name-label>
<obj-rating-label>Rating</obj-rating-label>
<objective-list>
<objective>
<obj-name>Performance.</obj-name>
<obj-rating>0</obj-rating>
<obj-rating-scale-min>1</obj-rating-scale-min>
<obj-rating-scale-max>5</obj-rating-scale-max>
</objective>
<objective>
<obj-name>Self Learning</obj-name>
<obj-rating>0</obj-rating>
<obj-rating-scale-min>1</obj-rating-scale-min>
<obj-rating-scale-max>5</obj-rating-scale-max>
</objective>
/employee-scorecard-report>
</employee-scorecard-list>

For each portlet we are taking into one table in Layout and Labels are placing on top of that Tables.

Requirement is :-
For each <employee-scorecard-report> format(means inner Elements) is same.so we need to repeat Total page Layout for Each<employee-scorecard-report>

<employee-scorecard-list> contains List of <employee-scorecard-report>.for each <employee-scorecard-report> need to repeat the total page Layout(means Tables and their data).Each <employee-scorecard-report> can have different set of Objects.

Note : we are using XML as Data Source not Database Queries.

Please give me any suggestions or supported URL to build this requirement.

Thanks and Regards
Swetha siddamshetty.

Find more posts tagged with

Comments

mwilliams

Hi Swetha,

Can you explain this a little bit more? I'm not sure I'm understanding what you're looking for. Maybe by showing what you want the output to look like for the xml data that you posted. Also, what version of BIRT are you using?

SiddamS

Hi Michael,
Thank you for your Quick reply and I am very new to the BIRT.

My Requirement is :-
Using BIRT we need to generate the reports(not xml output) for XML DataSource.

Here I am enclosing one more data Source which explains clearly my requirement :-

DataSource :-

============================================

<employee-scorecard-list>
<employee-scorecard-report>
<user-fullname>Swetha</user-fullname>
<overview-portlet>
<portlet-title>Overview</portlet-title>
<user-title>Director, Corporate Human Resources</user-title>
<overall-rating-label>Overall Rating</overall-rating-label>
<overall-rating/>
</overview-portlet>
<perf-history-portlet>
<portlet-title>Performance History</portlet-title>
<form-source-label>Form/Source</form-source-label>
<overall-rating-label>Performance</overall-rating-label>
<potential-rating-label>Potential</potential-rating-label>
<competency-rating-label>Success Factor</competency-rating-label>
<objective-rating-label>Objective</objective-rating-label>
<form-due-date-label>Due Date</form-due-date-label>
</perf-history-portlet>
<custom-background-portlet1>
<portlet-title>Career Plan - Manager and HR View</portlet-title>
<bgd-header>
<bgd-label0>Type</bgd-label0>
<bgd-label1>Title</bgd-label1>
<bgd-label2>Function</bgd-label2>
<bgd-label3>Company Size</bgd-label3>
<bgd-label4>Timing</bgd-label4>
<bgd-label5>Manager Comments</bgd-label5>
<bgd-label6>Reassignment Required</bgd-label6>
</bgd-header>
<bgd-rows>
<bgd-row>
<bgd-col0>Next Assignment</bgd-col0>
<bgd-col1>Director</bgd-col1>
<bgd-col2>Business Development</bgd-col2>
<bgd-col3>Over 1B</bgd-col3>
<bgd-col4>Q4 2010</bgd-col4>
<bgd-col5>Georgeann is completing an MBA with the desire to get into a GM track. A potential move would be in Strat Dev based in DC.</bgd-col5>
<bgd-col6>No</bgd-col6>
</bgd-row>
<bgd-row>
<bgd-col0>Alternative Assignment</bgd-col0>
<bgd-col1>Manager</bgd-col1>
<bgd-col2>Marketing</bgd-col2>
<bgd-col3>301-500M</bgd-col3>
<bgd-col4>Q4 2010</bgd-col4>
<bgd-col5>Another entry into GM could be Marketing, which could also leverage her MBA</bgd-col5>
<bgd-col6>Yes outside current company</bgd-col6>
</bgd-row>
<bgd-row>
<bgd-col0>Future Career Potential</bgd-col0>
<bgd-col1>****/GM</bgd-col1>
<bgd-col2>****/GM</bgd-col2>
<bgd-col3>101-300M</bgd-col3>
<bgd-col4>Q4 2014</bgd-col4>
<bgd-col5>Georgeann is untested outside of the HR function but based on her intellect, drive and past performance I think she could be an effective GM.</bgd-col5>
<bgd-col6>Yes outside current company</bgd-col6>
</bgd-row>
</bgd-rows>
</custom-background-portlet1>
</employee-scorecard-report>
<employee-scorecard-report>
<user-fullname>Himabindu</user-fullname>
<overview-portlet>
<portlet-title>Overview</portlet-title>
<user-title>Director, Corporate Human Resources</user-title>
<overall-rating-label>Overall Rating</overall-rating-label>
<overall-rating/>
</overview-portlet>
<perf-history-portlet>
<portlet-title>Performance History</portlet-title>
<form-source-label>Form/Source</form-source-label>
<overall-rating-label>Performance Evaluation</overall-rating-label>
<potential-rating-label>Potential rating</potential-rating-label>
<competency-rating-label>Persistent</competency-rating-label>
<objective-rating-label>Objective Rating</objective-rating-label>
<form-due-date-label>Due Date</form-due-date-label>
</perf-history-portlet>
<custom-background-portlet1>
<portlet-title>Career Plan - Manager and HR View</portlet-title>
<bgd-header>
<bgd-label0>Type</bgd-label0>
<bgd-label1>Title</bgd-label1>
<bgd-label2>Function</bgd-label2>
<bgd-label3>Company Size</bgd-label3>
<bgd-label4>Timing</bgd-label4>
<bgd-label5>Manager Comments</bgd-label5>
<bgd-label6>Reassignment Required</bgd-label6>
</bgd-header>
<bgd-rows>
<bgd-row>
<bgd-col0>Next Assignment</bgd-col0>
<bgd-col1>Director</bgd-col1>
<bgd-col2>Organization Development</bgd-col2>
<bgd-col3>Over 1B</bgd-col3>
<bgd-col4>Q4 2010</bgd-col4>
<bgd-col5>Georgeann is completing an MBA with the desire to get into a GM track. A potential move would be in Strat Dev based in DC.</bgd-col5>
<bgd-col6>No</bgd-col6>
</bgd-row>
<bgd-row>
<bgd-col0>Assignment</bgd-col0>
<bgd-col1>HR</bgd-col1>
<bgd-col2>Marketing</bgd-col2>
<bgd-col3>301-500M</bgd-col3>
<bgd-col4>Q4 2010</bgd-col4>
<bgd-col5>Another entry into GM could be Marketing, which could also leverage her MBA</bgd-col5>
<bgd-col6>Yes outside current company</bgd-col6>
</bgd-row>
<bgd-row>
<bgd-col0>Future Career Potential</bgd-col0>
<bgd-col1>****/GM</bgd-col1>
<bgd-col2>****/GM</bgd-col2>
<bgd-col3>101-300M</bgd-col3>
<bgd-col4>Q4 2014</bgd-col4>
<bgd-col5>Georgeann is untested outside of the HR function but based on her intellect, drive and past performance I think she could be an effective GM.</bgd-col5>
<bgd-col6>Yes outside current company</bgd-col6>
</bgd-row>
</bgd-rows>
</custom-background-portlet1>
</employee-scorecard-report>

</employee-scorecard-list>

====================================================

In Above DataSource :-
Under <employee-scorecard-report>(root Element) there is <user-fullname>(value in above resource is "Swetha" & "Himabindu").In above Data resource details for "swetha".(Data record for "Swetha") is there as well as for "Himabindu" is also there.

there can be more then one <employee-scorecard-report> under </employee-scorecard-list>.

above is the description regarding the Data Source xml file.

====================================================

Now Let's come to the report design :- we are taking each portlet has one data set and binding this data set when the table is intered into the Layout.

======================================

Swetha

Type Title Function
Next Assignment Director BusinessDevelopment

May 7, 2009 2:20 PM
=========================================

Above report Layout has to be repeat for List of <employee-scorecard-report> for dataSource.
the above design is for "swetha" same layout has to be report for "Himabindu" for that values also.

I need to repeat the Layout for Set of <employee-scorecard-report> under
</employee-scorecard-list>.

Please give me suggestions to start and build this requirement.

Thanks and Regards
Swetha.

mwilliams

Swetha,

So, you're just wanting to get like what I have in the following screenshot? Or am I not understanding correctly?

SiddamS

Michael,

yes.........Exactlly.But one more thing under table two records are there.That records has to be repeat when total page Layout is repeated.Number of records and values also varies from one user to another user.

Could you please help me.

Thanks and Regards
Swetha.

mwilliams

Swetha,

You could insert a page break after each record to get it to be on the next page. As for the column values being variable, you could hide the value of the header if the field value was null.

mwilliams

Swetha,

Here's and example report created in BIRT 2.3.2. It shows how to use grouping and page breaks to make your report look how you want as far as repeating your report for each person. I also included labels in rows showing that the values repeat for each page. Hope this helps. Let me know if you have any questions.

This uses your XML from above. You'll just need to save that in an xml file and set the dataSource to use that file.

SiddamS

Michael,
Thanks for your reply.It is working fine.....

.
But I need to repeat table content dynamically for each User also.

With your report design Report is diplaying as follows :-
====================================================

Himabindu
Type Title Function Company Size
Next Assignment Director Organization Development Over 1B

Swetha
Type Title Function Company Size
Next Assignment Director Business Development Over 1B

May 25, 2009 5:31 PM
===========================================================

But need to report following data for swetha as well as himabindu dynamically (Which is present under Career Plan - Manager and HR View Portlet)

<bgd-row>
<bgd-col0>Alternative Assignment</bgd-col0>
<bgd-col1>Manager</bgd-col1>
<bgd-col2>Marketing</bgd-col2>
<bgd-col3>301-500M</bgd-col3>
<bgd-col4>Q4 2010</bgd-col4>
<bgd-col5>Another entry into GM could be Marketing, which could also leverage her MBA</bgd-col5>
<bgd-col6>Yes outside current company</bgd-col6>
</bgd-row>

I mean under "Himabindu" and "swetha" ,need to display Dynamically multitple records according to DataSource .

Could you please help for me this.

Thanks and Regards
Swetha.

mwilliams

Swetha,<br />
<br />
This devShare post may help you with creating dynamic tables to achieve what you're wanting.<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/262-birt-dynamic-adding-tables-and-columns/#description'>BIRT: Dynamic Adding Tables and Columns - Designs & Code - BIRT Exchange</a><br />
<br />
Using a crosstab may also be an option.