I have set up a Report Builder report with 4 tabs, Daily, Weekly, Monthly and Quarterly looks at several pieces of data. I formatted the columns in Excel and I'm sending several users PDFs. As each day is added to the Daily tab, the number formats aren't coming through in the PDF, though if I refresh the Excel version, the formatting is there. For example, a conversion rate formatted in Excel as 32.56% is coming through as 0.3256 on the pdf. How do I get the newly added days to have the correct number formats in the PDF delivered report?
I've had several issues with formatting scheduled reports. A lot of time they end up formatted like date ranges in undesirable places. Going into the cell properties, manually updating the format to what I want, and rescheduling the workbook typically resolves it for me.