Irfan's World

July 13, 2011

How to display more than 1000 values in a LOV created in Crystal report or Business View Manager ?

The following resolution involves editing the registry. To increase the maximum number of values available in a dynamic parameter list, you will add a registry key. Contact your Network Services to make changes to the system registry. Using the Registry Editor incorrectly can cause serious problems that may require you to reinstall the Microsoft Windows operating system and whole lot of other required stuff. Use the Registry Editor at your own risk.

It is strongly recommended that you make a backup copy of the registry files (System.dat and User.dat on Win9x/WinXP/2003/2003/Vista/Win 7 computers) before you edit the registry.

   Step 1. Create a registry key LOV under DatabaseOptions in the following path HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal  
       Reports\DatabaseOptions\LOV
.  See the screenshot below:

image

 

   Step 2. Add a string value "MaxRowsetRecords" and set the value to the maximum number of values that you desire for your report. For example, a value of 3000 will return up to 
      3000 values in the lowest level of a cascading LOV parameter. In the above screen a value of 60000 is set as it was required in the environment and it works perfectly fine.

The value 0 (Unlimited) will not work with BusinessObjects Enterprise XI or Crystal Reports Server XI, you must specify another value.

NOTE: After making changes to the registry, restart the affected service or application as required.  

April 23, 2011

Crystal Reports 2008: Failed to open the connection. test_oracle Details: [Database Vendor Code: 12154 ] – Resolved

Filed under: SAP Crystal Reports — Irfan @ 12:13 am

After spending lot of time on Google to fix the connectivity issue on Windows 7 64bit between Oracle 10g and Crystal Reports 2008 SP3, I thought I should write this post that may assist some of my readers including me for future reference down the road.  There is not much information available on the web and not any documentation about this issue.  The above error appears sometimes in Business Objects 3.1 SP3 Infoview or when you connect Crystal Reports 2008 Designer Tool to Oracle 10g database.

Remember the following steps:
a) Crystal Reports 2008 SP3 is a 32 bit application.
b) Business Objects 3.1 SP3 is a 32 bit application.
c) So, install  Oracle 10g 32 bit or 64 bit, But install Oracle 10g client connectivity software of 32 bit only to interact with Crystal Reports 2008.
d) If you want to use ODBC, you can connect using Microsoft ODBC drivers that are installed by default or you can also download Data Direct 5.3 drivers. or try this link https://websmp230.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/bobj_download/main.htm

Following is my environment on which connection is successful:
Operating System:   Windows 7 Ultimate (64 bit)
Database:                Oracle 10g 10.2.0.3 (32 bit)
Reporting Tool:       Crystal Reports 2008 SP3 (32 bit)
Enterprise:               Business Objects 3.1 SP3 (32 bit)

Using ODBC
1) create a 32 bit system DSN on the client machine (or the server).
    On a 64bit operating system, you will find 32 bit ODBC setup file in the following path [drive:/]Windows/sysWOW64/odbcad32.exe

2) Open Crystal reports designer tool, and try connecting to the System DSN created in step 1.  Check the following screenshot, Crystal Reports 2008 SP3, Connection tested with ODBC and it is successful on my machine.  Oh what a relief !!

SNAGHTML7fcf80

Using TNSNAMES.ORA
2) Check the following screenshot, Crystal Reports 2008 SP3, Connection tested with TNSNAMES.ORA (i.e. Oracle Server)
 

SNAGHTML772f8a

Make sure that you install all the correct 32 bit versions of Crystal Reports 2008, Business Objects 3.1 and Oracle 10g to be compatible with each other. The report should work fine in Infoview and local PC.

Share your thoughts or any alternative solutions to resolve this error. Have a Good day.!!  Smile

Create a free website or blog at WordPress.com.