How to Display?

[brittoalexis]

Hi,

I had a problem.

In detail part i will display the following records like

Balance
Opening Balance 0

10(Credit) 10
10(Credit) 20 *

In Group Footer Part
Closing Balance ?


I just want to display in the group footer part what ever the value in the * position in the closing balance ? position. How can i do this?

Thanks

 

[chelseatech]

Use a running total field. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[synapsevampire]

If the details already include a value as the closinbg balance, and it's the last record for that group, place the field in the group footer.

If you need to omit it from the details as well, use a suppression with something like:

instr({table.stringvalue},"*&quot > 0

This assumes that you have a string because you have an asterisk, if not, you can use a next() function on the group field to determine when to suppress.

-k