topic Re: SQ01 in Application Development and Automation Discussions

SQ01

Former Member — Fri, 31 Oct 2008 09:58:50 GMT

I have a requirement. After executing a report or query in SQ01, the default file store format is excel file in 'Output format' tab. Is it possible to change the default store format of the file to txt (text format)? if yes, how it can be changed.

Re: SQ01

Former Member — Fri, 31 Oct 2008 10:10:32 GMT

Hi,

It is possible when you are using GUI_DOWNLOAD function

module then give the file format as .txt.

Will download the file in TXT format

Call 'gui_download'

exporting

filename = 'E:\filename.txt'

tables

data_itab = itab.

Cheers!!

VEnk@

Re: SQ01

Former Member — Fri, 31 Oct 2008 10:12:21 GMT

in the tcode itself, when they execute any query or report, they should get the default as txt but not xls.

they can download in txt manually changing the format.

but they want the default as txt in the screen itself.

Edited by: Priya Madhavi on Oct 31, 2008 11:12 AM

Re: SQ01

Former Member — Fri, 31 Oct 2008 10:15:35 GMT

For every query there will report generated copy it to zreport and use gui_download in that report.create a tcode for that report.

Re: SQ01

Former Member — Fri, 31 Oct 2008 10:19:01 GMT

actually, my requirement is as mentioned before, in the main SQ01 screen, there wil b list of queries,

If a query is executed then in the next screen, in the OUTPUT FORMAT tab, it will show the STORAGE FORMAT in which the default format of the file is xls(where the report is downloaded). this default is to be changed to TXT.

Re: SQ01

Former Member — Fri, 31 Oct 2008 10:31:24 GMT

Hi Priya,

The default selection in 'Output Format' can be changed while creating the Query in SQ01 or in the existing Query, it can be changed by Changing the Query.

For this, in Transaction SQ01, select the name of your query and Press 'Change'. The First Pop-up screen which you will get where Title, Notes, List,format, Table format, etc. are given, at the end there is option of Output format. You can select the default format there.

Re: SQ01

Former Member — Fri, 31 Oct 2008 10:36:55 GMT

yes Anurita, it is already FILESTORE that is selected.

but is default xls, can v change it to txt?

Re: SQ01

Former Member — Fri, 31 Oct 2008 10:44:07 GMT

when we click on the FILESTORE button, then the defaul is xls,

but it shud be changed to txt.

is it possible?

Re: SQ01

Former Member — Fri, 31 Oct 2008 11:13:41 GMT

As per my knowledge, the format cannot be changed to txt.

The other option which you can try is select the Format 'Word Processing' which gives the output in MS Word Format.