Creating an array in Crystal Reports XI...help

[scotton]

Hi, I am new to writing arrays in crystal reports. I need to be able to show total hours and total wages for each pay code, grouped by center. I know I can create several derived fields with an if then statement to only show the hours and earnings for each pay code BUT pay codes can be added\changed\removed and I don't want to have to hard code every single pay code as a derived field. I believe an array would accomplish the same thing.
I am green to array's and not sure how to write them. Any website tutorials, books anyone can suggest? I know just enough sql to be dangerous and that's about it.

Thank you for any help you can send my way.


Sarah

 

[briangriffin]

Based on your description, it seems like grouping would do what you want:

Group 1: Center
Group 2: Pay Code
Details: Suppressed
Group 2 Footer: Summary fields for total hours and earnings for each pay code
Group 1 Footer: Summary fields for total hours and earnings for the center

I imagine there will be at least additional group for some sort of date range (by month, quarter, etc.).

Arrays can be very useful but they are usually my last option. Include more info if I'm not understanding your goal correctly.