Fek

Hi all, I have the same problem. But this solution didnt work because all fields are not null even though on the last page no details are displayed. For testing purposes I displayed a field in the columnHeader. Result: On the last page, where no details are displayed, the field in the columnsHeader has the value from the last displayed detail on the last page. Has anyone an idea how it works correctly?

Hm, this did'nt work. I don't have the possibility to insert a order by clause to an union statement and the stateme nt without order by works fine on Oracle. :dry: Regards, Fek

Hi, I have a big problem. Let us consider I have a table "Bubu" in my DB2-Database and also teh same table with the same content for a Oracle database. Into the table there exists an column "name" with the values: "Name01", "Name02" To demonstrate the problem I create a stupid query: select name as "Name", 1 as "Fake", 0 as "Fake2" from bubu union select name as "Name", 0 as "Fake", 1 as "Fake2" from bubu On both databases teh result would be the same: Name01, 1, 0 Name02, 1, 0 Name01, 0, 1 Name02, 0, 1 Now I want to create an report which schow me only one name of the same type, so I want to se the follwing: Name01 Name02 I know i can use distinct in the query but I want to show you the problem with iReport or perhaps jasperReports ???? So, I create a new report with iReport, use the query and go to the "Report Groups"-editor. There I create a new group with the expresion "$F{Name}". In the nameGroupFooter I set the TextField with the expresion $F{Name}. What do you mean its the difference between the reports executed on a Oralce database and a DB2 database? The DB2 result: Name01 Name02 Name01 Name02 The Oracle result: Name01 Name02 Why this difference? I need the oracle result for the DB2 database, but how???? Greetings Fek

Hi, I have a big problem. Let us consider I have a table "Bubu" in my DB2-Database and also teh same table with the same content for a Oracle database. Into the table there exists an column "name" with the values: "Name01", "Name02" To demonstrate the problem I create a stupid query: select name as "Name", 1 as "Fake", 0 as "Fake2" from bubu union select name as "Name", 0 as "Fake", 1 as "Fake2" from bubu On both databases teh result would be the same: Name01, 1, 0 Name02, 1, 0 Name01, 0, 1 Name02, 0, 1 Now I want to create an report which schow me only one name of the same type, so I want to se the follwing: Name01 Name02 I know i can use distinct in the query but I want to show you the problem with iReport or perhaps jasperReports ???? So, I create a new report with iReport, use the query and go to the "Report Groups"-editor. There I create a new group with the expresion "$F{Name}". In the nameGroupFooter I set the TextField with the expresion $F{Name}. What do you mean its the difference between the reports executed on a Oralce database and a DB2 database? The DB2 result: Name01 Name02 Name01 Name02 The Oracle result: Name01 Name02 Why this difference? I need the oracle result for the DB2 database, but how???? Greetings Fek

Hi, I have a big problem. Let us consider I have a table "Bubu" in my DB2-Database and also teh same table with the same content for a Oracle database. Into the table there exists an column "name" with the values: "Name01", "Name02" To demonstrate the problem I create a stupid query: select name as "Name", 1 as "Fake", 0 as "Fake2" from bubu union select name as "Name", 0 as "Fake", 1 as "Fake2" from bubu On both databases teh result would be the same: Name01, 1, 0 Name02, 1, 0 Name01, 0, 1 Name02, 0, 1 Now I want to create an report which schow me only one name of the same type, so I want to se the follwing: Name01 Name02 I know i can use distinct in the query but I want to show you the problem with iReport or perhaps jasperReports ???? So, I create a new report with iReport, use the query and go to the "Report Groups"-editor. There I create a new group with the expresion "$F{Name}". In the nameGroupFooter I set the TextField with the expresion $F{Name}. What do you mean its the difference between the reports executed on a Oralce database and a DB2 database? The DB2 result: Name01 Name02 Name01 Name02 The Oracle result: Name01 Name02 Why this difference? I need the oracle result for the DB2 database, but how???? Greetings Fek