I have a BY FIELD which is a variable like this.

  
BY  &RP_FN01B_Sort1.(BY(<District,DIM_DISTRICT.DISTRICT_ID>,<City,DIM_CITY.CITY_DESCR>,<Month,SALE_MONTH>)).Please select sort field(s).

When i run the report i am getting Sort field column headings as
DISTRICT_ID CITY_DESCRIPTION SALE_MONTH
but instead i want to get headings like
District City Month.
I cannot give AS NAMES here as sort by fields are in a variable.
Can't make changes in master file as well.

Any idea to implement this.?

This message has been edited. Last edited by: srajeevan,

I'm afraid the best solution is to set the TITLE value in the master files.

I will keep that solution as the last resort Babak.

Thanks

Not very practical but what if you had a DEFINE for each one of the columns that has the title as the fieldname?

 
DEFINE FILE XYZ
District/A10=DIM_DISTRICT.DISTRICT_ID;
City/A50=DIM_CITY.CITY_DESCR;
Month/HM=SALE_MONTH;
END

Then use these defined fields in your BY like this:

BY  &RP_FN01B_Sort1.(BY(<District>,<City>,<Month>)).Please select sort field(s).
 

Yeah.That is a possible solution i can use.
I have more than 2 sort fields,but yeah i don't have to touch master file.

It'll only work if you don't have spaces or special characters in them though.

For now it works good for me.

Thanks