we have a problem regarding cell formats. Our customer has a report that displays different data within a table. Everything works fine if data is available. But if no data is available, i.e. there have been no goods produced on a specfifc day, the cell format is lost. That means the borders of the table are missing. Is there a way to keep the cell format even if there is no data to display?
Ok, thank you. I have sent you an E-Mail.
that is exactly what we need. Thank you for the fast solution. I have sent you an E-Mail.
I also have another question not completely regarding cell formats but empty data. Is it (or will it be) possible to still process the FlexCel tags(functions) that are inside the cells?
For example if no data is available, there should be another text displayed: <#if(<#Query1.ROWCOUNT>=0;No Data;<#Query1.Text>)>.
At the moment these tags aren't processed and you wrote that with the new version the FlexCel tags will be removed with the option FlexCelReport.DeleteEmptyBands = TDeleteEmptyBands.ClearDataOnly set. But for this specific example it would be great if the "if" tag would still be processed so the specific text would be displayed.
|Table Name||Source Name||Filter|
thanks for the fast solution. But I have 1 report with a Master-Detail-Relationship where the cell format is not preserved when the master has no detail. I will send you an E-Mail with the template and report so you can take a look on it.
I've sent you a new link bye email which should fix this.
everything works now as expected. Thank you for your fast help!!