Dynamic Footer data for invoice report not displaying correct in WORD

  • Hey All,

    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

  • marty.seed - Thursday, July 6, 2017 8:48 AM

    Hey All,

    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

    Any way to simplify the expressions your using in the header, footer? That's typically what can cause that type of behavior. The section on Exporting to Microsoft Word states:

    However, when a page footer or page header contains a complex expression that evaluates to different values on different pages of a report, the same value might display on all report pages.

    You may want to check that document:
    Exporting to Microsoft Word (Report Builder and SSRS)

    Sue

  • This problem has to do with Word, and I'm pretty sure it's NOT solvable.   Word can only have one header or footer, and NOT any kind of dynamic one save the built-in things like page number and that kind of stuff.   There's just no way for it to be possible to work as an actual Word footer.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply