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)
Report header not displaying data when using multiple inputs(BIRT/Maximo)
koshysan
Greetings all,
I have a request from a client to generate a modified work order details report based on the OOB work order details report.
One of the requirement was to have "Work Order Details" & workorder number in the header.
I set up a dynamic text which did that and this works when I run this report for just one work order.
When i run this report for multiple work orders, all other information in the report display correctly but the header always displays the first work order number for all work orders.
For example - I have chosen to run the report for work orders 100,101,102.
It displays Work Order Details 100 for all three work orders.
I have been trying various things and am starting to pull my hair out.
Any suggestions?
Thx.
Find more posts tagged with
Comments
micajblock
What is the expression you are using to display the header. Also is the report grouped by work order? Is the report item in the table header of the group header?
koshysan
Ahh mblock - we meet again. You seem to be always first in helping others -
.
All right I got this to work by putting the header within the group header section. It was initially in the table header section.
I still dont get how to cycle through the values when you have multiple inputs of the same parameter (in the header area). It only displays the very first value on all the pages. I would have thought it would cycle through all the values because the main data set should be available globally (am I wrong here?). It does display the first one correctly.
The report I am referring to here is the woprint.rptdesign that is a OOB report. I have modified it to meet requirements.
Formula --> Work Order Details - Work Order Number:"+row["wonum"];
micajblock
<blockquote class='ipsBlockquote' data-author="'koshysan'" data-cid="90287" data-time="1323209249" data-date="06 December 2011 - 03:07 PM"><p>
I still dont get how to cycle through the values when you have multiple inputs of the same parameter (in the header area). It only displays the very first value on all the pages. I would have thought it would cycle through all the values because the main data set should be available globally (am I wrong here?).<br />
<br />
Formula --> Work Order Details - Work Order Number:"+row["wonum"];<br /></p></blockquote>
<br />
Each header will get evaluated only once. So the table header once for the whole table, a group header once for each group break. So you just need to know that and place the expression at the right place.<br />
<br />
BTW, 'row["wonum"]' is not a parameter but the value coming back from the query.
deepikapc
<p>hi all</p>
<p> </p>
<p>i have doubt i have created new custom birt report and add the scripted data source and written script in open() and fetch() to data set</p>
<p> </p>
<p>and have created layout</p>
<p> </p>
<p>and when i am running the report in maximo it is showing only header and footer and not displaying values </p>
<p> </p>
<p>please suggest me </p>