I'm trying to do some custom formatting when exporting to PDF and to Excel and have run int o a couple of issues. I wasn't sure if I should put them both into one post, so I apologize ahead of time!
One fof trhe first things I would like to do is to create a second PDF export option that exports the report in landscape on legal (8 1/2 x 14) paper. One of the reports is quite wide and it looks terrible when printing on multiple sheets. In addition to
printing on legal, I'd like to accomplish the following:
- Set a default font and size when exporting to PDF
- Set a default column width on the columns
- Provide a file name based on certain variables in the report
- Repeat column headers on each page
The other issue is with formatting an Excel export. I've found a couple of articles on how to do this, but I get stuck on a couple of things. The article I found said I should export the report, perform the manual formatting of the workbook, and then save
the workbook as "something I can't remember", and then go through and manually adjust the RDL. Once that's done, I need to place that xml(?) in a certain directory?
I know that's not making the most sense, but if that rings a bell with anyone, I would truly appreciate any help!
Lastly, how can I set it up so that the Excel filename is actually the valu
View Complete Post