Hi,
Need:
To generate PDF reports from standalone java program using CR4E runtime engine. Reports will be designed using CR4E. The java program will use CR4E engine APIs to open the report and populate date in it from database.
Scenario:
I have created a report and mapped the report fields from SQL file (similar to using it as SQL command). I have also created 2 parameters and also included in the SQL file.
Problem:
1) These parameters don't prompt when run within CR4E designer & i see no way to set these values to work in preview mode and it appears as a blank page. Bcos of above reason, my java application when executed also gnerates blank report as the parameters are not set. How to resolve this?
2) Then i tried using record filters to map the SQL file field name to parameter name in the report. Now, when previewed the prompts for parameters appeared and the report was displayed as expected. But, when the java application gave 'FormulaException: Field name not known' error (with mention to SQL field names used in filter). I am not using any formula in my report so this error is bcos of using record filter. How to resolve this error?
Finally, i need a design & runtime solution to execute my reports with parameters.
TIA,
M.Ravi