Layout issue in export multiple queries to single excel

[Former Member]

Hi ,

While exporting more than one queries on web template to single excel (with help of HowToWebPrinting document ), i am facing layout problems.

EX. if my web template has 4 queries in below format

A B

C D

where A,B,C,D are different queries

on web printing to single excel, i get all queries in excel but they are in form

A

B

C

D

i.e with distorted layout. Is there a way out to have the exported EXCEL in same layout as that of my report

Any ideas would be appreciated in this regard.

Best Regards

Deepali

[Former Member]

Thanks Deepak for your suggestion on trying to enhance

Z_PRINT_SERVICE class.

But in my system, i have z_print_help_service & not z_print_service. Is it something that is missing.

To add to it, i have one more issue.

I have a strange scenario.

In some webtemplates, when i do export , my all data is coming.

In some alternate columns are coming on export in one row

& other row its fine, while on web report all columns are existing .

Has anybody faced missing data on export .

Unless this problem gets resolved, we can't be sure of what is being produced & won't be able to implement. Below are lines i am using

in each template.

<param name="HELP_SERVICE" value="Z_PRINT_HELP_SERVICE_ALL_DP"/>

<param name="HELP_SERVICE_CLASS" value="ZCL_RSR_XLS_HELP_WINDOW_PRINT"/>