1218263 - Report based on multiple Lawson OLE DB parameterized queries does not appear

SAP Knowledge Base Article - Public

1218263 - Report based on multiple Lawson OLE DB parameterized queries does not appear

Symptom

A Crystal report is created using multiple Lawson OLE DB parameterized command queries. When attempting to preview the report, you are only prompted to supply a value for one parameter. After typing the value, however, the report fails to appear.

Cause

This issue occurs because the command queries use unnamed parameters and therefore they have the same name.

 

This known issue has been assigned Track ID ADAPT00373023.

Resolution

Hot Fixes or Service Packs address this issue as indicated below.

Known limitations

For this update to resolve this issue, Lawson OLE DB database driver must be changed to generate parameter names with the command name as the prefix. Consult the Lawson web site for more information.

Unless indicated otherwise, Weekly Hot Fix updates from the FTP site have only been tested with English versions of our products.

====================

CAUTION:

Hot Fixes and Service Packs are not designed for OEM versions. Do not apply these updates if you are using an OEM version. To determine if you are using an OEM version, refer to the OEM Product Warning. ====================

BusinessObjects Enterprise XI

---------------------------------

For BusinessObjects Enterprise XI, the latest update for this issue is available on the Downloads area of our website.

This issue is addressed in the following components (and later versions):

crdb_ado.dll, version 11.0.0.773, dated 2/7/2005

  • crpe32.dll, version 11.0.0.948, dated 2/7/2005
  • crpe32_res_en.dll, version 11.0.0.948, dated 2/7/2005
  • crdb_ado_res_en.dll, version 11.0.0.773, dated 2/7/2005
  • crdb_ado.dll, version 11.0.0.773, dated 2/7/2005
  • crpe32.dll, version 11.0.0.948, dated 2/7/2005
  • crpe32_res_en.dll, version 11.0.0.948, dated 2/7/2005
  • crdb_ado_res_en.dll, version 11.0.0.773, dated 2/7/2005

Crystal Enterprise 10

------------------------

For Crystal Enterprise 10, the latest update for this issue is available on the Downloads area of our website.

This issue is addressed in the following components (and later versions):

  • crpe32.dll, version 10.0.5.936, dated 1/28/2005
  • crpe32.pdb, dated 1/28/2005
  • crpe32_res_en.dll, version 10.0.5.936, dated 1/28/2005
  • crpe32.dll, version 10.0.5.936, dated 1/28/2005
  • crpe32.pdb, dated 1/28/2005
  • crpe32_res_en.dll, version 10.0.5.936, dated 1/28/2005
  • crdb_ado.dll, version 10.0.5.659, dated 1/28/2005
  • crdb_ado_res_en.dll, version 10.0.5.659, dated 1/28/2005
  • crpe32.dll, version 9.2.3.1355, dated 1/28/2005
  • crpe32.dll, version 9.2.3.1355, dated 1/28/2005

Crystal Enterprise 9

-----------------------

For Crystal Enterprise 9, the latest updates for this issue are available on the Downloads area of our website.

This issue is addressed in the following components (and later versions):

  • Crpe32.dll, version 9.2.3.1355, dated 1/28/2005
  • Crdb_ado.dll, version 9.2.1.547, dated 1/28/2005

Crystal Reports XI

--------------------

For Crystal Reports XI, the latest update for this issue is available on the Downloads area of our website.

This issue is addressed in the following components (and later versions):

  • crdb_ado.dll, version 11.0.0.773, dated 2/7/2005
  • crpe32.dll, version 11.0.0.948, dated 2/7/2005
  • crpe32_res_en.dll, version 11.0.0.948, dated 2/7/2005
  • crdb_ado_res_en.dll, version 11.0.0.773, dated 2/7/2005
  • crdb_ado.dll, version 11.0.0.773, dated 2/7/2005
  • crpe32.dll, version 11.0.0.948, dated 2/7/2005
  • crpe32_res_en.dll, version 11.0.0.948, dated 2/7/2005
  • crdb_ado_res_en.dll, version 11.0.0.773, dated 2/7/2005
  • craxddrt.dll, version 11.0.0.948, dated 2/7/2005
  • craxdrt.dll, version 11.0.0.948, dated 2/7/2005
  • crw32.exe, version 11.0.0.948, dated 2/7/2005
  • craxdrt_res_en.dll, version 11.0.0.948, dated 2/7/2005
  • craxddrt_res_en.dll, version 11.0.0.948, dated 2/7/2005
  • crw32_res_en.dll, version 11.0.0.948, dated 2/7/2005

Crystal Reports 10

---------------------

For Crystal Reports 10, the latest update for this issue is available on the Downloads area of our website.

This issue is addressed in the following components (and later versions):

  • crpe32.dll, version 10.0.5.936, dated 1/28/2005
  • crpe32.pdb, dated 1/28/2005
  • crpe32_res_en.dll, version 10.0.5.936, dated 1/28/2005
  • crpe32.dll, version 10.0.5.936, dated 1/28/2005
  • crpe32.pdb, dated 1/28/2005
  • crpe32_res_en.dll, version 10.0.5.936, dated 1/28/2005
  • craxddrt.dll, version 10.0.5.936, dated 1/28/2005
  • craxdrt.dll, version 10.0.5.936, dated 1/28/2005
  • crw32.exe, version 10.0.5.936, dated 1/28/2005
  • craxdrt_res_en.dll, version 10.0.5.936, dated 1/28/2005
  • craxddrt_res_en.dll, version 10.0.5.936, dated 1/28/2005
  • crw32_res_en.dll, version 10.0.5.936, dated 1/28/2005
  • crdb_ado.dll, version 10.0.5.659, dated 1/28/2005
  • crdb_ado_res_en.dll, version 10.0.5.659, dated 1/28/2005

Crystal Reports 9

--------------------

For Crystal Reports 9, the latest updates for this issue are available on the Downloads area of our website.

This issue is addressed in the following components (and later versions):

  • Crdb_ado.dll, version 9.2.1.547, dated 1/28/2005
  • Craxdrt9.dll, version 9.2.3.1355, dated 1/28/2005
  • Craxddrt9.dll, version 9.2.3.1355, dated 1/28/2005
  • Crw32.exe, version 9.2.3.1355, dated 1/28/2005
  • Crpe32.dll, version 9.2.3.1355, dated 1/28/2005

Crystal Enterprise Report Application Server 9

-----------------------------------------------------

For Crystal Enterprise Report Application Server 9, the latest update for this issue is available on the Downloads area of our website.

This issue is addressed in the following components (and later versions):

  • Crpe32.dll, version 9.2.3.1355, dated 1/28/2005

Monthly Hot Fixes and Service Packs

------------------------------------------

To determine if this issue is also addressed in a Monthly Hot Fix or Service Pack for your Crystal product, search the readme file for the Track ID number (that is, ADAPTXXXXXXXX) in the latest Monthly Hot Fix or Service Pack.

Monthly Hot Fix and Service Pack readmes for Crystal products are found on the Downloads area of our website.

====================

NOTE:

Issues addressed on one operating system platform at the Weekly Hot Fix level may be addressed later on multiple operating system platforms (if applicable) at the Monthly Hot Fix and Service Packs level. For example, an issue only resolved on the Windows platform in a Weekly Hot Fix may be resolved later on UNIX platforms such as IBM AIX and Sun Solaris in future Monthly Hot Fixes or Service Packs for these platforms.

To determine if these issues are resolved in a Monthly Hot Fix or Service Pack on another platform, search for the Track ID number in the readme at the locations indicated above.

====================

See Also

For more information on the issues addressed in the Hot Fix or Service Pack, view the readme PDF or text file included in the ZIP or TAR file.

For more information on the different update types, refer to our Hot Fix and Service Pack FAQ.

Keywords

CR WHF 373023 DISPLAY PARAMETERS OLEDB QUERY Crystal Reports Lawson OLE DB Query Displaying Report , c2017019 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports 9.0