topic Re: ALV Reporting in Application Development and Automation Discussions

ALV Reporting

Former Member — Tue, 28 Jun 2005 08:23:56 GMT

Hello All,

I need to create a report in the following format:

SAMPLE REPORT

HEADER 1 : Value1

HEADER 2 : Value2

HEADER 3 : Value3

DETAIL1 DETAIL2 DETAIL3 DETAIL4 DETAIL5 DETAIL6

Value 1 Value2 Value3 Value4 Value5 Value6

followed by table

COL1 COL2 COL3 COL4

FOOTER7 FOOTER8

Value7 Value8

FOOTER9 : Value 9

All those 'Values' represent dynamic values .Rest are fixed .My doubt is by using REUSE_ALV_COMMENTARY_WRITE ,I am able to populate HEADER1, HEADER2 , HEADER3.

Can i show DETAIL1 to DETAIL6 in the format that i have represented followed by table and footer.

Please let me know, if anyone knows about this.

Regards

Amruta

Re: ALV Reporting

Former Member — Tue, 28 Jun 2005 09:19:08 GMT

Hello,

It would be better to use write statements and get a desired list that you are seeking for instead of using ALV. You can see the ergonomics examples in the sap editor se38 go to enviroment -> ergonomic -> lists.

Regards,

Shekhar Kulkarni

Re: ALV Reporting

Former Member — Tue, 28 Jun 2005 09:55:35 GMT

Hi Amruta,

There are a few questions that pop, before addressing the solution :

a) Are you unable to populate Value1, along side your Header 1 , since you say Value1 will be values generated at runtime ?

Use concatenate to append constant text with runtime values and put the value in the field info.

b) Are you unable to generate the footer as shown in your post ?

In order to have multiple lists in the same page , you have REUSE_ALV_BLOCK_LIST_APPEND

To show Detail1 and the table, you can use the above function module and display two lists in the same page.

One way to have header and footer your way is to use the REUSE_ALV_COMMENTARY_WRITE in top of page and end of page event. You might as well try using the field I_END_OF_LIST_GRID in the FM REUSE_ALV_COMMENTARY_WRITE.

Hope you find this information useful.

Regards,

Subramanian V.

Re: ALV Reporting

Former Member — Tue, 28 Jun 2005 10:07:47 GMT

Hello All,

Thanks for your replies.

I am able to populate all the values.That is not a problem.Problem is displaying in the format that I have shown.

DETAIL1 DETAIL2 ......DETAIL6

with values populated just below each of the headings.

We can use Write statements but then we also need to show the table for which is there any better option other that ALV.

Thanks and Regards

Amruta