Array in a Cross-Tab

[eliasc]

Hi,

I am using CR 10, and I am trying to populate the columns to look like below:

ATL INVOICE ATL SERVICE ATL WARR. BIRM INVOICE BIRM SERVICE.

Below is the array I am trying to use, but CR is telling me I cannot use it. Can someone please help me.

The Array:

StringVar Array Companies := [
"HFSE - FW",
"ATLANTA INVOICE",
"ATLANTA SERVICE",
"ATLANTA WARR.",
"BIRMINGHAM INVOICE",
"BIRMINGHAM SERVICE",
"BIRMINGHAM WARR.",
"BGSI INVOICE",
"BGSI SERVICE",
"BGSI WARR.",
"PEN INVOICE",
"PEN SERVICE",
"PEN WARR.",
"JACKSON INVOICE",
"JACKSON SERVICE",
"JACKSON WARR.",
"FORT WORTH INVOICE",
"FORT WORTH SERVICE",
"FORT WORTH WARR.",
"JAX INVOICE",
"JAX SERVICE",
"JAX WARR.",
"LOUISVILLE INVOICE",
"LOUSIVILLE SERVICE",
"LOUISVILLE WARR.",
"OKLAHOMA CITY INVOICE",
"OKLAHOMA CITY SERVICE",
"OKLAHOMA CITY WARR."
];

How can I pass the above array to the column of a cross tab?

Thank you.

 

[Madawc]

A cross-tab is based on added detail records for two different fields. Here you want multiple values from just one record,

You could try a mock-crosstab - use SEARCH for details

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10