Continuing to work on the Reports, ran into another issue not usre if it is a coding problem or data exception. I am using four SAP tables in this CR; ODLN is the main table used and joins OCRD, DLN1, and OSHP. I oiginally had code all to use left outer joins, enforced outer join, =.
The changed to Inner joins as shown in the file below (see Crystal Report joins file)
In testing, I ran a query in SAP to select records from the tables so I could compare the output. SAP created the following join statements in the query it created.
From ODLN T0
Inner Join OCRD T1 on T0.cardcode = T1.cardcode
Inner Join OSHP T2 on T0.Trnspcode = T2.trnscode
inner Join DLN1 T3 on T0.Docenry = T3.Docentry
From the test, the Crystal report produced correct reports until dates 10/01/08 encountered (This is probably going to confuse the issue but the information on the query appeared to be correct regardless of the date) No matter how I had the joins coded any report containing a shipment number prior to 10/01 appeared to be correct however any shipment number after 10/01 did not show any data on the report. It appeared that there was no data in the DLN1, OSHP or OCRD. No detail lines appeared, no address lines appeared, only static data on the report, but on the query I could see the information.
My question is simply there were 4500 lines on the query that I could verify the same data on the crystal report so I know the logic worked in the CR. By that I mean the detail lines were appearing fine, the addresses formated properly, the totals were correct, etc. Is there a debug or some other tool I can turn on in CR to see why the report stopped working after 10/01?