hi,
thanks for the quick reply !!
>you need to pass a multivalue into a report, so you app is doing the join and passing it to the report?
the app (which i have not written) passes a multi value into the report.
just checked it by changing the param to non multi value and the report comes back with an error about it not allowing multi values.
the join is done in the main report and then used in the subreport link.
>If the report is selecting data and then you use the join .....
i found something in the docu, that if a formula does not use database entries, then the formula can be used prior to reading data. see last post.
>If you display the formula, but don't call the subreport, everything works?
in the CR dev env it works just fine. only once using the java CR engine, it does not seem to work any more.
if i display the formula in the subreport, then that gets shown properly, even using the java engine.
>...same database and connections are being used ...
the same database, but not connection.
i use a jdbc connection to create the report and app replaces the connection with the one used by the app, which is also jdbc.
>...write a quick report that runs the subreport ...
will give that a go.
thanks
Martin
IP Logged
