SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Dynamic Footer data for invoice report not displaying correct in WORD


Dynamic Footer data for invoice report not displaying correct in WORD

Author
Message
marty.seed
marty.seed
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1417 Visits: 216
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
Attachments
Sue_H
Sue_H
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41687 Visits: 11549
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



sgmunson
sgmunson
SSC Guru
SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)

Group: General Forum Members
Points: 53992 Visits: 5884
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.

Steve
‌(aka sgmunson)
Smile Smile Smile
Health & Nutrition
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search