Free Support Forum - aspose.com

Conditional formatting in SSRS

Is it possible to do conditional formatting is Reporting Services. I've tried adding conditional formatting to the Excel template but that did not work.
This message was posted using Aspose.Live 2 Forum

Hi,

We will support it soon.

Thank you.

Hi berlblack,

Please try this fix.

Hi,

I loaded the new version on the client and server but was not able to get conditional formatting to work.

Is there something other than setting up conditional formatting in the template that needs to be done?

Thanks,
Berl

Hi berl,

Please look attachment.

It is a conditional formatting example.

The xls file(Employee Sales Summary.rdl_exported.xls) is exported data file.

Aspose.Cells.ReportingServices.Client configured conditional formatting the same as Excel.

But Aspose.Cells.ReportingServices only support that cell value is fixed value.

If the cell value need to reference cell ,the cell must fixed cell.

--------------------------------------------User Action----------------------------------

  • Open Employee Sales Summary.rdl by Aspose.Cells.ReportingServices.Client
  • Choose the M29 cell
  • Click the conditional formatting menu
  • Look configured info
  • Open Employee Sales Summary.rdl_exported.xls
  • Look exported result

--------------------------------------------------------------------------------------------

If the problem persists , Please post your report here.

Thank you.

Hi,

Please see attached screenshot. Should this work?

Thanks,
Berl

hi,Berl

There are some limitations to use conditional formating in Excel template.
The value of each element in condition expression have to be a const value in most case, for example 100,200. Refering to the value of cells is supported only when the conditional formating is applied to the first table in the template and the cell refered by conditional expression is followed by the table.

Thank you.