Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

what is classic reporting and what is interactive reporting

Former Member
0 Kudos
1,560

hi

what is classic reporting and what is interactive reporting

1 ACCEPTED SOLUTION

uwe_schieferstein
Active Contributor
0 Kudos
815

Hello Jyothsna

My posting

<a href="https://wiki.sdn.sap.com/wiki/display/profile/2007/07/09/MessageHandling-FindingtheNeedleintheHaystack">Message Handling - Finding the Needle in the Haystack</a>

shows the reporting options ranging from classical (=static) WRITE lists over ALV lists (similar like Excel worksheets) to application logs.

In general, interactive reporting allows the user to structure, filter, sort the displayed information according to his or her specific needs. In addition, context menus on ALV list displaying sales orders may allow the user to jump directly to the sales order (transaction VA03).

If you are looking for interactive ALV reports sample then search the <i>ABAP Objects</i> forum for <b>ZUS_SDN</b>. I have posted several sample reports dealing with various aspects of ALV programming.

Regards

Uwe

8 REPLIES 8

uwe_schieferstein
Active Contributor
0 Kudos
816

Hello Jyothsna

My posting

<a href="https://wiki.sdn.sap.com/wiki/display/profile/2007/07/09/MessageHandling-FindingtheNeedleintheHaystack">Message Handling - Finding the Needle in the Haystack</a>

shows the reporting options ranging from classical (=static) WRITE lists over ALV lists (similar like Excel worksheets) to application logs.

In general, interactive reporting allows the user to structure, filter, sort the displayed information according to his or her specific needs. In addition, context menus on ALV list displaying sales orders may allow the user to jump directly to the sales order (transaction VA03).

If you are looking for interactive ALV reports sample then search the <i>ABAP Objects</i> forum for <b>ZUS_SDN</b>. I have posted several sample reports dealing with various aspects of ALV programming.

Regards

Uwe

Former Member
0 Kudos
815

HI

In ABAP, there are a total of 7 types of reports. They are:

· Classical

· Interactive

· Logical Database

· ABAP query

· ALV Reports (ALV stands for ABAP List Viewer)

· Report Writer/Report Painter

· Views (There are different types of views also)

4. TOP-OF-PAGE DURING LINE-SELECTION.

HIDE statement holds the data to be displayed in the secondary list.

sy-lisel : contains data of the selected line.

sy-lsind : contains the level of report (from 0 to 21)

Interactive Report Events:

· AT LINE-SELECTION : This Event triggers when we double click a line on the list, when the event is triggered a new sublist is going to be generated. Under this event what ever the statements that are been return will be displayed on newly generated sublist.

· AT PFn: For predefined function keys...

· AT USER-COMMAND : It provides user functions keys.

· TOP-OF-PAGE DURING LINE-SELECTION :top of page event for secondary list.

Reward all helpfull answers

Regards

Pavan

Message was edited by:

Pavan praveen

Former Member
0 Kudos
815

HI,

classical report means its a simple output screen(basic list).

interactive report means if u click on the output screen(basic list) it will give another screen(secondary list).like this u can generate 20 output screen(1 basic & 20 secondary lists).this programming is called as interactive reporting.

execute the program and double on the output values.see how it works.

here my example will give u 3 lists.

(and this program will work only if u create the menu in menu painter,se<b></b>41)

REPORT ZBHAIREP LINE-COUNT 15(1) LINE-SIZE 75.

TABLES: SFLIGHT.

DATA VAR LIKE SFLIGHT-CONNID.

DATA ITAB LIKE SFLIGHT OCCURS 0 WITH HEADER LINE.

SELECT-OPTIONS CARRID1 FOR SFLIGHT-CARRID.

SET PF-STATUS '<b>MENU</b>'.

SET TITLEBAR 'TIT'.

FORMAT HOTSPOT ON.

WRITE:/10 'AIRLINE CODE',25 'CONNECTION ID',40 'FLIGHT DATE'.

SELECT * FROM SFLIGHT WHERE CARRID IN CARRID1.

WRITE:/10 SFLIGHT-CARRID,25 SFLIGHT-CONNID,40 SFLIGHT-FLDATE.

HIDE SFLIGHT-CONNID.

ENDSELECT.

*END-OF-PAGE.

END-OF-PAGE.

WRITE:/64 'P.NO:',SY-PAGNO.

*TOP-OF-PAGE.

TOP-OF-PAGE.

WRITE:/ 'THIS IS MY FIRST REPORTS PROGRAM.'.

*START-OF-SELECTION.

START-OF-SELECTION.

DO 5 TIMES.

WRITE:/ SY-INDEX.

ENDDO.

*AT LINE-SELECTION.

AT LINE-SELECTION.

CASE SY-LSIND.

WHEN '1'.

  • READ LINE SY-LILLI FIELD VALUE SFLIGHT-CONNID INTO VAR.

  • SELECT * FROM SFLIGHT INTO CORRESPONDING FIELDS OF ITAB WHERE

  • CONNID = VAR.

  • WRITE:/ ITAB-CARRID,ITAB-PLANETYPE,ITAB-PAYMENTSUM.

  • ENDSELECT.

  • WRITE:/ VAR.

SELECT * FROM SFLIGHT INTO CORRESPONDING FIELDS OF ITAB WHERE

CONNID = SY-LISEL+24(4).

WRITE:/ ITAB-CARRID,ITAB-PLANETYPE,ITAB-PAYMENTSUM.

ENDSELECT.

SKIP 1.

WRITE:/ SY-LISEL+24(4).

  • SELECT * FROM SFLIGHT INTO CORRESPONDING FIELDS OF ITAB WHERE

  • CONNID = SFLIGHT-CONNID.

  • WRITE:/ ITAB-CARRID,ITAB-PLANETYPE,ITAB-PAYMENTSUM.

  • ENDSELECT.

  • WRITE:/ SFLIGHT-CONNID.

WHEN '2'.

WRITE:/ SY-LILLI.

WHEN '3'.

WRITE 😕 'BHARAT'.

ENDCASE.

rgds,

bharat.

Message was edited by:

Bharat Kalagara

Former Member
0 Kudos
815

Hi,

a)THE LIST PRODUCED BY <b>CLASSICAL REPORT</b> DOESN'T allow user to interact with the system .The list produced by <b>interactive report</b> allows the user to interact with the system.

b) ONCE A <b>CLASSICAL REPORT</b> EXECUTED USER LOOSES CONTROL.<b>interactive report</b> USER HAS CONTROL.

c) IN <b>CLASSICAL REPORT</b> DRILLING IS NOT POSSIBLE.IN <b>interactive report</b> DRILLING IS POSSIBLE.

Hope this helps.

reward if helpful.

Regards,

Sipra

former_member198270
Active Contributor
0 Kudos
815

Hi Jyothsna,

CLASSICAL REPORTS:

with these reports(basic reports) we can just display the data,after displaying we cannot further do or interact with the data.

EVENTS:

1) INITIALIZATION: this event is triggerred before selection-screen is displayed.

if any of the parameters/select-options are to be given default value, that can be defined here.

2)AT-SELECTION-SCREEN:

after selection-screen is displayed and user enters the values in the fields,this is trigerred to validate the input given by the user

3)START-OF-SELECTION:

This is the actually the first event of the report that occurs,data is selected here

4) TOP-OF-PAGE

when the first WRITE statement or whenever NEW Page ocucurs this is trigerred

this is used to display the page headings,column headings.

5) END-OF-PAGE

this event is trigerred when the end of the page is reached,

you have to explicitly specify the size of the end-of-page area using LINE-COUNT parameter of the Report stmt,If you do not define a size, the END-OF-PAGE area contains no lines and the event END-OF-PAGE is never executed.

this is used to display the footer text like page numbers etc.

6) END-OF-SELECTION.

after start-of-selection,this is trigerred.

here write:/ stmts are written to display the data.

These are the basic events used in normal reports.

INTERACTIVE REPORTS:

these are advanced step to normal reports,and more interactive.

Additional events in this are:

HIDE <f> stmt is an imp functionality here.

after displaying the list, if the user wants to further navigate by clicking on any of the data,this stmt is used.

f stores the data automatically of the currently selected line,which can be used to display further info on the other list.

1) AT LINE-SELECTION.

this is occured whenever the user clicks on a line the list,SY-LSIND holds the current list index.

2) AT USER-COMMAND

this event occurs whenever the user clicks a function key/any buttons on the app toolbar.

before this we have to set the PF-STATUS required .

SY-UCOMM holds the function code assigned while setting the status.

This event also available in normal list.

3)TOP-OF-PAGE during line-selection.

this is used to display different headers for different secondary lists.

NOTE:first list that is displayed is called BASIC LIST and others are called secondary lists.

There can be 21 lists for a report, 1 basic + 20 secondary.

I guess END-OF-PAGE is the only event not applied to INTERACTIVE lISTS.

Reward Points if helpful.

Regards,

Amber S

Former Member
0 Kudos
815

Hi,

CLASSIC REPORT-

A classic report is a program that generates a single list, which must contain all of the required detail information.

1) This procedure may result in extensive lists from which the user has to pick the relevant data.

2) The desired selections must be made beforehand and the list must provide detailed information.

3) To be able to use all advantages of the online environment, classical reporting

INTERACTIVE REPORT-

in interactive reports u can drill down to 2o secondary lists from 1 main main list.

thus making 21 lists in total.

for this use system variables sy-lisel, sy-lsind and at user-command event.

***do rewards if usefull

vijay

Former Member
0 Kudos
815

Difference between Drilldown report and Interactive report

1.What is the difference between Drilldown reprt and Interactive report?

2. Is there any similarity between Classical report and Drill down Report?

There is no difference between drill down and interactive report, they are the same.

With drilldown reporting, SAP provides you with an interactive information system to let you evaluate the data collected in your application. This information system is capable of analyzing all the data according to any of the characteristics that describe the data. You can also use any key figures you wish to categorize your data. You can display a number of objects for a given key figure, or a number of key figures for a given object. In addition, the system lets you carry out any number of variance analyses (such as plan/actual comparisons, fiscal year comparisons, comparisons of different objects, and so on).

You can produce both simple, data-directed lists (basic reports) and complex, formatted lists in drilldown reporting (form reports).

Drilldown report provides you with comfortable functions for navigating through your data. For example, you can jump to the next level of detail or the next report object on the same level, hide individual levels and switch between the detail and drilldown lists. It also provides a number of additional functions which let you process lists interactively (sorting, conditions, ranking lists, and so on). SAP Graphics, SAPmail and the Excel List Viewer are also integrated into drilldown reporting.

The drilldown functions are divided into three groups which differ in the number of functions available. That way each user can choose the functional level most suited for his requirements.

In addition to the online functions for displaying reports, drilldown reporting also provides functions which let you print reports. A number of formatting functions are available to let you determine the look of your printed reports (page breaks, headers and footers, underscores, and so on).

The menus and the functions available directly on the drilldown report make it easy to use the information system.

What is an Interactive Report?

An interactive report generally works in the following fashion:

1. Basic list is displayed.

2. User double clicks on any valid line

or

User selects a line and presses as button on the tool bar.

3. The corresponding event is triggered

4. Then in the code, the line on which action was done, is read.

5. Depending on the values in that selected line, a secondary list is displayed.

6. Steps from 2-5 are repeated till the end.

From the above explanation, I believe, its clear that, the 20th list, will essentially depend on the "selected line" of 19th list. According to your question, you want to move to 20th list directly, without "a prior list". May I know the exact requirement so that, an appropriate solution can be suggested?

Again, your question was, how to move to 20th list directly on pressing of execute button. Its not possible to move to 20th list. You must cross over a basic list, before you can go to a different list level, using the code given by Pavan.

What are Drilldown reports?

The lines of basic list of a drilldown report when clicked, will take the user to the corresponding (standard) object's display.

For eg: Suppose your report's primary component is purchase requisition, (assume you are printing PR details), and the basic list displays details of many PRs.

Eg: when clicked on a particular line of the PR basic list, it takes you to std t-code me53 (display of purchase requisition). This is the 'Drill-down' functionality.

For this, in the at-line selection of your program, as per the above ex: you'll set the parameter ID of PR number BAN (that you can get from Data element) in memory (using set parameter id) and then calling the corresponding transaction (usually skipping initial screen of the std t-code).

Likewise, if it's Material Number (Matnr), you'll be displaying MM03 transaction w.r.t. the line's matnr.

reward point if helpful....

regards...

ABhay.

Former Member
0 Kudos
815

Classic Reoprt is one in which there is a just a basic display of data. For eg. Data which is fetched from the database is displayed as it is on the output screen, with minimal formatting.

You cannot have functions like double click (Pick) or Hot-spot in an Classic Report.

For that, you have to create an interactive report, where in we can provide detailed drill downs of the Basic List. This is done using various EVENTS on the Screen.

There can be 20 such secondary windows apart from the Basic List.

You can find numerous examples given in SAP for the same. One such help link is :

http://help.sap.com/saphelp_erp2005vp/helpdata/en/d2/cb408a455611d189710000e8322d00/frameset.htm

Do reward points if this helped.

Thanks,

Pranjal.