Downloading the query

[Former Member]

hi,

I am displaying the report on web and when the user wants to download the data into excel then he gets all the data downloaded into excel but the user want to download the selection criteria what he entered in the selection screen...like for ex.if he enters period 1/2006 to period 12/2006, then he should download this range of periods also in to excel, how can we do that?

Thanks in advance.

[Former Member · Accepted solution]

Hi,

I am assumung you are using a Web Template in version 3.X.

You will need to add a web item named "Text Element"

Then from the "Text Element" properties you'll need to click on the 3 points (...) next to List of Text Elements.

You will then need to select Element Type = Filter Value and and in the element ID put the technical name of th infoobject that your user uses in the selection.

Then you will need to make sure that you have a "Download to Excel" button that will download the entire template (including the text elements.

Hope it helps (if so please assign some points..)

Thanks,

Gili

[Former Member · Accepted solution]

Thanks for the response....

Assigned Points.

I kept the technical name of the info object and the setting as Filter but what is happening is i am getting the Text element there but i am not getting the info like 001/2006 to 012/2006. Let me know if i am missing something..

Thanks in advance.

Message was edited by:

ASRao

[Former Member]

Ask the user to filter the data that he / she wants, get the result set and download.

Ravi Thothadri

[Former Member]

I apologize for not giving clarity in the description, what i mean by downloading the results is....when the user enters period range 001/2006 to 012/2006 in the selection screen then he gets the results for period 1 to 12 of 2006 when he downloads to the excel sheet but he also wants to see the selection criteria in the excel in this case he wants to see in the excel sheet what selection criteria he entered like selection criteria = 001/2006 to 012/2006 and then results for this period range.

When you execute the report in excel i think you will see what selection criteria you entered along with the results in the excel sheet. In a similar way , he is looking forward for the same excel sheet when he downloads from web where he wants to see what selection criteria he entered in the selection screen and also the results for the selection critieria..

Thanks in advance...

[Former Member]

Not sure i completely understand the question.

The selection screen limits the output to for example 1-12/2006.

When the user downloads to Excel he downloads that output, so in any case he downloads the filtered results. Give it a quick try and let me know, or elaborate a little bit more.

Hope it helps,

Gili