mikij

Hm...well, it is not so simple, because after month grouping I need to group some Orders in one month too, by the first week, the second week, and the third week for one Customer.

Yes, I did it. Thank you.

Yes, that's it. But, I just want to show for every month, every Order and summary for that month ?

I'm not sure if this is a solution to my problem. My columns are fixed and known. The report should sum values for every month between two dates I pass, it looks like this: Orders: ====================================================================== Date | Customer | product name | price | ====================================================================== 2008/10/10 | Some Cust. | PRoduct 1 | .... <- this is summary/group for whole Order (includes all its OrderElements) ----------------------------------------------------------------------------------------------------------------------- 2008/10/15 | Some Cust. | PRoduct 1 | .... ----------------------------------------------------------------------------------------------------------------------- October | Some Cust. | PRoduct 1 | .... summary ----------------------------------------------------------------------------------------------------------------------- etc. -- Thanks in advance, Miki

Hi, I need to define one group that will sum some elements in my Orders in some given period (table Order-[1]----[*]->OrderElement). I will always have 3 such orders in a month. I want to do next, when user choose dates e.g., 1.1.2008 to 1.3.2008., I want to show every Order enter in that period, but for every moth, I need to have one summary row that will sum all Order values from that month. How can I do it, any hint ? My tables: Order table (id, date, Customer, ...) OrderElement (id, price, productName, order_id,...) -- Thanks in advance, Miki

Trying to say this little bit simpler, I want to show Order value just if all Receipnt's that are connected to some Order are shown in report, if one Receipnt's is not shown, I don't want to show Order value (but the Report stay the same, just with 0 for Order value). Thanks!!

Hi, I'm not sure if subject is wright, but I will try to explain what I need to do. I have Receipt table which have cardinality 1:m to Order table, so one Receipt can have 1..* Orders or in particular multiple different Receipt's can have one the same Order (Receipt --[0..1]-----[1..*]-->Order). So, I have e.g., 3 Receipts connected to one Order. Now, I need to create a report which will take all 3 Receipts in some date period, group them from some of its fields, and I need to show Order value only when all 3 Receipt's are shown in report (report should have to show just 1st Receipt, etc. and all three grouped depending of input parameters) , for others I want to set 0 as value in that case. Does anyone have any idea or a hint how can I define such report ? -- Thx in advance, Miki

Yes, that's it! I'm using MySQL. Thanks very much. -- Regards, Miki

No one knows ?

Yes, but in my report (with char) I have selected "Connection 1" (database), and in my subdataset I want to choose another connection "Connection 2" (csv) to fill the chart, how can I do this ?

When I create Subdataset, and a chart on my main report, in Chart Properties, "Connection/Data Source Exp." I cannot choose my second connection. When I enter for "Use data source expression", "MyConnection2", I get an error: "Cannot cast from String to JRDataSource" ?

Is it possible to have two data connections in one report ? I want to show my data in report from one connect (csv) and a chart from another (database). -- Miki

O.K. Thank you. Is this class you are proposing a scriplet ?

Hi, I have a table with Date field, and I want to show this date converted, like this: for example, if day in the month is 1 to 10 then show 'I period" in report, if day in the month is 11 to 20 then show "II period". and if day in month id 21-end of the month then show 'III period'. Is this possible to do in iReport, and how ? Any hint would be very helpful. One more thing, I have multiple rows which have few dates in e.g. january, after showing them all, I want to make summary row that will say, e.g. "January', other rows. And this for every moth. Do you have any idea for this too ? -- Thank you in advance ?

O.K. When I removed header row it works now. Thanks. Anyhow, it is wierd behaviour.

I found solution for my second problem with formatting text field here: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=12882 For the first problem, I tried with both Strings too and it is the same (not working). And this is wierd because iReport retrieves two column names automatically.

No one knows ? I have another question, I want to format my static textfield in European format, like this: #.##0,000 . But I get an exception: Mailformed pattern ?

Hi, I created the most simple report using Report Wizard that uses this simple csv file: -- Value;Price 5230;1.150478668 5231;1.150478668 5232;1.150478668 5233;1.150478668 5234;1.150478668 -- I entered semicolon as a delimiter, Double for Value and BigDecimal for Price and iReport recognized two colum names and generated the report without errors. But, when I try to run the report it say: Error filling print... Unknown column name : Price net.sf.jasperreports.engine.JRException: Unknown column name : Price at net.sf.jasperreports.engine.data.JRCsvDataSource.getFieldValue(JRCsvDataSource.java:172) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:787) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:751) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1422) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:111) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:801) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:517) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:973) at java.lang.Thread.run(Unknown Source) Print was not filled. Try using an EmptyDataSource... ?

Hi, I know how to show my grouping value in a text field just one at the start of the group, I just choose this option "Print when group changes" and deselect "Print repeated values". But how can I show this value at the last row in the group (not at first)? -- Thank you, Miki.