topic Re: Issue with Saving the Query output data in Excel format in Application Development and Automation Discussions

Issue with Saving the Query output data in Excel format

Former Member — Wed, 28 Jul 2010 06:31:42 GMT

Hi,

Recnetly we had upgraded from 4.6c to ECC 6.0.

In ECc 6.0 environment, when user try to export the query output , we are getting only XML option to save the data.

But user want to save the data in EXcel format, he was able to do that in 4.6C.

pleas eprovide some inputs, on this issue.

Thanks,

Sanketh.

Re: Issue with Saving the Query output data in Excel format

Former Member — Wed, 28 Jul 2010 06:51:49 GMT

Sanketh,

Since you upgraded from 4.6 to ecc

Did you search OSS NOTES? Pls take some time and search

Re: Issue with Saving the Query output data in Excel format

Former Member — Wed, 28 Jul 2010 08:47:57 GMT

I cannot for the life of me imagine, why a link to a post in the 'Business One Forum' where one uses ODBC to transfer query-data to MicroSoft Excel is of relevance to the OPs question, even if the same is not a security issue.

Never mind. [note 40155|https://service.sap.com/sap/support/notes/402155] deals with various symptoms in the ALV-Excel combination as as of release 4.6C. There are various others, mostly in components BC-SRV-ALV and BC-ABA-LI - also: I remember that when we upgraded from 4.5B to 4.7C there was an issue with Excel-templates -> the solution was in the release notes somewhere. So, in addition to SMP you might want to check the release notes and/or upgrade guide for solutions.

And yes, moderators ... this is not a security issue, this should go to ECC-Applications/Upgrade.

Re: Issue with Saving the Query output data in Excel format

Former Member — Wed, 28 Jul 2010 16:53:21 GMT

Yes I agree.

But before you do that can you please post

what are the values for the following objects for the USER

S_GUI ( Give * for this object and see if it works )

S_DOKU_AUT

S_TRANSLAT

Edited by: Franklin Jayasim on Jul 28, 2010 7:01 PM

Re: Issue with Saving the Query output data in Excel format

Former Member — Thu, 02 Sep 2010 17:13:19 GMT