Publishing a Crystal XI Rpt which draws data form AS/400

building reports crystal reports
1

Has anyone ran in to this? :hb: :hb: :hb: :hb: :hb:

I have a CRXI Rpt that draws data form 2 DB2 AS/400 tables. In running the report in the CRXI development tool it works find. When publishing it to BO it only shows the data form the first table. The value in the joined table dose not show at all. I can not tell if it is not displaying or simply not joining the 2nd table.

The report is attached. Any help would be appriciated.

sarnone (BOB member since 2009-06-23)

2

The only thing I can think of; is to make sure that the ODBC is identical on your dev machine and on your server. Going off memory there is a convertion tick box on the odbc settings make sure that is ticked on both.

Paul

vagasv1 (BOB member since 2007-10-10)

3

Thanks Paul.

I have already done this. Both are the same. When I was first setting the report up in BO it was not working. The report would not return any data. When I realized that the ODBC connections needed to be the same the report started returning the correct data from the first table but nothing form the second. This is the frustrating part.

Thanks again.

sarnone (BOB member since 2009-06-23)

4

are you signing onto the as400 with the same user?

vagasv1 (BOB member since 2007-10-10)

5

Yes

sarnone (BOB member since 2009-06-23)