el6uap0

I also have a need for the same thing. I need to create two temporary tables, then execute one final query from the temporary tables to populate my report. At the end of the report execution I drop the temp tables. Through the use of the temp tables my query execution time goes from over three minutes to under one second. It is largely because the datasets that I am using and joining against have over a million records. Tables are indexed and fairly light, however, when writing the queries with subqueries and JOINs it is simply way too slow. The query writing really is not the issue here. It is the fact that I cannot create and populate temp tables within my iReport query. PLEASE, someone, tell me that this can be done. Basically I need to execute five queries: Code:CREATE TEMP TABLE temp1 (LIKE big_huge_table1) ON COMMIT DROP;INSERT INTO temp1 SELECT * FROM big_huge_table1 WHERE **conditions from input controls**;CREATE TEMP TABLE temp2 (LIKE big_huge_table2) ON COMMIT DROP;INSERT INTO temp2 SELECT * FROM big_huge_table2 WHERE **conditions from input controls**;SELECT round(SELECT calculation FROM temp1 JOIN temp2) AS values, tons_of_data FROM other_tablesJOIN more_other_tablesJOIN temp1JOIN temp2;

So far nothing ... We did move the jrxml to a public directory so at least the report jrxml is being referenced. This helps so that we do not actually have multiple versions of the same report out there. We do, however, still have to deploy the report units for each one of our organizations. It's quite a pain. Mark

A little more research has led me to look into custom data sources. If anyone can give a bit more information on custom data sources here it would be really helpful. I am deploying my reports via iReport and publishing up to JasperServer. - My datasources are defined in JasperServer: organization1/datasources/db1, organization2/datasources/db2 - I can introduce a parameter in my iReport: $P{datasource} - I can create the input control in JasperServer - I can also pass the value of the datasource to the parameter via the webservice once the report is run So I guess my question is how do I get the datasource to "register" via the parameter? I think I understand the pieces, but I don't fully grasp the integration or implementation. Any thoughts? Mark

Good morning, We have an installation of JasperServer where we deploy the same exact reports across multiple organizations. All of the reports are identical - jrxml, parameters, input controls (query based), etc. The only thing that is different from one organization to another is the data source. We have placed the jrxml in a public directory and all of the organization report units reference it. How do I deploy my input controls in a public fashion as well? The problem that I am facing is that the input controls, when defined as single select queries, require a data source. But since my data source varies from organization to organization I cannot define the data source at the input control. I thought to reference a query resource, but the queries when created, also require a data source. Any ideas? Help would be greatly appreciated. Right now we are redeploying and editing input controls in far too many places and it is a management nightmare. Mark

Hi Petr, I am not, by any means an expert. And I may be missing the question. But reports that I develop in iReport are uploaded directly into JaperServer using the built in publish function. You should be able to add your JasperServer Repository to iReport (Window > JasperServer Repository). That will give you the ability to browse your JasperServer Repository and then publish the report units. That is how I am moving my reports from iReport up to the server. Mark