June 12, 2008, 10:47 AM
Jason K.Sending Excel 2k from reportcaster with print formatting?
I would like a report that we send out (as bursted) through reportcaster to contain print setup information, such as fit to page and small margins.
Is this possible? We tried templates, but the "fit to 1 page" options don't come across in the webfocus output.
June 13, 2008, 09:36 AM
jgelonaUse a template. In excel (must be 2002 or higher), create a worksheet with all the properties you want and save it as a .mht file. Copy/ftp the file to the Reporting Server and place in folder that is in the application path, we use baseapp. Use that for the Excel output. For example, in the following ssi_rollingqtr refers to ssi_rollingqtr.mht.
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE 'ssi_rollingqtr' SHEETNUMBER 1