Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crosstab labelling query

Status
Not open for further replies.

Secretgeek

Technical User
Jan 3, 2008
80
GB
Hi, I'm running CRXI on XP and hope you can help.

I currently have the following crosstab:

Jan Feb Mar
Outcome1 {@InTime} {@InTime} {@InTime}
{@OutTime} {@OutTime} {@OutTime}

Outcome2 {@InTime} {@InTime} {@InTime}
{@OutTime} {@OutTime} {@OutTime}

This gives the result:

Jan Feb Mar
Outcome1 56 89 73
64 23 65

Outcome2 121 143 98
43 65 18

My problem is that I'm struggling to find a way to identify to the reader of the report that the top value is the 'In Time' figure and the bottom is the 'Out of Time'.

Any pointers or assistance would be much appreciated. I have tried to go the 'two crosstabs disguised as one' route but was unable to figure out how to remove the column labels.

Thanks in advance for your help.
 
No need to respond. I've sussed it with a Cross Tab Group Options formula.
 
If these are two different summary fields, you should be able to go to the customize style tab->summaries->check "show labels". Then edit the labels to the desired text.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top