I have created a pretty intricate report that a client uses for invoicing their customers. Think of it as your power bill. On the bottom of the page will always be the customers address and what is owed. This data comes from the body of the report. I have this working fine in report viewer and even when you download to PDF by referencing the txt properties from the body of the report i.e. Footer for address is calling =ReportItems!txtBillingAddress.Value.
Our issue is that when you run for multiple customers and download to WORD it pulls back the first customer data for ALL records.
Does anyone know of a work around for WORD? Client is pretty adamant that they need WORD and not PDF.
Thanks in advance for any insight.
I have attached a WORD copy and a PDF copy so you can see the issue