Skip to Content
author's profile photo Former Member
Former Member

ABAP Report

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 06: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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • Posted on Dec 23, 2008 at 06: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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 07: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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 23, 2008 at 11:14 AM

    Please use a more informative subject in future

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.