SQ01

[Former Member]

Hi

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.

[Former Member]

Hi

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.

[Former Member]

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@

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

yes Anurita, it is already FILESTORE that is selected.

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

[Former Member]

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

but it shud be changed to txt.

is it possible?

[Former Member]

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.