Jump to content
Changes to the Jaspersoft community edition download ×

Grouping Question


Recommended Posts

By: Edward Dale - scompt

Grouping Question

2002-10-15 07:40

I have a report that's accessing a database, joining a couple tables and returning a recordset similar to this:

 

cheese, something, val1, virginia

cheese, something, val2, virginia

cheese, something, val3, virginia

cheese, something else, val4, new york

cheese, something else, val5, new york

milk, yet another, val6, virginia

milk, yet another, val7, virginia

milk, yet another, val8, virginia

milk, last one, val9, new york

milk, last one, val10, new york

 

my report needs to look like this:

 

cheese

something val1 virginia

val2

val3

something else val4 new york

val5

 

milk

yet another val6 virginia

val7

val8

last one val9 new york

val10

 

I have a group that correctly breaks up the first field (cheese, milk). However, my attempts with the val column have been unsuccessful. Any ideas on how I might do the grouping with this?

Thanks, Ed.

 

 

By: Teodor Danciu - teodord

RE: Grouping Question

2002-10-15 12:50

 

Hi,

 

My suggestion is to give up trying to group your

records after the val field.

You should use the isPrintRepeatedValues attribute

that will suppres the second field if its value repeats.

It will look like you have grouped your records after the "something" field, even you have not.

 

I hope this helps.

Teodor

 

 

 

By: Edward Dale - scompt

RE: Grouping Question

2002-10-15 13:00

Teodor,

That got it. With a little fooling around, I should be able to get it exactly like I want it. Thanks for the prompt response.

 

Edward

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...