Skip to Content

Crystal Report - mark same values

Hello,

I am trying to find some method how to mark / highlight same values form one column/field.

For example on row 1 and 6 I have same value. Is somehow possible to manipulate witch such same values which are on different rows?

I tried in formula something with the function next, previous, but seems it is not what could help me.

Thank You for any hint

Regards Zdenek

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 30, 2017 at 07:14 AM

    Hi Zdenek,

    Hint: Did you tried using sub report(this will hit performance though), pass the row value to subreport and verify the count for that particular value in subreport and share that count to main report using shared variable then In main report you can highlight color saying "if count>2 apply color"

    Please let me know if you require any further info :)

    Thanks,

    Gulam Mustafa

    Add comment
    10|10000 characters needed characters exceeded

  • May 30, 2017 at 03:20 PM

    Hi...

    actually I have it in sub report. OK.....now I have created the shared variable in formula

    Shared NumberVar countParameter;
    countParameter := count({Command.Parameter});
    

    but how to use the highlighting in main report I am not sure

    Add comment
    10|10000 characters needed characters exceeded