I don't have any 7.6 reports in production that print to an Excel file because "in the beginning" it was difficult to design a report that looked good to the screen but also could be outputted to an Excel file. And an Excel-only report had to have fixed fonts and plenty of white space.
So now I have a client asking, and we would be able to design an Excel-only report. We are now creating a .csv file, writing column headers to it and unloading data as ascii. However, the user has to bring up the .csv file, change fonts, apply font attributes, resave as Excel. So since I haven't visited this topic in a while, could I design a report that would always be outputted to an Excel file, have headers in a different font, bolded, larger size, white space between headers and data, data wouldn't be dropped and could be in a proportional font, etc. I'm trying to output to an Excel file that would look good and have the users not do anything to pretty it up. They run this routine once a month on 100 different factory listings! Cannot use a PDF file because the factories add columns of data to the spreadsheets and return back to the company. Thanks! Karen
