andde

Hows this in latest versions? Any better solutions or still custom executers?

Has anyone found a solution to this? I'd need this too.. :)

It seems to be in-built even if it is not shown in ireport. It seemed to work in my tests anyway.. How about Peters examples? - Anders

Can you share your queryexecuter? Sounds like a great workaround :)

Hello, I seem to be having problems one after another. I have input control of multiselect query called MULTI. P{USE_EXTENDED} is just simple normal parameter.. I want to do following: Code: declare dummy number(12);begin // Get db-id for populated report data select sq_id.nextval into dummy from dual; //Populate data for-each value of MULTI select prepare_report_data(dummy, a.id, $P{USE_EXTENDED}) from a where $X{IN, a.id, MULTI};end;[/code] That block is not working (unable to get next...) If that is done in single SQL statement without db-id it works: Code: select prepare_report_data( a.id, $P{USE_EXTENDED}) from a where $X{IN, a.id, MULTI}[/code] So is the problem in multiple statements? Im using ora10g database. Post Edited by andde at 01/02/2012 09:40 Post Edited by andde at 01/02/2012 09:40

Just to keep to this alive, bump. Hope someone finds an answer..

Hi, I am struggling with this also. Seems like exactly same scenario. Placing jrxml on public is somewhat poor solution, because reports usually consist of 3 jrxml, 2-3 resource bundles and 2-3 input controls.. If i understood anything, you still have deploy report to organization level as a jasperreport.. so all that "bundled".. So i hope someone will come up with a solution.. :) Cheers, Anders Post Edited by andde at 12/02/2011 12:11

Hi, Being rather new into this world, i have a question :) First some basics: - Same report is served to multiple clients, they have exactly same kind of database. - Clients do not log into JS, but JS is integrated to our software. In this research phase i will be using direct URL-requests to get reports. So, how do i setup JS environment so that incoming parameter tenantId would be deciding datasource for the report.. i read about domains, but seems like they are not the trick..? I can create organizations.. that's a start i quess.. I've built desired test report already and have my proof-of-concept there, but now this issue is the only "show-stopper" left.. Hope someone gets my idea and is willing to offer some guidance :) Version 4.2.1 Post Edited by andde at 12/01/2011 14:17

I was wondering. How do i get red background to my "cell" if field value is something say 0 or '-' -character? Just put red background in and use print-when-expression in style: $F{FIELD}.equals('-') ?

I'm sorry to dig this from the grave. Still calling for a solution for this. First populate report data to temp table then read data in multiple queries (main report/subreport with table).. So only real problem is getting the data into temp table. No custom java please, report's will be asked from django-application. Oracle is our used database so that package-approach would work, but sooo many years.. I hope there is a easy way to do this. Post Edited by andde at 09/28/2011 12:44