[Multiple organizations, same reports/queries]

Hows this in latest versions? 

Any better solutions or still custom executers?

 

[GIS Map Integration]

Has anyone found a solution to this?

I'd need this too.. :)

[Multiple organizations, same reports/queries]

 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

 

 

[Multiple organizations, same reports/queries]

 Can you share your queryexecuter? 

Sounds like a great workaround :)

 

[Use of $X{IN, tablecol, parameter} in PL/SQL]

 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

[Multiple organizations, same reports/queries]

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

 

[Multiple organizations, same reports/queries]

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

[Multitenancy, same report, different datasource by tenantId]

 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

[is there a "Style-when-expression"?]

 

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('-') ? 

 

 

 

[Calling Store Procedure before selecting data]

 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