Eclipse Community Forums: BIRT » Table grouping help

Home » Archived » BIRT » Table grouping help

Mon, 12 December 2011 20:55

Eclipse User

I'm somewhat confused with groupings/suppress duplicates/etc.

Here is an example of a table and what a run would look like..as far as groupings and where I don't want duplicates. I'm hoping by seeing something like this I can see how I can make any type of different layout.

I've attached an .xls of what I hope to duplicate. Basically if I had a table with these columns, how could I set the groupings/suppress duplicates to do this? And what would the actual table look like in the GUI?

Here is a screenshot of the .xls if you don't have Excel.
http://i274.photobucket.com/albums/jj265/Erebel55/tablexample-1.png

I appreciate any help. Thanks so much.

Attachment: tablexample.xlsx
(Size: 9.00KB, Downloaded 174 times)

[Updated on: Mon, 12 December 2011 21:02] by Moderator

Re: Table grouping help [message #764912 is a reply to message #764871]

Mon, 12 December 2011 23:45

Eclipse User

Here is my attempt at it (not using a sample database, I apologize) but you can get the gist of what my table looks like and it isn't working 100% because it doesn't show the phase per SPV (Underlying technology) but instead shows it per Application. Also if I removed the footer row it shows duplicates in my first column :S

Please help.

Attachment: groupingproblem.rptdesign
(Size: 44.06KB, Downloaded 203 times)

Re: Table grouping help [message #765235 is a reply to message #764912]

Tue, 13 December 2011 12:14

Eclipse User

I saved the xls data as csv and created a report against it and used two
groups. Can you have a look at the attached report design and the csv
file I used for data and explain what you need from it?

Jason

On 12/12/2011 11:45 PM, redviper8 wrote:
> Here is my attempt at it (not using a sample database, I apologize) but you can get the gist of what my table looks like and it isn't working 100% because it doesn't show the phase per SPV (Underlying technology) but instead shows it per Application. Also if I removed the footer row it shows duplicates in my first column :S
>
> Please help.

Attachment: tableexample.zip
(Size: 2.48KB, Downloaded 197 times)

Re: Table grouping help [message #765417 is a reply to message #765235]

Tue, 13 December 2011 21:17

Eclipse User

Thank you for showing me how to do this! I've never used .csv before.

I've attached an updating .zip with an updated .csv that will show the problems I have with this report when ran.

Also, here is a screenshot with the problem areas outlined.
http://i274.photobucket.com/albums/jj265/Erebel55/screenshot-6.png

So basically I want the phase to show up per spv. I want the BF to show up per SPV. And I want the CAP to show up per BF.

Sorry for the rushed image. I hope you get what I'm saying.

Thanks so much for your help.

Attachment: tableexample_2.zip
(Size: 2.63KB, Downloaded 150 times)

Re: Table grouping help [message #765777 is a reply to message #765417]

Wed, 14 December 2011 11:56

Eclipse User

I can not get this output with grouping. It can probably be done with
scripting if you know what the logic is for a specific column. For
example only display it if is different than the previous value and the
column before it has not changed?

Jason

On 12/13/2011 9:17 PM, redviper8 wrote:
> Thank you for showing me how to do this! I've never used .csv before.
>
> I've attached an updating .zip with an updated .csv that will show the problems I have with this report when ran.
>
> Also, here is a screenshot with the problem areas outlined.
> http://i274.photobucket.com/albums/jj265/Erebel55/screenshot-6.png
>
> So basically I want the phase to show up per spv. I want the BF to show up per SPV. And I want the CAP to show up per BF.
>
> Sorry for the rushed image. I hope you get what I'm saying.
>
> Thanks so much for your help.

Previous Topic:	Dynamic Report; No Values Appear
Next Topic:	Creating html5 report rendering extension

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 12:54:32 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter