Skip to Content
0
Former Member
Feb 20, 2009 at 10:24 AM

setTableLocation does not work with CommandTable object

23 Views

Admins, I accidently posted the same question in Others section, so I kindly aks, if it could be deleted.

I want to display complex CR reports in my JSP app, buth so far with very little luck. I managet to display CR report on my web page, buth when I want to enable some user to limit the records, that he wants to see, I am out of luck.

I want to limit records with use of plain SQL (no CR params) and I tried few things:

1. At first I wanted to pass custom sql to report with multiple tables. I belive that that is not possible i this version of JRC.

2. Then I re-designed the reports (CR XI designer and also CR 2008 designer), so that they used CommandObject. Firstly I tried to pass Java resultset to report, buth I got "Unexpected connection error".

Then I tried to create new commandTable and just switch the location of original table and this new table with setTableLocation, buth all I got, was very long loading time of report, and empty report on web page.

When I saved this changed report from my code, I noticed, that resulting table in not CommandObject Any more, buth it become Tables Object.

Only succesful scenario was, when I used One table report + java resultset. I belive that if I I replaced table with view, buth this is very un-elegant soluton for me.

Is it possible to achive what I want, with either:

-sql + multiple tables (best for me)

resultset + commandObject

some third option

Thanks in advance.