Passing an array of variables as a parameter to a CR XI Report

[Former Member]

Post Author: rickcf

CA Forum: General

I need to pass an 'array' of table ids to a report to use to grab the records for the report. The ids are numeric in the table and there will be no specific order or range involved, just one to many random ids. The report will consolidate and report on all ids passed (verses individually reporting on each). I have heard of passing a report an object but not sure if I have to go this far to do this. What are some design approches to accomplish this both in the report and on the call?

Thanks

[Former Member]

Post Author: rickcf

CA Forum: General

We are in the very early development of this system so exact specific minute details may be lacking u2013 thus the reason for this correspondence to to gather such information.

Yes, we have CR Developer.

We are using a Java app that also interfaces with BEA products. I am not responsible for the API server side so I am not sure about the exact specifics surrounding about this area so this is all I know. I am responsible for the crystal report and for possibly dictating to the API people what they may need to get me what I need for the report. The way we are approaching it is to have the server side Java run the reports. We are using an Oracle database that contains the data.

Currently our requirements are to pass parameters from the Java app to CR in the forms of:

Normal singular parameters

Temp file processing u2013 app creates a file and CR reports from it then app drops file.

Array id processing (as described in this question)

I have created 2 simple reports. A third report will take an array as the parameter. My question deals with what is required on the API side and what is required in the crystal report to accomplish processing off an array.

We are still in the design phase so these are all the details I am aware of.

Thanks

[Former Member]

Post Author: synapsevampire

CA Forum: General

Passing them from what, and using what API, the RDC, or?

Do you have CR XI Developer?

Try fleshing out your requirements a bit more.

Here's the sample apps, it's a shame that you didn't take the time to state anything specific about your development environment:

http://support.businessobjects.com/downloads/samples.asp

-k