Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Summarizing Status column
Migrateduser
<p>Hi,</p>
<p> </p>
<p>I am a newbie in BIRT and have just started working on a report. Below is the final layout of report that I am working on and I am not sure <strong>how to deduce </strong>the <strong>overAll status </strong>for each entry under Col1. Basically we need to summarize the status of all the entries belonging to A1 and if there is any 'Fail' in there, then the overAll status is to be marked as <u>Fail</u>. The examples that I have seen in other topics deal with Aggregation/sum of integers. I haven't come across any thing which deals with String. Would really appreciate any help with this.</p>
<p> </p>
<p>Col1 Col2 Status</p>
<p>...............................................</p>
<p>A1 B1 Pass</p>
<p> B2 Fail</p>
<p> B3 Pass</p>
<p>........................................</p>
<p> <strong>OverAll </strong>Fail</p>
<p>.........................................</p>
<p>A2 B1 Pass</p>
<p>.......................................</p>
<p> <strong>OverAll </strong>Pass</p>
<p>........................................</p>
<p> </p>
<p> </p>
<p>Thanks</p>
<p>Shwt</p>
Find more posts tagged with
Comments
There are no comments yet