Duplicate Records

[Randygk]

I am running Crystal 8.5 linked to a SQL Database. I tried to supress by a UID but the rest of the items in that line double print even without a UID thus screwing up my totals. I need to suppress the rest of the detail line if a UID is not present.
Thanks
Randy

 

[synapsevampire]

Try:

Right click the section that this line is in, select format section->X 2 next to suppress and enter something like:

isnull({table.UID}) or {table.UID} = ""

This assumes that {table.UID} is a string, if it is a numeric, use:

isnull({table.UID}) or {table.UID} = 0

For the best results, try posting table layout(s), example data and expected output.

-k

 

[dgillz]

Suppressing, or conditional suppressing, will not help you. The records are still a part of the report and will still evaluate in any totalling or subtotalling you have.

Rather than suppressing records, use a record selection formula to exclude the records from the report entirely.

If this does not work, please post some specifics of what you are trying to do versus your current results.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[synapsevampire]

Good point dgillz, I missed that it was screwing up totals.

Database->Select Distinct Records (though I suspect the entire rows aren't unique)

or

Report->Edit Selection Formula->Record and enter the criteria that would make them unique (as dgillz mentioned)

or

Use Running totals with Evaluate->Use a formula to only count each once.

-k