Monday, March 19, 2012

Crystal Report10 duplicate row

hi,
attachment contains the problem i am getting while suppressing. Although i have checked the property "Suppress if duplicated" in FormatText=>"Common Tab". found duplicate rows for label "9999 Unknown". Please help me in solving these. example is shown in attachment
i have report format as belowCould just be Crystal exporting or MS Word weirdness, but I noticed the fields didn't line up under FIL and MAINT.

Is the "UNK" entered by users manually? If so, there might be some spaces as well as "UNK" in those fields. You might try using the Trim function to turn " UNK" and "UNK " into "UNK", then see if they get suppressed in the report.|||no i am not exporting report. I just have copy paste the rows which i have to suppress

No comments:

Post a Comment