One field, multiple records, displayed horizontally. How???

[RedHeadedStepITChild]

I have searched this site, and have found a couple of threads of the same issue, however, I was not able to get the answers posted there to work. I am intermediate user of Crystal, and a beginner programmer (VB). I do understand logic pretty well, so I hope I'm not 100% worthless

So...Here goes.

I am using Crystal XI SP2

Creating a report to show deduction type and amount for employees.

Using two tables. Table 1 is "Employee Master" and Table 2 is "Deduction History" They are linked by employeeNum and compNum. (We have 3 companies)

Grouping is:
Company
Employee
Deductions are at the detail level

Currently the report displays as follows:

Company 1
Employee #1
B005 .50
E003 1.25
GF SUM

A quick side note: I don't know if it matters, but the deduction type is a concatenation of two fields deductionType and deductionCode, created in formula called "deduction"

This displays the correct information. However, it does not display it in a format that is useable to my HR department. If I just change the grouping order, it still won't work because:

They need to see it in this format:

Company 1
Deduction Type B005 E003 V012 ect; ect;
Employee 1 .50 1.25 12.22 curr curr
Employee 2 .45 1.25 12.22 curr curr
GF SUM SUM SUM SUM SUM

Second side note: showing the report in this format will decrease the length of the report exponetially! That will be much appreciated by the HR dept. when running this report monthly.

Any ideas anybody? I have read through a lot of these threads, and just seeing some of the questions and answers posed here is really opening my eyes as to what can be done with crystal.

Thanks ahead!

Jason

 

[lbass]

I think you could insert a group on company and then place a crosstab in the group header or group footer where you use deduction type as the column, employee as the row, and sum of deduction amount as the summary field.

-LB

 

[RedHeadedStepITChild]

Ahhh...trying to make something simple too complicated.

DOH!

This seems to work. Running into a problem getting everything to fit one page. I guess I'll work that out.

Thank you so much for smacking me up the back side of my head!!!!

Jason

 

[lbass]

I didn't mean for that to be a smack. If you need to narrow the crosstab, you can uncheck "show cell margins" in the customize style tab. You can also narrow cell width by grabbing the borders of the cells and dragging. If you want a column header to wrap, you must manually increase the height.

-LB