webservice temporary table?

[topkatz]

I have a report I built that uses calculated data from my tables.  I would like to put this data in a temporary table, then have jasperserver webservice use it.  Up untill now I have not been able to get the webservice instance to see the temporay table.  Is there a way to do this via php, or must I use a static table for my results for the report?

[topkatz]

I came up with a workaround, as I figure there is no way to tell the webservice what session to use.

 

This is what I did:

 

1. In the report and subreports setup a new parameter $P!{TABLE} and use it in the SQL

2. In my PHP script I built a random string generator function

3. Create a new table and name it using the random string function

4. stick my calculated data in the table

5. call my webservice and use the new TABLE parameter with the random name.

6. Delete the table.

 

Everything is working as you would expect!