1574698 - Crystal Report displays wrong data when multiple Sybase databases are used in CR2008.

• Crystal Report displays wrong data.
• Two Sybase database schemas are used from which data is fetched in a Crystal Report.

• Crystal Reports 2008 SP3
• Sybase ASE 15

Replication Steps:
On Sybase Database:

1. Connect to Sybase Server.
2. Create a new table t1 in database1 by running the below query:
   CREATE t1
   (id int not null,
   name varchar(20) null,
   primary key(id))                                                                                                                                                                                                                  INSERT INTO t1(id,name) VALUES(1,'ABC')
   INSERT INTO t1(id,name) VALUES(2,'XYZ')
3. Create two tables in database2 by running the below queries:

CREATE TABLE t2(id int not null,
cityname varchar(20),
primary key(id))

INSERT INTO t2(id,cityname) VALUES(1,'PQR')
INSERT INTO t2(id,cityname) VALUES(2,'MNO')

CREATE TABLE t3(userid int not null,
cityid int)

INSERT INTO t3(userid, cityid) VALUES(1,1)
INSERT INTO t3(userid, cityid) VALUES(1,2)

Creating Crystal Report:

1. Launch Crystal Report designer.
2. Create a New Connection > Sybase Server>Add the details for the Sybase Server, Click OK.
3. Choose the created tables > Click OK.
4. Link the tables like ‘user’ table and ‘matrix’ table with ‘user id’. Link ‘matrix’ table and ‘city’ table with ‘city id’.
5. From the Database Fields choose the fields 'name','cityname' and drag to details section and Preview the report.
6. Cityname shows irrelevant characters.
   
   

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed