Problems exporting from Crystal Reports 8.5
I have a client that is using Crystal Reports v8.5.
The report is not supposed to include inventory items that have < 12.
When we run the report, it displays fine and there are no items showing with < 12.
When I export:
FORMAT: text
DESTINATION: disk
Inventory that has < 12 are displayed.
When I export:
FORMAT: EXCEL 8.0
DESTINATION: disk
Inventory that has < 12 is suppressed but there is a blank line between each entry.
I am very new to Crystal Reports and Appreciate you knowing that up front and taking it into consideration when answering.
How can I export to excel without the extra spaces?
The report is not supposed to include inventory items that have < 12.
When we run the report, it displays fine and there are no items showing with < 12.
When I export:
FORMAT: text
DESTINATION: disk
Inventory that has < 12 are displayed.
When I export:
FORMAT: EXCEL 8.0
DESTINATION: disk
Inventory that has < 12 is suppressed but there is a blank line between each entry.
I am very new to Crystal Reports and Appreciate you knowing that up front and taking it into consideration when answering.
How can I export to excel without the extra spaces?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
More information:
The file is exported Format: Text, Destination: disk
we rename filename.txt >filename.csv
but there are rows that should not show up because there are 0 (zero) in stock.
Here is what is in Designer,
Right click on Group Header#1
Click on Format Section
Click on RED X-2 button next to unchecked 'suppress [no drill down]
{@AV}<12 or {@Selling price}<=1.75 or {@Manufacturer}= "CHANEL"
any ideas?
thanks in advance!
The file is exported Format: Text, Destination: disk
we rename filename.txt >filename.csv
but there are rows that should not show up because there are 0 (zero) in stock.
Here is what is in Designer,
Right click on Group Header#1
Click on Format Section
Click on RED X-2 button next to unchecked 'suppress [no drill down]
{@AV}<12 or {@Selling price}<=1.75 or {@Manufacturer}= "CHANEL"
any ideas?
thanks in advance!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is there a business reason the report is suppressing records that are being returned rather than filtering them out via record selection (so they aren't ever returned in the first place)?
ASKER
records that show less then 12 items in the inventory reports that this report draws from are suppressed because the client does not need that information.
How can I determine whether the lines are being suppressed or filtered (or even worse both??)
How can I determine whether the lines are being suppressed or filtered (or even worse both??)
What is the suppression formula?
mlmcc
mlmcc
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@james0628; thanks for your input. this sounds logical to me, so my next question being a newbie in CR8.5, is how do you see what these formulas are?
I also appreciate everyone's input and paitents.
-Rich
I also appreciate everyone's input and paitents.
-Rich
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My apologies for the delay...
In this case, it seems that we resolved the problem by changing the format from text to Excel 8.0.
It was complicated by the fact that after it formatted the fesuliting CR report, it would save as and change the .txt to a .csv extension.
We disabled those lines and tested it with the differnect formatting and it came out fine.
thanks to everyone to contributed to this conversation.
-Rich
In this case, it seems that we resolved the problem by changing the format from text to Excel 8.0.
It was complicated by the fact that after it formatted the fesuliting CR report, it would save as and change the .txt to a .csv extension.
We disabled those lines and tested it with the differnect formatting and it came out fine.
thanks to everyone to contributed to this conversation.
-Rich
ASKER
Is there any difference between the two designer?
How do I bring up 'Designer' so that I can see if what I have found is the problem (blank rows appear in Excel)?