CROSSTAB - How to rename column headings? 1

[wld1957]

I have a crosstab that has a date field in the row. In the column it is based on a code that has been typed in the database. Is it possible to rename the column headings to read a name associated with the code that has been typed in. I have had some sucess and can get it to rename based on one of the codes using the "display string" under common under format field. This is what I have so far but all the columns come back "OUT OF COUNTY". Any help would be greatly appreciated. Thanks in adance. I'am using CRXI.

If {sys_trac.actioncode} = "ICX" THEN "IN COUNTY"
ELSE "OUT OF COUNTY"

// NEED TO CONVERT THE FOLLOWING CODES TO FULL NAMES
// ICX TO "IN COUNTY"
// OCX TO "OUT OF COUNTY"
// SS TO "SALES"

 

[synapsevampire]

A heading is a label for data, not data.

A column heading doesn't change based on every field in the database.

Do you expect that as the user is scr4olling down it will change how that column is labeled, or?

The post doesn't make sense.

You can change the value within the crosstab cells using a formula, and you can change the entire column name to some value, and you can make additional columns with each value within, but what you are asking isn't logical.

You might want to post example data, and how you want it to display, you may just be using terms inappropriately.

-k

 

[lbass]

In the crosstab expert, select the column->group options->options tab->customize group name->use formula as group name->x+2 and enter the following formula there:

select {sys_trac.actioncode}
case "ICX" : "IN COUNTY"
case "OCX" : "OUT OF COUNTY"
case "SS" : "SALES"

-LB

 

[wld1957]

Thanks for the help lbass. Worked great and saved me a great deal of time.