Multiple Rows in cell field of Crosstab Report
Posted on August 21, 2006 at 4:49am
with the name of Allah, the most beneficial, the most merciful
Asslam o Alikum,
I have a iReport 1.2.3 crosstab report, against each row and column multiple records are expected in cell field. But currently cell field only display last record from multiple records.
Any Solution of it.
Take Care
Allah Hafiz
Nasir Zeeshan.
Joined: Aug 17 2006 - 10:02pm
Last seen: 16 years 9 months ago
Posted on August 21, 2006 at 11:26am
Hi Nasir,
A cell can display values coming only from a single record.
You have to think in a different way to your crosstab.
Can you describe it?
Giulio
Joined: Jan 2 2007 - 4:15pm
Last seen: 2 weeks 4 days ago
Posted on August 23, 2006 at 5:16am
In the name of Allah, Most Gracious, Most Merciful.
Aslam o Alikum,
Dear Giulio,
How are you?
my problem is that suppose i have customers as my rows and months as my columns and in cells i want to show "order no" in the cell. againt each customer in a month. A customer can place multiple orders in a month. so againt each customer and month multiple records are expected in the cell portion.
It is working fine in Oracle 9i Reports Developer. but not in iReport 1.2.3.
Have you any solution for that. or any other approach for it.
Take Care
Allah Hafiz
Nasir Zeeshan.
Joined: Aug 17 2006 - 10:02pm
Last seen: 16 years 9 months ago
Posted on August 23, 2006 at 10:08am
ok, what you can display in a cell is one or more results of aggregations fuctions (likes sum, average, count,...), each rapresented by a measure.
In your case, the aggregation function should produce a text with all the "order no" of the that customer in that month.
You have to modify the definition of your measure and set a custom IncrementerFactory to create the otput you need in your cell.
Giulio
Joined: Jan 2 2007 - 4:15pm
Last seen: 2 weeks 4 days ago
Posted on August 24, 2006 at 4:53am
In the name of Allah, Most Gracious, Most Merciful.
Asslam o Aliku,
Dear Giulio,
Thanks for your idea, Let me try it.
Joined: Aug 17 2006 - 10:02pm
Last seen: 16 years 9 months ago
Posted on August 25, 2006 at 6:19am
In the name of Allah, Most Gracious, Most Merciful.
Aslam o Alikum,
How are you? Have any one expample of IncrementerFactory Class
Joined: Aug 17 2006 - 10:02pm
Last seen: 16 years 9 months ago
Posted on January 26, 2010 at 3:19pm
Nasir,
Did you ever find a solution to this problem? I am trying to overcome the same issue.
Karen
Joined: Mar 19 2007 - 4:15am
Last seen: 2 weeks 8 hours ago
Posted on July 22, 2011 at 5:31am
I am trying to find an answer to this as well.
I am trying to create a schedule of planned events - on the left axis is the type of event, across the top is the month in which it will occur - within the cell, I'd like to display all relevant values.
They should be limited to no more then 3-4, so I am trying to devise a workaround to have 5 fixed values - and have them pull the highest row number, second highest row number, third highest etc etc.
Does anyone else have another option for this?
Joined: Apr 8 2011 - 6:39am
Last seen: 6 years 5 days ago
Posted on July 22, 2011 at 7:12am
Hm.. Part of my plan was to identify the rank by type and month (left and top axi) and then use an evaluator expression in the crosstab itself to say,
$V{Grid ValueMeasure} AND rank = 1
$V{Grid ValueMeasure} AND rank = 2
etc.
But I'm lost on how to add in this extra measure piece in the expression - any ideas?
Joined: Apr 8 2011 - 6:39am
Last seen: 6 years 5 days ago
Posted on July 25, 2011 at 6:45am
I was finally able to make this work -
I added a rank into my query to rank each left column row arbitrarily - and then added a second "row" to the left of the crosstab, so the multiple values show up under the correct row and column.
Joined: Apr 8 2011 - 6:39am
Last seen: 6 years 5 days ago
Posted on October 12, 2011 at 11:08am
Would you be able to provide an example? Thanks in advance.
Joined: Mar 19 2007 - 4:15am
Last seen: 2 weeks 8 hours ago
Posted on October 12, 2011 at 2:07pm
ktalarico
Wrote:
| Would you be able to provide an example? Thanks in advance. |
Oops, never mind; I figured it out. Thanks for the great tip Kate!!
Joined: Mar 19 2007 - 4:15am
Last seen: 2 weeks 8 hours ago
