RowsetController.browseFieldValues() Problems

[darran6]

Hi,

BOE XI R2 and RAS SDKs.

I'm developing a batch Java bursting application which will burst new instances of various reports to various users. The configuration for "who gets what" is held on our main system DB (Ingres).

The Java app gets the parent report ID from the Ingres DB and then (for now) gets the latest instance using

IReport.getLatestInstance();

.

I then get a ReportClientDocument and RowsetController and use these to get a list of the group values:

Values groupValues = rowsetController.browseFieldValues(groupField, -1);

(where groupField is read from the Ingres DB).

As I understand, this should return a distinct set of the group values.

This works fine for reports based on a JDBC connection.

If the report is based on a JavaBean, I seem to be getting a non-unique value for each record in the report!

If the report is based on a Business View then, irrespective of the underlying data connection, I get a runtime error:

com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Failed to get data source.---- Error code:-2147482651 Error code name:failed
        at com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException(Unknown Source)
        at com.crystaldecisions.proxy.remoteagent.s.a(Unknown Source)
        at com.crystaldecisions.sdk.occa.report.application.RowsetController.a(Unknown Source)
        at com.crystaldecisions.sdk.occa.report.application.RowsetController.a(Unknown Source)
        at com.crystaldecisions.sdk.occa.report.application.RowsetController.browseFieldValues(Unknown Source)
        at com.romofabrics.burstreports.Main.burst_report(Main.java:177)
        at com.romofabrics.burstreports.Main.main(Main.java:68)

Am I doing anything wrong, or is this a problem with the SDK?

Please help.

Cheers,
Darran