I have a problem with cell formats in a report that uses Master-Detail relationships. I configured the cells that contains the placeholders to have a border. I also configured some custom formats on the config sheet to apply conditional formatting. Everything works well if the placeholder has some data for the specific cell. But if there is no data for this placeholder (for example there was a NULL value in the database), the cell in the report is empty (which is the proper and expected behaviour), but no cell format has been applied. I am using a table based layout, so for example the borders for specific cells are not applied and the report looks ugly. Is there any possibility to apply or keep the cell format if the detail query has no value for a specific cell?
Thanks in advance
I have sent you an E-Mail with an attached image that illustrates the problem.
Do you already have further information? This issue becomes urgent because we need to find a solution for our customer.
after some investigations I discovered that we don't use null values. We just remove the DataRow from the DataTable if we have no detail data. So this behaviour is not FlexCel related. Sorry for bothering you.