hi all...
iam having one requirement... that to get output with grandtotals for one field...
and
if i click the push button in output application tool bar of that report(EXCEL) , i need to get excel format file...into my presentation server...
for this i used gui_download function module...
but as we know iam not getting grandtotals of that field in excell output...
why?
because.... i can just down load the one populated internal table into files.. but not their looping activities...
and any way i got succeded apart of that...
*****************************************************
but..,
now my requirement is to get grand totals of that field in excel sheet also...at bottom of the same field (just like in report)..
so i went for the following syntax , just before down load the itab...
itab-f1 = ' ' .
itab-f2 = ' ' .
itab-f3 = ' ' .
itab-f4 = ' ' .
itab-f5 = tot_f5 .
itab-f6 = ' ' .
append itab.
here tot_f5 is the variable which is filled with the grand toatl value of that field.
so my my problem solved... because... iam getting grand totals in last row and just in down CELL of the same field...
😊
as you know technically this is the another record of the internal table...so al other fields of last row are also there but spaces...
😔
So...here i got another problem...that is with second fieldof itab,which is the date field..so at last line of my output file iam not only getting total value for field5 but also getting two slashes( / / ) for the field2
( because that date field i have to calulate and fulfill with concatenate taement with month adte year seperaters "/")
if i declared that field as char 10 then iam not getting seperaters ofr all dates..in excel sheet....
how can i rectify this....
my problem has to solve at this program level only..
thank you very much for valuble time..