topic Re: Taking printouts while executing a report in Application Development and Automation Discussions

Taking printouts while executing a report

Former Member — Sun, 07 Mar 2010 09:15:31 GMT

Hi,

I have one report which displays output in ALV and the user taking print out of the list using print button. Currently user wants an option to select print functionality in selection screen and based on the selection report should automaticaly gave the print out .

Can i use the below FMs to do this.

SLVC_TABLE_PS_TO_SPOOL -

send the internal table data to Spool.

RSPO_OUTPUT_SPOOL_REQUEST' -

Spool to printer

Please reply.

Regards,

Ratheesh

Re: Taking printouts while executing a report

vinod_vemuru2 — Sun, 07 Mar 2010 13:10:16 GMT

Hi,

Not sure if above works. But you can try in this way.

IF po_print EQ 'X'.  "Selection screen parameter is selected.
PRINT-CONTROL ON.  "Redirect the o/p to spool.
CALL ALV FM
PRINT-CONTROL OFF.

CALL ALV FM again as usual

You may need to set the print parameters accordingly and printer is connected to SAP system.

Thanks,

Vinod.

Re: Taking printouts while executing a report

Former Member — Sun, 07 Mar 2010 13:37:54 GMT

Hi ,

Can you tell me what you mean by call the ALV FM again and please tell me how to set the print parameters.

Regards,

Ratheesh BS

Re: Taking printouts while executing a report

vinod_vemuru2 — Sun, 07 Mar 2010 15:55:28 GMT

Hi,

o/p displayed by the first FM call between PRINT-CONTROL statements is sent to the spool. second FM call with same data is used to display on screen. You need to add one more condition for checking sy-batch is initial or not.

IF po_print EQ 'X' AND sy-batch IS iNITIAL. "Means running in foreground.

I think print parameters are taken by default if not specified. First try above solution. If not works you can try setting the print parameters. There is some FM for this. Search in SE37 with SETPRINTPARAM

Thanks,

Vinod.

Re: Taking printouts while executing a report

Former Member — Sun, 07 Mar 2010 16:29:09 GMT

Can you tell me what you mean by call the ALV FM again and please tell me how to set the print parameters

it means the "Reuse_alv_list_display " or "resuse_alv_grid_display" funtion module......

Regards,.

Re: Taking printouts while executing a report

Sandra_Rossi — Sun, 07 Mar 2010 17:03:13 GMT

There is a parameter IS_PRINT to print directly. See demo program BCALV_TEST_FULLSCREEN_PRINT.

Re: Taking printouts while executing a report

vinod_vemuru2 — Sun, 07 Mar 2010 18:48:07 GMT

Hi,

Call the FM again, call the reuse ALV FM...

I think you got another better solution.(Set IS_PRINT = 'X'). Try this and let us know if it works.

Thanks,

Vinod.

Re: Taking printouts while executing a report

Former Member — Mon, 08 Mar 2010 07:41:35 GMT

Hi Sandra,

The example program will Pop up a dialog box for entering the output device, i want to avoid this pop up box.

How can i do this?

Regards,

Ratheesh BS

Re: Taking printouts while executing a report

Sandra_Rossi — Mon, 08 Mar 2010 09:54:21 GMT

As I can see, it uses REUSE_ALV_GRID_DISPLAY, which then calls form PRINT_PARAMS_SET2 in program SAPLKKBL. There it initializes L_NO_DIALOG variable to 'X' only if it runs in background. Do it using SUBMIT VIA JOB ... and of course you have to define a printer in the job print parameters.

Re: Taking printouts while executing a report

SuhaSaha — Mon, 08 Mar 2010 10:01:43 GMT

Hello Sandra,

Does this mean we cannot suppress the dialog box when executing the ALV in online mode ?

If i remember correctly the PRIPARAMS in the ALV print params structure has NO_DIALOG field. But it does not seem to work in online mode.

Can you please explain your solution in detail ?

BR,

Suhas

Re: Taking printouts while executing a report

Sandra_Rossi — Mon, 08 Mar 2010 10:14:22 GMT

> Does this mean we cannot suppress the dialog box when executing the ALV in online mode ?

That's right (at least with REUSE_ALV_GRID_DISPLAY)

> If i remember correctly the PRIPARAMS in the ALV print params structure has NO_DIALOG field. But it does not seem to work in online mode.

No, NO_DIALOG field doesn't exist in PRI_PARAMS. It's only a parameter in GET_PRINT_PARAMETERS function module. As I explained, the only control you have on it is to run it in background.

> Can you please explain your solution in detail ?

You create another program which runs REUSE_ALV_GRID_DISPLAY with IS_PRINT-PRINT = 'X', and you call this program in background using SUBMIT VIA JOB.

If you want more information about SUBMIT VIA JOB, then could you ask a new question. Only one by thread as explained in forum rules. Or, search forum: http://www.sdn.sap.com/irj/scn/advancedsearch?query=pri_paramssubmitvia+job