12-23-2008 6:06 AM
Moderator message: Please use a more informative subject in future
Experts,
Can anybody help me in this outstanding issue?
My requirement is like this:
I have to display the number records in Top of page and Body of the report with alignment.
Here, I am able to display the data in the body of the report , but problem is with the Top-of-page (Here , It is giving alignment problem when I display with number of records). Also, that whole data should be able to downloaded into excel also.
Thanks in advace...
Sridhar..
Edited by: Matt on Dec 23, 2008 12:13 PM
12-23-2008 6:11 AM
Hi,
it is a trail and Error method , using the add_gap method you have to adjust the texts. otherwise you have to use the method add_table. see the usage of the method in the program DD_STYLE_TABLE.
And check this thread
[https://forums.sdn.sap.com/click.jspa?searchID=20242748&messageID=6639339]
Edited by: Neha Thukral on Dec 23, 2008 7:13 AM
12-23-2008 6:11 AM
Hi,
it is a trail and Error method , using the add_gap method you have to adjust the texts. otherwise you have to use the method add_table. see the usage of the method in the program DD_STYLE_TABLE.
And check this thread
[https://forums.sdn.sap.com/click.jspa?searchID=20242748&messageID=6639339]
Edited by: Neha Thukral on Dec 23, 2008 7:13 AM
12-23-2008 7:31 AM
Neha,
Thank you for quick response.
I have already tried with that what you suggested me. But the issue is , when I display
multiple records : (Layout is like this)
(Here I am using I_HTML_TOP_OF_PAGE)
Plant Storage Location Batch DATE
3000 100 1000 10/01/2008
3000 100 444AB 11/04/2008
3000 100 AAAAAC 14/12/2008
Body of the report (Which I am displaying in the alv grid):
This part is good.
Some data in body of the report.
If I display the data in top page, you can see the alignment problem where I am getting(Batch and Date).
I can do this with splitting functionality using OOPs(Using two grids in two containers, but I can't download and print whole data at a time).
This is what my issue.
Thanks..
12-23-2008 8:22 AM
hi
didnt understand exactly..try if this helps.
if Plant Storage Location Batch DATE
is the header you are considering
then each have specific length.count the total length declare another variable with this lengh or string.
pass the individual variable at the particular offset value.
then finally pass the variable
12-23-2008 6:12 AM
Hi
Go for ALV Report. Be more specific about your questions. This sort of questions will never encourage any body to answer. Please do workaround on your own.
Regards,
Hakim
12-23-2008 7:24 AM
Hi sridhar,
as far as my knowledge of understanding is concerned
you have 2 issues
1) the problem of alignment
2) data download to excel
solution:
1) sy-dbcnt
REPORT : name of your report.
TOP-OF-PAGE.
WRITE: sy-dbcnt, 10 'NUMBER OF RECORDS'.
ULINE.
if you are using the
loop
{
}
end loop.
sy-loopc will hold the number of loop lines / rec which you can display at the top-of-page
2) you can use many function modules like alsm_excel , msl_excel_ole_standard , gui_download
or sap has given the option for you to download into excel list---> save as----->excel format.
hope this is useful
thanks
srikanth.p
12-23-2008 11:14 AM