Method:Classic General Q&A

Re: Question About Exporting A Grid to Excel with Hidden Columns

Method_Michael — Fri, 22 Jul 2011 16:12:54 GMT

Matt-

Action 9 exports the the contents of the grid so having it within a Loop(Actions 8 and 10) is essentially exporting the whole grid or just the checked grid rows multiple times. Normally conditional warning are set before a set of actions not at the very end, a conditional warning stops a set of action from going foward if a certain condition is met, if its at the very end of a list of actions it will still display a warning if its conditon is met but it will still run all previous actions.

-MIchael

Re: Question About Exporting A Grid to Excel with Hidden Columns

BungalowMatt — Fri, 22 Jul 2011 15:21:01 GMT

The three columns in question are the right most three, and each has the check box "Hidden on Screen Load" checked in the advanced settings in the grid wizard.

I am using the Export Grid to Excel function, but within a loop & conditional statement so that if there is an issue with the data (namely, an attempt to export information for an unpaid invoice without terms) the user gets a warning. My guess is that my problem is somewhere in here.

I have attached the properties screen for the button that excutes the export below. (eek, let me know if its too big and i can try to resize)

Re: Question About Exporting A Grid to Excel with Hidden Columns

Method_Michael — Fri, 22 Jul 2011 14:55:45 GMT

HI Matt,

Are you using the Export to Excel action? I just tried this and any field that was not display on the grid at the time of running the action did not get exported. Can you give me some additonal details of the setup?

-Michael

Question About Exporting A Grid to Excel with Hidden Columns

BungalowMatt — Fri, 22 Jul 2011 14:32:04 GMT

Hello all,

I have built a grid to export data from the invoice table, and in order to have this grid link up to another grid I am working on, I have 3 columns (Full Name, RecordID, Customer_RecordID) which are in the grid, but are hidden.

When I export them, the hidden columns are included in the generated file.

I searched around in the grid wizard, but am unable to figure out how to exclude these columns from the export.

Is there something I am missing?

Thanks in advance for any help!

-Matt