topic scalable report in Application Development and Automation Discussions

scalable report

Former Member — Sat, 21 Oct 2006 04:18:45 GMT

How do you output a report whose size is scalable based on a user’s inputs. For example, if a user enters period 1 to period 12, the report displays 12 periods. If the user enters period 10 to period 12, the report displays 3 periods. The user can enter the periods cross the fiscal years. For instance: FY2005 period 11 to FY2006 period 3.

Vendors Company codes FY/per1 FY/per2 FY/per3 Total

Re: scalable report

guillaume-hrc — Sat, 21 Oct 2006 09:09:03 GMT

Hi Syed,

There are many possibilities.

Are you using ALV ouput or just a standard ABAP list with WRITE statements.

For ALV output, you may create a table dynamically and popuplate the field catalog accordingly.

For the WRITE statements, you might use a mere DO... ENDDO statement for such a requirement.

<b>Could you be a bit more specific so that we can tune the solution a little bit more?</b>

Best regards,

Guillaume

Re: scalable report

Former Member — Thu, 26 Oct 2006 20:37:10 GMT

Hi Guillaume,

Sorry for my ignorance but I want to use ALV but dont know how. Secondly if I how do I create a table dynamically?

Re: scalable report

guillaume-hrc — Thu, 26 Oct 2006 20:54:48 GMT

Hi,

There are 2 flavors for ALV : either using Function Modules or using ABAP OO.

The ABAP OO is maybe the most refined as far as "personalization" is concerned but the first one is a good choice for beginners.

For functions, have a look at sample examples BALVGRID* and BALBLIST*

For creating a table dynamically you have the class CL_ALV_TABLE_CREATE and its method CREATE_DYNAMIC_TABLE

Also have a look at :

/people/ravikumar.allampallam/blog/2005/05/31/expand-the-list-of-columns-in-a-report-dynamically

And last (but not least), have a look at the code provided by Rich in this topic :

and by Jayanthi in this one

Best regards,

Guillaume

<i>PS: If your problem is solved, please close the thread and award points for useful answers.</i>