what is drill down report

[Former Member]

hi

experts can u help me for this

[former_member386202]

Hi,

Its an Interactive report where in the user can get more relavent data by selecting explicitly.

regards,

Prashant

[Former Member]

Hi,

Drill down report and interactive report both are same.

In this first u get one Basic list and then double clicking on any perticular record of that list, u can get detail list for that....

Hope it will helpful to u.

[Former Member]

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.

1.What is the difference between Drilldown reprt and Interactive 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.

regards,

srinivas

<b>*reward for useful answers*</b>

[Former Member]

Hi

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

reward if usefull

[Former Member]

nothing difference for interactive and drill down

i am giving a clear example so that u can clearly understand

in this example you have a mainreport REPORT1. From REPORT1 you

can drill down to REPORT2 and from REPORT2 you can drill down

to REPORT3.

Tip: Use hotspots to fire the AT LINE-SELECTION event.

When the cursor is over the hotspot, it cganges to a hand,

and you just have to click on the hostspot, instead of

double clicking.

Note: To see how to recognize if the user has selected a valid line, take a look at

How to check if a valid line is selected before drill down.

START-OF-SELECTION.

• Read data for REPORT1 into itab1

END-OF-SELECTION.

PERFORM write_report1.

TOP-OF-PAGE.

• Write list header for REPORT1

AT USER-COMMAND.

• Respond when the user presses a function key

CASE sy-ucomm.

WHEN 'REPORT2'.

PERFORM write_reprt2.

WHEN 'REPORT3'.

PERFORM write_reprt3.

ENDCASE.

AT LINE-SELECTION.

• Istead of pressing a button can perform the same actions

• as i AT USER-COMMAND, by double clicking a line

• sy-lsind contains the list level.

• Each time an interactive list event occurs, sy-lsind is

• automatically increased by 1.

• At REPORT1 sy-lsin = 0

CASE sy-lsind.

WHEN 1.

PERFORM write_reprt2.

WHEN 2.

PERFORM write_reprt3.

ENDCASE.

TOP-OF-PAGE.

• Write report header for report1 ( sy-lsind = 0 )

TOP-OF-PAGE DURING LINE-SELECTION.

• Write report header for sub reports

CASE sy-lsind.

WHEN 1.

• Write report header for REPORT2.

WHEN 2.

• Write report header for REPORT3.

ENDCASE.

FORM WRITE_REPORT1.

LOOP at itab1.

• write report1.......

• Hide keyfields used for the select statement of

• report2

HIDE: itab1_year, itab1_month.

ENDLOOP.

ENDFORM.

FORM WRITE_REPORT2.

SELECT * FROM databasetable2 into itab2

WHERE year = itab1_year AND

month = itab1_month.

LOOP at itab2.

• write report2 .......

• Hide keyfields used for the select statement of

• report3

HIDE: itab2_carrid.

ENDLOOP.

ENDFORM.

FORM WRITE_REPORT3.

SELECT * FROM databasetable3 into itab3

WHERE carrid = itab2_carrid.

LOOP at itab3.

• write report3 .......

• No need to hide keyfields, as further drill down is not

• possible

ENDLOOP.

ENDFORM.

regards

Giridhar