SSRS report - problem with Word renderer

mark goldin 691

I am using Globals!RenderFormat.Name = "WORD" in the report footer. Seems like export to Word ignores it. Can you confirm that this is just another bug?

Thanks

1 answer

ZoeHui-MSFT 39,671 Reputation points

2021-10-05T02:15:30.813+00:00
Hi @mark goldin ,

Try with below in the visibility expression.

=IIf(Globals!RenderFormat.Name Like "WORD*", True, False)

It works from my side.

Regards，

Zoe

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October
Please sign in to rate this answer.
mark goldin 691 Reputation points

2021-10-05T09:15:00.92+00:00

I will try that. Also, any idea why Globals!PageName is not working in the footer? The value of that variable is not evaluated for every footer.

ZoeHui-MSFT 39,671 Reputation points

2021-10-06T01:23:05.62+00:00

Hi @mark goldin , I suppose this will be related with the version of Word. For Excel 2012, we need to use IIF(Globals!RenderFormat.Name = "EXCELOPENXML",true,false) instead of IIF(Globals!RenderFormat.Name = "EXCEL",true,false) which may be same as this situation.

mark goldin 691 Reputation points

2021-10-06T04:29:55.69+00:00

But I was asking about PageName not working correctly in the footer.

ZoeHui-MSFT 39,671 Reputation points

2021-10-06T06:41:45.747+00:00

Hi @mark goldin , misread your question. So how did you set the expression of the PageName?

mark goldin 691 Reputation points

2021-10-06T07:01:36.997+00:00

Something like this:
Switch(Globals!PageName = "xyz", "message 1", Globals!PageName = "abc", "message 2")
So while rendering PageName is changing and I get different text shown in the footer. However, exporting into Word is not doing that. It works as it would have if the Globals!PageName wouldn't change, another words, "message 1" is shown on all footers.

ZoeHui-MSFT 39,671 Reputation points

2021-10-06T09:12:40.427+00:00

Hi @mark goldin , I test locally that it seems the PageName works well in Excel and PowerPoint but not in Word. Suppose that there is some limitations when exporting to WORD.

As said here,only mentioned Naming Excel Worksheet Tabs, use the InitialPage property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the PageName property to provide different names for each worksheet. Each new report page, defined by a page break, is exported to a different worksheet named by the value of the PageName property.

mark goldin 691 Reputation points

2021-10-06T13:11:19.637+00:00

Dont need to make it work in Excel. Word is the only problem.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SSRS report - problem with Word renderer

1 answer

Your answer