Hi Sytze, Very cool indeed! Yes, I did run into that problem where the Excel export said it completed and yet it appeared to do nothing. The problem as I found it is that the export method does not allow overwriting existing files even though it prompts you about replacing. (Actually it does do something. It adds blank rows into the file that you selected. So if you're picking an existing file with nothing in it, you just get more nothing...) I haven't had a chance yet to figure out a proper workaround. I also found another minor issue if you use the preview report option in that it only deletes half of the temporary report that it creates. For the latter, here's my fix. At approximately line 242 of the CopyToReport method, I changed this line:
ERASE (m.tcFRXName) to this: ERASE ADDBS(JUSTPATH(m.tcFRXName))+JUSTSTEM(m.tcFRXName)+[.fr?] Finally, I've made some changes in the applysort and getsortexpression methods. I added the COMPACT keyword to the INDEX ON statement in the former and I increased the expression length as appropriate in the latter. (If your controlsource is longer than 99 characters, the index creation will fail using a standard IDX. This one also fails silently in that it does not notify you of any problem and the header indicates that you are changing the order when there is actually no tag to go with that column. It's wrapped in a try..catch so I changed that to throw the exception object up the chain which allows it to set the header image to the no sort available instead of the arrows.) I've reported all this stuff to Craig and at least in one instance, he indicated that he would integrate my changes into the next update he does. But that's one busy guy so who knows when that will be. (If you're lurking, Craig, thanks again for all your efforts...) There are 7 properties that all start with "allow". To turn off the various options, just change those as desired. rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sytze de Boer Sent: Thursday, August 06, 2009 3:23 PM To: [email protected] Subject: Re: GridExtras fun Hi Richard Your post prompted me to try this class It is so cool. One problem I hav ewith it is that I can't get the Copy to Excel to work It brings up an empty Excel worksheet no matter what I try Do you have this working ? Also, how do you disable the template function in bottom right corner ? Sytze _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/df1eef11e586a64fb54a97f22a8bd044065519e...@ackbwddqh1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
