Link to home
Start Free TrialLog in
Avatar of Tina K
Tina KFlag for United States of America

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 -
User generated image
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 -
User generated image
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 

Open in new window


Thanks for your help!
Avatar of Mike McCracken
Mike McCracken

Unfortunately that is the way the export routines work.  They don't look at the suppression filters

You need to find a way to have the data filtered out in the query.
How are you filtering the report?

mlmcc
Avatar of Tina K

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.
Avatar of Tina K

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
Avatar of Tina K

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!
If you turn off the suppression of empty rows in the cross tab do you see the extra rows?

mlmcc
Avatar of Tina K

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
Avatar of Tina K

ASKER

Yes, I do - just the extra descriptions - no extra part numbers
Avatar of Tina K

ASKER

I think it might be worth noting that this report worked great for exporting until I recently added the description field.  Here's the report structure, with "Row #2 Name" being the description:

User generated image
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Tina K

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