Export to Excel and sort the columns

[jac53]

I converted one my programs but I can not put to work the export to excel property. When I hit the icon what I get is a blank excel.
The grid sort property does the sorting but in any order even when put ascending.

My process is initiated using Genie.
Any ideas?

[Brian]

So you converted the application to a Profound UI Rich Display File, or it is just running in Genie?

I'm not sure I understand what you mean about the grid sorting. Are you loading the grid in your RPG program or are you using the Database File property to load the grid?

[jac53]

I converted the application to a Profound UI Rich Display File.
The application is a subfile so the conversion tool created a grid. Using the visual studio I selected true for the sortable columns, in the default sort order property first I put descending and later I left it in blanks, it sorts but it does not sort in a descending logical order.
In the CVS export property I selected true but I get a blank excel.

My process start using a JDEdwards menu customize using Genie.

I hope it is more clear now.

[Brian]

OK. So it is sorting. I think I need some clarification on it not sorting in a "logical" order. What is illogical about the sort?

As for the Excel export, it should generate a CSV file that your browser will prompt you to download. Are you being prompted? What browser are you using?

[jac53]

Attached find a word document with print screens of I was trying to describe.

[Brian]

Ah, now I see what you have. This is a folded multiline subfile. The problem is, when there are multiple lines on each subfile row, the grid widget has no way to logically divide the data up in to columns. If you think about it, how could it?

So what it does is treat the whole grid as just one big column so that it can display the data properly. Since the sorting and excel export features depend on the grid columns to function, they just won't work in this situation.

Because your screen size is not limited, we often recommend moving the data from the additional lines into the first line to make this work, but I see you have 6 lines of data on each row, so this may not be practical.

[jac53]

Ok now it makes sense. By the way how do I can see folded multiline subfile individually no like the document I sent you which all of them are ovelaying?
Thank you

[Brian]

There is a property called "Single Row Zoom" that will allow you to expand only one row in the folded subfile. Is this what you are looking for, or did I misunderstand your intent?