TM1 Forum

Hi

I'm trying to figure out how you can set a print area to print an active form from the web...if it is at all possible.

I can print classic slices fine as I can set the print area within Excel before uploading to the server, but am at a loss on setting it for an active form. I have tried setting it on the active form format area & also on the actual report area so it would include additional information we would like to view on the report that is outside of the format area. Setting the print area on the actual report area works fine initially, but as soon as the report is rebuilt, it then only includes the TM1RPTRow row & not any data below that.

I have also worked out that I can create the report as required within TM1web, then export a snapshot to Excel, then set my print area & print, but we would like to be able to print to PDF from the web for data integrity.

Many thanks

You just need to set the print area to be at least 1 row below the end of the report data range. Then as the data range is destroyed and rebuilt the print area will still include all report data (there's nothing you can really do to control page breaks though).

As a best practice when publishing to web all the data range except the first row where the rptrow formulas are should be deleted prior to saving as an application object.

Great thanks for your help.