Can you export from a Grid to excel ?

[Anis]

Re: Can you export from a Grid to excel ?

Andrea;

Where do you attach this script, what kind of control ?

[NoeticCC]

Re: Can you export from a Grid to excel ?

Andrea;

Where do you attach this script, what kind of control ?

Have a look at the web application demo that ships with Alpha5 - it's all there, the only thing I changed was change pdf to xls (only works in Version 9 of course).

Also, in a dialog, have a look at the "Server Events" in "Properties" - there is a genie that lets you select the report etc. - all you then have to do is change txt or pdf to xls and you're done. (I will submit the omission of the XLS choice as a bug report since this should be included in version 9!)

[NoeticCC]

Re: Can you export from a Grid to excel ?

The full instructions are here: http://support.alphasoftware.com/alp...ur_Browser.htm

(Just replace pdf with xls where needed, as I have done above)

[Anis]

Re: Can you export from a Grid to excel ?

Thank you so much for the Help.
Have a great day

[NoeticCC]

Re: Can you export from a Grid to excel ?

Thank you so much for the Help.
Have a great day

You too, I hope I haven't confused you - the instructions in the online help are for adding this code to an a5w page, I haven't tried inserting the same with the genie in the server events options for a dialog!

[Anis]

Re: Can you export from a Grid to excel ?

You know, I guess we should try to find a way to press a button on a gird (after searching the records that you need to display) This is important, otherwise you have to do the filtering at the time you generate the report, which means you have to ask the user again to re-enter the same criteria that they used viewing the grid.

so, do your search, press a button to export to excel, you're done.

[NoeticCC]

Re: Can you export from a Grid to excel ?

You know, I guess we should try to find a way to press a button on a gird (after searching the records that you need to display) This is important, otherwise you have to do the filtering at the time you generate the report, which means you have to ask the user again to re-enter the same criteria that they used viewing the grid.

so, do your search, press a button to export to excel, you're done.

Sure you can use page variables from the grid search instead of using a dialog, you just have to study the help files and the web app sample I mentioned above to figure out how to do that.

[Steve Wood]

Re: Can you export from a Grid to excel ?

Andrea - did you test this changing of pdf or txt to "xls"? It does not say anywhere in the documentation that you can just swap out xls for a recognized value. When you swapped out xls, did you get a valid xls file?

[NoeticCC]

Re: Can you export from a Grid to excel ?

Andrea - did you test this changing of pdf or txt to "xls"? It does not say anywhere in the documentation that you can just swap out xls for a recognized value. When you swapped out xls, did you get a valid xls file?

It works as I mentioned a few posts above where I popsted the amended scripts from the "Save as PDF" help file page - my motto is always "if it isn't in the documentation then try it anyway" - works for pretty much anything in my WAS page scripts aside from the UI_ functions, even if the help file says you can only use it in desktop apps :)

Also, I just heard back from Selwyn to say they fixed the bug in it not showing up in the report type selections in the dialog control's print report genie.

to fix immediately on your machine

edit this file in your a5v9 program folder:
WebComponentGenies\Print_Report[aftervalidate].Genie

look for this section of code, and add 'xls' to the list


dim rpt_type_list as c
rpt_type_list = <<%list%
PDF
HTML
TXT
XLS
%list%
dim rpt_type as c = "PDF"

[Steve Wood]

Re: Can you export from a Grid to excel ?

I agree it works. When I tested it produced a Alpha printer driver error. But worked on subsequent trials.

Here is the original post I mentioned on how to export to excel using xbasic.

http://msgboard.alphasoftware.com/al...ighlight=excel

[Anis]

Re: Can you export from a Grid to excel ?

The only reservation I have is that, PDF or reports in general shouldn't be treated like a worksheet, even though you could create a tabular report that has fields and records.

[NoeticCC]

Re: Can you export from a Grid to excel ?

The only reservation I have is that, PDF or reports in general shouldn't be treated like a worksheet, even though you could create a tabular report that has fields and records.

What do you mean? You are the one that wanted to export data to Excel! :)

[Anis]

Re: Can you export from a Grid to excel ?

You misunderstood my point.

I and many want to export to excel, but I meant to say it would be much easier to the user while working with data on a grid that display columns and rows already looks like a worksheet to just press the button to export the data.
I personally always separate reports from worksheets or databases, when I think of reports, I consider that as final place for the data, no further manipulation.

[Anis]

Re: Can you export from a Grid to excel ?

Steve, thanks for the demo, that is exactly what I meant, very nice job.

Andrea, thanks for all the help, you gave me some insights on new things I could explore.

[NoeticCC]

Re: Can you export from a Grid to excel ?

You misunderstood my point.

I and many want to export to excel, but I meant to say it would be much easier to the user while working with data on a grid that display columns and rows already looks like a worksheet to just press the button to export the data.
I personally always separate reports from worksheets or databases, when I think of reports, I consider that as final place for the data, no further manipulation.

Oh I see, yes I do think it would be a nice feature for A5 to allow you to insert such a control into a grid without needing to hard-code the export specifically!