Skip to Content
0

Crystal Report - mark same values

May 19, 2017 at 08:16 AM

77

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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

Share
10 |10000 characters needed characters left characters exceeded
Zdenek Chladek May 30, 2017 at 03:20 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded