CrystalReports RAS SDK in Java: Question regarding ResultFields.

[Former Member]

Hello,

I'm working with the RAS and open a Crystal Report. I have a question regading the DataDefControler in the ReportClientDocument.

What is the exact semantics for the ResultFields?

My assumption was that the ResultFields container shows all fields that are used in the Crystal Reports report definition.

When I look through the Crystal Report documents I often find reports where no DatabaseField is shown in the ResultFields list.

In other Crystal Report documents I find DatabaseFields in ResultFields.

At the moment I do not understand the systematics.

When I look in the Field Explorer in Crystal Reports 2008 I see the list of Database Fields and

I find a check mark at some of the fields.

I think those fields are flagged that are used in the Report definition. Is this true?

Here an example:

The sample report Comparative Income Statement in folder Demonstration

shows 7 of the 9 DB fields flagged in Field Explorer.

 flagged: variance_xtab.Account_Type 
 flagged: variance_xtab.Account_Heading_Name 
 flagged: variance_xtab.Account_Name 
!flagged: variance_xtab.Account_Number 
 flagged: variance_xtab.Type 
 flagged: variance_xtab.Month 
 flagged: variance_xtab.Year 
 flagged: variance_xtab.Amount 
!flagged: variance_xtab.Internal_ID 

When read the Crystal Report document with the RAS SDK I do not see any of the DB fields in the ResultFields (see listing below).

This is what I do not understand.

Hope my question makes sense and you can help me.

Thanks,

Bernd

Here the sample for CR Report Samples/Demonstration/Comarative Income Statement:

# 15:09:03 Construct Crystal Report: Comparative Income Statement
=Report Display Name : Comparative Income Statement
  ReportVersion:  12 . 0
  Author: 
  Comments: 
  saveWithPrev: true
  Keywords: 
  Subject: 
  Title: 
  max number of records: 20000
  refresh option       : 1
  rowset batch size    : 100
  #... Reading DataDefinition for : Comparative Income Statement
##FIELDS## [Formula Fields]
  : Formula Fields : 
  name: date || longName: @date kind::## FormulaField ## 
    Formula## ... ##
    FormulaSyntax : Crystal
##FIELDS## [Formula Fields]
##FIELDS## [Result Fields]
  : Result Fields : 
  name: Column1 - mm/yyyy || longName: ?Column1 - mm/yyyy kind::## ParameterField ## 
  name: Column2 - mm/yyyy || longName: ?Column2 - mm/yyyy kind::## ParameterField ## 
  name: Column1 - type || longName: ?Column1 - type kind::## ParameterField ## 
  name: Column2 - type || longName: ?Column2 - type kind::## ParameterField ## 
##FIELDS## [Result Fields]
##FIELDS## [Summary Fields]
  : Summary Fields : 
##FIELDS## [Summary Fields]
##FIELDS## [Parameter Fields]
  : Parameter Fields : 
  name: Column1 - type || longName: ?Column1 - type kind::## ParameterField ## f
  name: Column1 - mm/yyyy || longName: ?Column1 - mm/yyyy kind::## ParameterField ## 
  name: Column2 - type || longName: ?Column2 - type kind::## ParameterField ## 
  name: Column2 - mm/yyyy || longName: ?Column2 - mm/yyyy kind::## ParameterField ## 
##FIELDS## [Parameter Fields]
##FILTER## [Group Filter ]
   : Group Filter  :
##FILTER## [Group Filter ]
##FILTER## [Record Filter ]
   : Record Filter  :
##FILTER## [Record Filter ]
#### [Sorts]
#### [Sorts]
#### [Groups]  
#### [Groups] 
  ... Reading Custom Functions for Crystal Report: Comparative Income Statement
  #... Reading Database information for : Comparative Income Statement
  Table : dataroot/variance_xtab
  Table Connection Information : 
  ConnectionInfo Properties 
    User Name  Kind CRQE
       QE_ServerDescription = D:\BOXI31\BusinessObjects Enterprise  ...
       QE_SQLDB = false (java.lang.Boolean)
       QE_DatabaseType = XML and Web Services (java.lang.String)
       QE_DatabaseName =  (java.lang.String)
       QE_LogonProperties = {Local XML File=D:\BOXI31\BusinessObjects Enterprise ...
       SSO Enabled = false (java.lang.Boolean)
       Database DLL = crdb_xml.dll (java.lang.String)
  Table Properties : 
  Table Name :dataroot/variance_xtab  alias name: variance_xtab descr: 
  Table-Type com.crystaldecisions.sdk.occa.report.data.Procedure
  : proc parameters : 
  Table Fields : 
    : DB Fields : 
    name: variance_xtab.Account_Type || longName: variance_xtab.Account_Type  
    name: variance_xtab.Account_Heading_Name || longName: ...  
    name: variance_xtab.Account_Name || longName: variance_xtab.Account_Name  
    name: variance_xtab.Account_Number || longName: variance_xtab.Account_Number  
    name: variance_xtab.Type || longName: variance_xtab.Type kind::## DatabaseField ## 
    name: variance_xtab.Month || longName: variance_xtab.Month kind::## DatabaseField ## 
    name: variance_xtab.Year || longName: variance_xtab.Year kind::## DatabaseField ## 
    name: variance_xtab.Amount || longName: variance_xtab.Amount  
    name: variance_xtab.Internal_ID || longName: variance_xtab.Internal_ID  
  
No SubReports found.

Edited by: BerndB on Feb 10, 2009 1:33 PM

Edited by: BerndB on Feb 10, 2009 1:38 PM

[ted_ueda · Accepted solution]

Hello Bernd,

I think the issue with RAS ResultFields not reflecting fields used in the report is a specific limitation with Cross-Tab reports.

Would this reflect your observation?

Sincerely,

Ted Ueda

[Former Member · Accepted solution]

The same problem seems to exist for crystal reports that use the Chart component.

bernd

Edited by: BerndB on Mar 12, 2009 9:51 AM