Jump to content

Jaspersoft Report using Crosstab


Recommended Posts

I have a crosstab query that returns an item, day, quantity. Example output

    -- Item -- | -- Day -- | Quantity    Item 1          15         0    Item 1 *        16         5    Item 1          17         0    Item 2          15         0    Item 2 *        16         3    Item 2          17         0[/code]

I would like the crosstab to display

    Item Description | 15 | 16 | 17 | Total    Item 1                                0    Item 1 *                 5            5    Item 2                                0    Item 2 *                 3            3[/code]

But what it actually returns looks like the below

 

                    | 15 | 16 | 17 | Total    Item 1                                0    Item 1 *                 5            5    Item 1                                0    Item 2                                0    Item 2 *                 3            3    Item 2                                0[/code]

 The crosstab is creating a row for each day instead of grouping the 15th and 17th into one row. Because the column is a day, it has to be in sequential order. (15, 16, 17, etc). 

Does anyone have a suggestion on how I can tell Jasper to group the rows together so that it shows two rows instead of three?

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

  • 4 weeks later...

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...