Coditional Formating lines.

[rajpree]

Conditional Formatting lines.

I am using Crystal 9. I want to show line for every 4 records, which I am able to get using this formula “recordnumber mod 4 > 0” but also I want show lines based on the Sec_type too. I have order by sec_type

This is my data:
Sec_Type amount
AAB 1000
AAB 2000
AAB 3000
AAB 8000
AAB 6000
CAA 900
CAA 600
ZZZ 700

I want to show like this:

Sec_Type amount
AAB 1000
AAB 2000
AAB 3000
AAB 8000
AAB 6000
CAA 900
CAA 300
ZZZ 700

Can any one know how to conditionally show lines? in the detail section.

Thanks,
Raj.

 

[rajpree]

Sorry some reason it did not show lines in between data. I did copy and past from word.

Basically I want to get lines after AAB 8000 record and After AAB 6000 record.

Conditional Formatting lines.

I am using Crystal 9. I want to show line for every 4 records, which I am able to get using this formula “recordnumber mod 4 > 0” but also I want show lines based on the Sec_type too. I have order by sec_type

This is my data:
Sec_Type amount
AAB 1000
AAB 2000
AAB 3000
AAB 8000
AAB 6000
CAA 900
CAA 600
ZZZ 700

I want to show like this:

Sec_Type amount
AAB 1000
AAB 2000
AAB 3000
AAB 8000
AAB 6000
CAA 900
CAA 300
ZZZ 700

Can any one know how to conditionally show lines? in the detail section.

Thanks,
Raj.

 

[lbass]

It is unclear what you want to happen after the change in section type--do you want the first record after that to start the count? Or do you want a line every four records regardless of the change in section type? I would insert a group on section type, and place a line in the group footer to accomplish that part of it. If you want to reset the every-four-records line on change of section type, then create a running total that resets on change of section type and use that in your mod formula instead of recordnumber.

-LB

 

[rajpree]

LB,
Thanks a lot. it works fine with extra changes.