I too wish that the Excel option worked consistently, but I understand why it can't with Excel needing to interpret fonts, white space, etc. At this point, when I upgrade a client to 7.6/9.1 and I show them all the cool things they can from the print screen, I show them the Excel option but tell them that they can try to use it but to carefully compare to the print output to see if all the data is shown, and that some reports will work better than others. But I do show them the DIF option and my clients have been using that. Kills me... If I know that a user will want the option of exporting to Excel, I give them the option to choose up front which they want to do, print to the screen or Excel output. Then I'll use a temp table to dump all the data into (including lookups that would have been performed inside the report). At some clients they want me to output to the Excel file; other more sophisticated clients prefer me to instead put up a table browser, and they know how to export to Excel from there. Gives them more flexibility.
Karen In a message dated 11/27/2011 11:18:40 PM Central Standard Time, [email protected] writes: > I tried the DIF option and that seems to work better. I saved the > resulting file as .xls so it is OK for now. I actually saw a nicely formatted > example in Razzak's sample application. Tried to use similar code but could > not > get it to work at all. Wish I could get it to work like his. It is > magical. > Robert >
