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)
Multiple Values in should come as CSV
Iira
Hi All,
I want to create one report like.
One LPN can have multiple shipment orders.
I am grouping(using page break) on LPN, so that if one LPN is having multiple shipment orders.
It should come in CSV (comma seperated values) format.
Please help me as ASAP.
Find more posts tagged with
Comments
mwilliams
If you've groped by LPN, you could include all your fields in the LPN group header and instead of using just the "Department" element to display the department, you could use an aggregation with the function of "concatenate" and use "," as the separator, instead.
Hope this helps. Let me know if you have questions.
Iira
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="74742" data-time="1300296073" data-date="16 March 2011 - 10:21 AM"><p>
If you've groped by LPN, you could include all your fields in the LPN group header and instead of using just the "Department" element to display the department, you could use an aggregation with the function of "concatenate" and use "," as the separator, instead.<br />
<br />
Hope this helps. Let me know if you have questions.<br /></p></blockquote>
Could u explain me it through example.
mwilliams
Can you post some of your data or some made up data that is similar, so I know what I'm working with? Also, what is you BIRT version?
Iira
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="74776" data-time="1300370412" data-date="17 March 2011 - 07:00 AM"><p>
Can you post some of your data or some made up data that is similar, so I know what I'm working with? Also, what is you BIRT version?<br /></p></blockquote>
<br />
Data as required is attached in excel.<br />
I followed procedure as mentioned by you, however how can avoid situation like as shown:
Iira
<blockquote class='ipsBlockquote' data-author="'Iira'" data-cid="74958" data-time="1300873482" data-date="23 March 2011 - 02:44 AM"><p>
Data as required is attached in excel.<br />
I followed procedure as mentioned by you, however how can avoid situation like as shown:<br /></p></blockquote>
To be exact, If <br />
One LPN is having two shipment orders (SO1, SO2),<br />
two Departments.<br />
LPN should not give two rows,it should concat them with comma.
Iira
<blockquote class='ipsBlockquote' data-author="'Iira'" data-cid="74962" data-time="1300875305" data-date="23 March 2011 - 03:15 AM"><p>
To be exact, If <br />
One LPN is having two shipment orders (SO1, SO2),<br />
two Departments.<br />
LPN should not give two rows,it should concat them with comma.<br /></p></blockquote>
<br />
Please help me , this is really urgent.
Iira
<blockquote class='ipsBlockquote' data-author="'Iira'" data-cid="74989" data-time="1300952171" data-date="24 March 2011 - 12:36 AM"><p>
Please help me , this is really urgent.<br /></p></blockquote>
Attaching report design also...
mwilliams
Sorry for the delay, I was at EclipseCon all last week. If you put your data elements in the detail row, you'll get as many repeated rows as you have concatenated values. To avoid this, you need to group by the key between the concatenated values and put your data elements in the group header of the table. Let me know if you have questions.
