Karen,
If this is going to be an EXCEL workbook, what about the first sheet being formatted exactly how they want the report to look, then having the information from RBASE going to the other sheet(s)? Another possibility is to have the Excel workbook connected to a specific table in RBASE that can be updated whenever they want with an EEP. After updating the RBASE info, they simply open the Excel workbook, click the update button and the information is updated. The first sheet stays formatted and only the cells in the other sheet(s) are changed. I use this concept for an excel workbook used here. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, March 09, 2010 9:20 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Reports to Excel 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
