Not display comma in start of data in Report footer formula 1

[varadha72]

Hi can someone help me here. I have below outline in my report.
In Group Header:
@int
WHILEPRINTINGRECORDS;
STRINGVAR WorkingDay:="";
STRINGVAR finaloutput;

In GroupFooter-1a
@DisplayWorkingDays
WHILEPRINTINGRECORDS;
STRINGVAR WorkingDay;
WorkingDay;

In Details:
@WorkingDay
WHILEPRINTINGRECORDS;
STRINGVAR WorkingDay;
WorkingDay:=WorkingDay+ ","+ {cmd.PivotDate};
WorkingDay;

In Group Footer-1b
@FinalOutput
WHILEPRINTINGRECORDS;
STRINGVAR finaloutput:="";
Finaloutput:= TRIM({@@DispWorkingdays});

OUTPUT:I am getting output like ,8/1/2014,8/2/2014,8/3/2014

REQUIRED OUTPUT:8/1/2014,8/2/2014,8/3/2014

I need to get rid of the comma in the start. I tried using onfirstrecord and onlastrecord as well, but of no use. Please can someone suggest how I can get rid of the comma from the start only.

 

[SkipVought]

The RIGHT() of the WorkingDay string, for the LENGHT() of the WorkingDay string minus 1.

 

[varadha72]

Thanks I am was trying the same using left()
left(FO,len(FO)-1) which did not work, but right() worked thanks.

 

[pmax9999]

Another (perhaps simpler) approach would be to use the Mid function.

Also, your approach could be simplified slightly by changing your {@FinalOutput} formula to refer to the WorkingDay variable itself rather than the formula where it was created.

The formula would look like this:

[Code {@FinalOutput}]
WHILEPRINTINGRECORDS;
STRINGVAR WorkingDay;
WorkingDay := Mid(Trim(WorkingDay,2));
WorkingDay
[/Code]

Hope this helps.

Cheers
Pete