Cross Tab Column formula

[DannyBill]

I'm using CR 9 with an SQL database.

In one of the database fields we have multiple "codes" entered representing issues that need corrected ex... 001, 002, 003, 004 and so forth for various locations on each map of our network.
I'm trying to set up the cross tab using the codes as rows and map numbers columns so that i can summarize the quantity of each code on each map number.
Currently, the cross tab is only recognizing the first code in the field. I'm trying to figure out how to get the cross tab to look at each code in the field individually.

 

[lbass]

I think you'll have to create a manual crosstab where you insert a group on map numbers and then create a series of conditional formulas for the codes, like:

//{@code001}:
if "001" in {table.string} then 1

//{@code002}:
if "002" in {table.string} then 1 //etc.

Then insert summaries (sums, not counts) on these formulas at the group level and then suppress the details.

-LB

 

[DannyBill]

I have tried the manual cross tab but there are a total of 109 codes so in order to get them all to fit on the page the print is way to small.Is there a way with the manual cross tab for it to expand pages horizontally as well?

 

[lbass]

If the report is just for viewing, not printing, you could install a printer driver that allows very wide pages. Please see thread767-905030.

-LB