Tina K
asked on
Extra rows appearing in exported Crystal Report
Hi Experts -
I have a Crystal Reports cross tab that brings up forecast data. The report is set up to suppress empty rows - works great. However, when the report is exported, I'm getting part descriptions that don't appear in the crystal report. I can see that the query is grabbing every part for a particular customer, and even though Crystal is suppressing the data, it appears in my Excel export.
Here's an example:
Shot of Crystal -
You can see the crosstab is showing the two part numbers on the left, description in the next row, and so on...
Here's the export -
Same part numbers, but now I have a bonus part description in column B. This was suppressed in Crystal.
How do I make the extra descriptions go away? They shouldn't even be coming into the report in the first place, since the part they go with doesn't have a forecast within the parameter date range. We didn't have this problem until I added the description. I probably have something set up wrong in the cross tab. I hate them so much, so I very rarely use them. I'm stumped.
Real simple command -
Thanks for your help!
I have a Crystal Reports cross tab that brings up forecast data. The report is set up to suppress empty rows - works great. However, when the report is exported, I'm getting part descriptions that don't appear in the crystal report. I can see that the query is grabbing every part for a particular customer, and even though Crystal is suppressing the data, it appears in my Excel export.
Here's an example:
Shot of Crystal -
You can see the crosstab is showing the two part numbers on the left, description in the next row, and so on...
Here's the export -
Same part numbers, but now I have a bonus part description in column B. This was suppressed in Crystal.
How do I make the extra descriptions go away? They shouldn't even be coming into the report in the first place, since the part they go with doesn't have a forecast within the parameter date range. We didn't have this problem until I added the description. I probably have something set up wrong in the cross tab. I hate them so much, so I very rarely use them. I'm stumped.
Real simple command -
SELECT DISTINCT
PART.ID, PART.USER_10, PART.DESCRIPTION, PART.QTY_IN_DEMAND, PART.QTY_ON_HAND, PART.QTY_ON_ORDER, CUSTOMER_ORDER.CUSTOMER_ID,
CUST_ORDER_LINE.CUST_ORDER_ID, CUST_ORDER_LINE.ORDER_QTY, CUST_ORDER_LINE.DESIRED_SHIP_DATE,
CUST_ORDER_LINE.UNIT_PRICE
FROM PART INNER JOIN
CUST_ORDER_LINE ON PART.ID = CUST_ORDER_LINE.PART_ID INNER JOIN
CUSTOMER_ORDER ON CUST_ORDER_LINE.CUST_ORDER_ID = CUSTOMER_ORDER.ID
Thanks for your help!
ASKER
The report is only filtered by customer and date range. The customer filter takes place in the Command (I didn't show it in the code section for privacy reasons). The date range is set by two Crystal parameters.
ASKER
Actually - why am I getting the part description but not the part number? The date parameter is working for that, it doesn't bring in the records for parts that don't have forecast in the date range. It makes no sense that it is grabbing the descriptions for parts that are not on the report.
I don't know where you have the cross tab but try dropping the fields into the detail section and see if you are getting the records you don't want.
mlmcc
mlmcc
ASKER
I put the part id and description in the details and it appears that the orphaned descriptions are gone. How do I get this logic into the cross tab?
Thanks!
Thanks!
If you turn off the suppression of empty rows in the cross tab do you see the extra rows?
mlmcc
mlmcc
ASKER
Turned off the suppression, and I do not see the extra rows.
If you export with the suppression turned off do you get the extra rows?
mlmcc
mlmcc
ASKER
Yes, I do - just the extra descriptions - no extra part numbers
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good grief - that was it!! I turned off the subtotals for the description field and that did the trick. Thank you so much for your help mlmcc!!
Thanks for posting a better view of the design.
mlmcc
mlmcc
You need to find a way to have the data filtered out in the query.
How are you filtering the report?
mlmcc