Forum Discussion

wellf100's avatar
wellf100
Icon for Helper I rankHelper I
4 years ago

Sub Total formatting in cross tabs not retained on Report Server

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,

 

Report Server
sub totals

3 Replies

  • wellf100's avatar
    wellf100
    Icon for Helper I rankHelper I
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

     

    • wellf100's avatar
      wellf100
      Icon for Helper I rankHelper I
      4 years ago

      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.