I have a question regarding formatting part of a report with multiple columns. I am using Crystal 9 with an Access database.
My report is connecting to a database table called "CONTACTS". In this table i have fields for {patient_no}, {date_of_visit}, {staff_no}, {KW_number}.
I have set up the report to list count the contacts made to a particular {KW_number} and what {staff_no} made the contacts. The report is grouped on {staff_no}.
The Group header contains the {staff_no} and a summary of how many contacts have been made by that staff member.
The details section is suppressed as is the group footer.
At present the output of the report looks like this:
Staff_No Count of Contacts
10000 123
10001 56
10002 156
10003 100
What i'd like to do is have the report display these details in two columns but i cannot seem to get this part working: Ideal output looks like this:
10000 123 10002 156
10001 56 10003 100
Could somebody please let me know how to go about setting up multiple columns for the group header or point me to a post which sheds some light on this subject.
Thanks in advance
My report is connecting to a database table called "CONTACTS". In this table i have fields for {patient_no}, {date_of_visit}, {staff_no}, {KW_number}.
I have set up the report to list count the contacts made to a particular {KW_number} and what {staff_no} made the contacts. The report is grouped on {staff_no}.
The Group header contains the {staff_no} and a summary of how many contacts have been made by that staff member.
The details section is suppressed as is the group footer.
At present the output of the report looks like this:
Staff_No Count of Contacts
10000 123
10001 56
10002 156
10003 100
What i'd like to do is have the report display these details in two columns but i cannot seem to get this part working: Ideal output looks like this:
10000 123 10002 156
10001 56 10003 100
Could somebody please let me know how to go about setting up multiple columns for the group header or point me to a post which sheds some light on this subject.
Thanks in advance