Need Help Please: conditonal display of details section

[BreffniK]

Hello and thanks for taking the time to read my question.

Backround:

I am developing a multiple record report that will return many rows per every Release Number (UDF/unique identifier per every row of info returned). The values in the Release Number field will only numberic characters (1,2,3,4, etc.). All of the information in each row returned will be identical with the exception of the Release Number field.

Example:

Name Class Release Number
---- ----- --------------
JDoe 123 1
JDoe 123 2

Question:

How may I display only the row/details section with the highest value of Release Number, IE the second row in the above example.

Any help or advice would be greatly appreciated!

Thanks!

 

[rosemaryl]

Dear Breffnik:

Group on Name, then right click format section for the detail section, click the x-2 formula editor next to the suppress checkbox (do not check) and enter:

{Table.ReleaseField} <> maximum(table.releasefield)

That should do the trick. Another way to accomplish the same thing would be to Group on Name, then display the fields that you are showing in the detail section in the Group Footer. The group footer will always have the last record for a group. Suppress the Group Header and Details and only show footers.

This is all based on the assumption that your statement: All records for rows are identical except release number. I am assuming that the Name field is what you would need to group on.

regards,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[lbass]

If you want the highest release number per name, then change Rosemary's formula (I'm guessing she meant to say this) to:

{Table.ReleaseField} <> maximum({table.releasefield},{table.name})

-LB

 

[IdoMillet]

I like the 2nd solution suggested by ro, because it should run faster. However, ro assumed you are sorting the records within the group by Release Number. If you are not, be sure to do so.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com