Conditional Formatting on Grouped Data

[bhodgson]

Hi,

I am trying to apply conditional formatting to data in a GroupFooterBand, but the conditions appear to be looking at all the data, rather than the grouping. I've attached some screenshots to aid my explanation (my organization doesn't want me to provide the report as its sensitive).

On the screenshot, the top left section shows the preview of the report. The bottom screenshot shows the designer view and the top right screenshot shows the conditional formatting applied to the text boxes in GroupFooterBand1.

To explain the report GroupHeaderBandData, DataBandFields and GroupFooterDataBand have no content. GroupHeader1 is grouped by a date field (date only, not date and time), GroupHeaderBand3 is used to pair up with GroupFooter2 - groupFooter2 is used to display every hour of the day. GroupFooter1 counts a total for every hour - this can be seen by the light green numbers below each set of dark green bars on the preview. Please note the light green is part of the condition which I believe is working incorrectly which i'll get to later.

The data stored in the DataEMR databand will store a number between 0 and 1. The dark green bars are conditions which formats each text box to be dark green if the data equals a 1. The GroupFooterBand1 totals the figures for each day. I can see that the figures from GroupFooter1 are accurate within their grouping - so looking at the first column which is labeled 00:00 using GroupFooterBand2 I can see that on the first grouping visible of the preview screenshot there is a total of 0, on the second which is for the date 03/12/2015 there is a total of 1 and for the 04/12/2015 there is a total of 1.

The conditional formatting applied to the GroupFooter1 text boxes is in the screenshot to the right of the attachment, which should only highlight the total if it is 2 or greater. As can be seen by the preview screenshot, 1's and 0's are also being highlighted. When we consider the first column for 00:00, none of these meet this condition. However when the figures for each groups totals 0 + 1 + 1 are totalled they equal 2, which does meet the condition and I believe this is why they are being highlighted. When I changed the condition from >=2 to >=4 the condition wasn't met and the cell was no longer formatted green. This means in GroupFooter1, the data displayed is accurate as per the grouping in GroupHeaderBand1 - the date, but the conditional formatting is ignoring this grouping!

Can you tell me why the conditional formatting is ignoring the grouping please, and how I can get around this?

[PLEASE NOTE: I'm having trouble posting this topic so I have removed the attachment and will attempt to upload later]

Thanks,

Ben

[bhodgson]

Unfortunately I can't seem to upload the attachment - I've tried a .jpg (540kb) and also a word document but neither would upload. I tried in IE and Chrome browsers - I'm not sure what I can do to provide it now?

[Andrew]

Hello,

In order to add the file you should click the Upload attachment tab -> click the Browse button and select one file -> then click the Add the file button.
If you want to upload one more file then you should do to the Upload attachement tab and repeat the steps described above.

Waiting for your reply whether you are able to upload the files.

Thank you.

[bhodgson]

Hi Andrew,
Whenever I click on Add File I get the "This page can't be displayed" message.
Regards,
Ben

[HighAley]

Hello.

Please, try to use any file sharing service.
Or you could send your files with your question to support@stimulsoft.com.

Thank you.

[bhodgson]

I've emailed the attachment to the email address provided. Thanks, Ben.

[HighAley]

Hello.

We have received your letter and will answer you by email.

Thank you.

[nnqphong]

I'm having trouble too. How to highlight Group Header Band 4 with expression below
Sum(GroupHeaderBand4,PR_JFV_Dashboard_Monthly_NSM.TotalActual) > 3
Thanks in advance.
Phong

[HighAley]

Hello, Phong.

Did you try to write this expression in the Conditions expression?
If yes, please, send us your report template with sample data that will help us to reproduce the issue.

Thank you.

[nnqphong]

Hello.
Please see attached file.
P.S. Highlight condition in Group Header Band 1: {Sum(DataBand1,pr_OM_SalesReport.LineQty)}>190000
Thanks