Good Morning.
I am working on a report that needs to show detail about a group of data and then have a group footer that counts the occurences, sums up the total number of days and also shows the average number of days for the group. Everything seems to be working and I am getting the correct values but I can not format the average number of days to show 1.55 instead of 1.578901234.
I have entered {0:N2} in the Format field for that text box's properties and that seems to have no effect.
I am also having a problem when exporting the report to Excel it is showing all of the number fields as text in the spreadsheet, even though I am using {CDbl(Fields.[DAYS_BETWEEN])} as my Value.
I would appreciate any help that you can give me on these problems. I am using Telerik Reporting Q1 2009.
Tim
I am working on a report that needs to show detail about a group of data and then have a group footer that counts the occurences, sums up the total number of days and also shows the average number of days for the group. Everything seems to be working and I am getting the correct values but I can not format the average number of days to show 1.55 instead of 1.578901234.
I have entered {0:N2} in the Format field for that text box's properties and that seems to have no effect.
I am also having a problem when exporting the report to Excel it is showing all of the number fields as text in the spreadsheet, even though I am using {CDbl(Fields.[DAYS_BETWEEN])} as my Value.
I would appreciate any help that you can give me on these problems. I am using Telerik Reporting Q1 2009.
Tim