topic Re: Sub Total formatting in cross tabs not retained on Report Server in Report Server

Sub Total formatting in cross tabs not retained on Report Server

wellf100 — Tue, 13 Sep 2022 11:29:36 GMT

Hi, some sub total formating that i apply in Desktop (May 2022 RS version) on cross tab tables is not being retained after loading to the server (May 2022 Report Server). In particular if i set the table 'Style' to 'None' and then apply sub total formatting it's not being retained. (I am setting the initial format style to 'None' as i want to start with a transparent table).

Example crosstab:

How it looks on Desktop:

How it looks after loading to Report Server:

You can see that any formatting i apply to the Sub total columns is lost. i.e. any background colour reverts to nothing and any text colour reverts to black.

Thanks,

Re: Sub Total formatting in cross tabs not retained on Report Server

wellf100 — Tue, 13 Sep 2022 12:06:26 GMT

in fact setting the table 'style' makes no difference. regardless of the style any formatting of sub totals is not retained.

Re: Sub Total formatting in cross tabs not retained on Report Server

Anonymous — Wed, 14 Sep 2022 01:12:39 GMT

Hi wellf100 ,

Just a quick check with you if your report has a custom theme applied in Desktop for Power BI Report Server? Does this issue occur after the custom theme is modified?

Also，you may check if this similar thread helps

Solved: Loosing Formatting after Publishing report to the ... - Microsoft Power BI Community

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Re: Sub Total formatting in cross tabs not retained on Report Server

wellf100 — Wed, 14 Sep 2022 07:52:21 GMT

Hi, i have tried creating a new blank report with no theme at all and the same happens.

I also cleared my browser cache and no difference.