How to Suppress (or show empty ) the first record in details section? 2

[cuneyt]

I have a group called Company and have duration field in details, using the (Previous) formula, i'm taking percentage of record in detail section, but when it switches to other Group, it takes to percantage of previous one... I just dont want to show that first percentage field on each group...

Example : A company ----->Group
detail ----> 10 min.
15 min. 50%
30 min. 100%

B company
detail ----> 45 min. 50%
45 min. 0%
180 min. 300%

 

[kenhamady]

Suppress that field with the following formula:

OnfirstRecord or
{Groupfield} <> Previous ({Groupfield})

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[mbarron]

Use the following to conditionally suppress the field so it won't show as zero: (right click on the field, choose format, and then click the (x-2) button across from Suppress)

OnFirstRecord or {field.you.are.groupinging.on} <> previous({field.you.are.groupinging.on})







Mike

 

[cuneyt]

Thank you both, that's exactly what I was looking for...

p.s. Do you guys know any website that explains the meaning of each Function in CR8.5, as OnFirstRecord... and also can you recommend me a very detailed CR8.5 book with examples?

 

[mbarron]

Search for this file on th CD website. It is a help file for most, if not all of the functions available in version 8.

cr8_formularef_english.chm

If I can find the link I'll pot it.


As far as books, George Peck's The Complete Reference seems to be the benchmark. His book for CR7 came with a CD with VB codem utilities, and sample Web site (as well as &quot;standard&quot; report examples)


Mike

 

[mbarron]

You would have been searching for a while. I posted the file within the zip file, not the zip file -- anyway here's the link:

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr8_formularef.zip.asp

Mike

 

[kenhamady]

Crystal's help file explains all of the functions and gives an example of each. Not always the best explanations, but the most complete list.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[cuneyt]

Ok, thanx...