I have a subreport which has a COMMAND rather than a table on it.

I want to be able to embed a parameter into the command and have the value of this parameter automatically set by the value of a field on the main report.

I've added the parameter to the SQL command.
In the main report, I've added the subreport link to the parameter.

What properties should I give the parameter on the "Edit parameter dialog box"?

I ask because I'm getting an error when executing via our Java service...
[com.businessobjects.reports.sdk.JRCCommunicationAdapter] JRCAgent34 detected an exception: JDBC Error: ORA-01722: invalid number

It previews fine via Crystal.

DC


Edited by AntDC - 25 Mar 2009 at 6:34am