topic Re: Enable Refresh Button/Menu in the Generated Report in Application Development and Automation Discussions

Enable Refresh Button/Menu in the Generated Report

Former Member — Wed, 15 Apr 2009 06:48:14 GMT

Dear Experts,

I have created a program that generates report based on the user defined parameters.

My question is, how do I enable the Refresh button/menu in the generated report so that user

won't have to back to the parameter screen and re-execute?

Thanks.

Kath

Re: Enable Refresh Button/Menu in the Generated Report

Former Member — Wed, 15 Apr 2009 06:53:04 GMT

Hi Kathy,

From the GUI Status you can enable the refresh button,

but you have to do manually that your grid shoud refresh.

like below

if sy-ucomm = 'REFRESH',
,," all your select queries run as per requirement to show in the in the grid.
endif.

Thanks

Re: Enable Refresh Button/Menu in the Generated Report

Sandeep_Panghal — Wed, 15 Apr 2009 06:54:00 GMT

Hi Kathy,

As you mentioned that your report generates o/p based on selection parameters entered by the user.

So if you add refresh button as well the program needs new i/p to generate the reprot again.

Rgds,

Sandeep

Re: Enable Refresh Button/Menu in the Generated Report

Former Member — Wed, 15 Apr 2009 06:54:43 GMT

hi,

how r u generating the report is it slis or grid display.if ur using REUSE_ALV_LIST_DISPLAY,then in the event set pf ststaus,in the pf status u created u can give the standard code for the buttons.If it is grid u can use refresh table ..

Re: Enable Refresh Button/Menu in the Generated Report

former_member219162 — Wed, 15 Apr 2009 06:57:51 GMT

You can enable the REFRESH PUSH BUTTON using the "PF-STATUS" screen (TCODE : SE41). Below code can re-execute the report once more.

AT SELECTION-SCREEN.

CASE sy-ucomm.

WHEN 'REFRESH'.

:----~~> Call the section of the report that fetches data and prints it <~~----:

WHEN 'BACK'.

:----~~> LEAVE TO SCREEN 0. (that means go back to main screen <~~----:

Re: Enable Refresh Button/Menu in the Generated Report

former_member873340 — Wed, 15 Apr 2009 06:59:53 GMT

Add a button(say Refresh ) in the application toolbar of the GUI Status.

When the user clicks on REFRESH button, execute the report for the same set of input parameters which the user has entered while executing the report.

When 'REFRESH'.

submit <report> skipping the selection screen. ( not sure of the syntax, check it out).

Gowri

Re: Enable Refresh Button/Menu in the Generated Report

Former Member — Wed, 15 Apr 2009 07:04:22 GMT

How is the output shown on the screen ?

With Write statements it won't be possible, but with an ALV it is. You need to add a button to the application toolbar, usually it is present in the standard PF-STATUS, but if not then simply add one.

Now when you capture the user command in the subroutine for handling user commands which looks like this,


FORM user_command USING r_ucomm LIKE sy-ucomm
                        rs_selfield TYPE slis_selfield.

Follow these steps

1. Refresh the output table that you have passed to the ALV.

2. Fetch all the data again and populate the output table.

3. Set the rs_selfield-refresh = 'X'. , this structure is passed to the user_command subroutine as shown above.

regards,

Advait

Re: Enable Refresh Button/Menu in the Generated Report

Former Member — Wed, 15 Apr 2009 07:10:17 GMT

i'm not using the alv, i just used the basic write syntax. thanks.