Publish Excel as attachment that looks like Copy Content
I need to know how to get a Published Excel report to look like it was created as if you used the Copy Content button and pasted it into Excel manually.
7 replies
-
Hi Greg Dobrzanski ,
these are two different functions which produce different results.Can you be more specific as to what it is you're looking for in the output?
-
This is how the report looks in the book and in the publication.
When published as excel attachment to client’s email they get this look and feel.
But they don’t want this look and feel.
They want Image B below.
The client wants the published attached email report (Image A) to look like Image B When they get the published email with the report attached, They can’t filter on Image A without doing a lot of manual altering of the report. -
Greg Dobrzanski ,
Actually, most clients requested that the output be exactly similar to their publication.
To solve your need, when you plan to export to Excel, use the Tabular Grid, or the Raw Results Grid.It will look like this:
-
Thanks, I will give that a try.
-
I don't see those option in BI Office...Can you tell me where these are in BI Office 6.48 ?
-
Greg Dobrzanski ,
Your question was posted under the Pyramid 2018 Q&A category.
I assumed you were using Pyramid 2018.
Unfortunately, BI Office does not contain these options. -
That was my fault - I was on wrong side of the Q&A board when I posted it.
Thanks for clearing that up for me.