ABAP Report

[Former Member]

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

[Former Member]

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

[Former Member]

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..

[Former Member]

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

[abdul_hakim]

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

[Former Member]

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

[matt]

Please use a more informative subject in future