nasirzeeshan Posted August 21, 2006 Share Posted August 21, 2006 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 CareAllah Hafiz Nasir Zeeshan. Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted August 21, 2006 Share Posted August 21, 2006 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 Link to comment Share on other sites More sharing options...
nasirzeeshan Posted August 23, 2006 Author Share Posted August 23, 2006 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. Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted August 23, 2006 Share Posted August 23, 2006 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 Link to comment Share on other sites More sharing options...
nasirzeeshan Posted August 24, 2006 Author Share Posted August 24, 2006 In the name of Allah, Most Gracious, Most Merciful. Asslam o Aliku, Dear Giulio, Thanks for your idea, Let me try it. Link to comment Share on other sites More sharing options...
nasirzeeshan Posted August 25, 2006 Author Share Posted August 25, 2006 In the name of Allah, Most Gracious, Most Merciful. Aslam o Alikum, How are you? Have any one expample of IncrementerFactory Class Link to comment Share on other sites More sharing options...
ktalarico Posted January 26, 2010 Share Posted January 26, 2010 Nasir,Did you ever find a solution to this problem? I am trying to overcome the same issue.Karen Link to comment Share on other sites More sharing options...
katepassaro Posted July 22, 2011 Share Posted July 22, 2011 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? Link to comment Share on other sites More sharing options...
katepassaro Posted July 22, 2011 Share Posted July 22, 2011 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 = 2etc. But I'm lost on how to add in this extra measure piece in the expression - any ideas? Link to comment Share on other sites More sharing options...
katepassaro Posted July 25, 2011 Share Posted July 25, 2011 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. Link to comment Share on other sites More sharing options...
ktalarico Posted October 12, 2011 Share Posted October 12, 2011 Would you be able to provide an example? Thanks in advance. Link to comment Share on other sites More sharing options...
ktalarico Posted October 12, 2011 Share Posted October 12, 2011 ktalaricoWrote: Would you be able to provide an example? Thanks in advance. Oops, never mind; I figured it out. Thanks for the great tip Kate!! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now