Page 1 of 1

Condtional Group footer field based number of records

Posted: Wed Jun 25, 2025 4:18 pm
by Doron
Hi Guys,

Under a group footer band I have sub total which could be multiple records or 1.
If I have 1 record I need to disable the field against the sub total that says: Sub total for PO: 12345
Show that field if number of records > 1

I need to find out the number of records per group.
How that can be done?

Thanks,

Doron

Re: Condtional Group footer field based number of records

Posted: Wed Jun 25, 2025 10:19 pm
by Lech Kulikowski
Hello,

You can set the Enabled property with the following expression:
Count(GroupHeaderBand1) != 1

Thank you.

Re: Condtional Group footer field based number of records

Posted: Wed Jun 25, 2025 10:36 pm
by Doron
Thanks Lech

Re: Condtional Group footer field based number of records

Posted: Thu Jun 26, 2025 9:20 am
by Lech Kulikowski
Hello,

You are welcome.

Re: Condtional Group footer field based number of records

Posted: Thu Jun 26, 2025 11:04 pm
by Doron
Hi Lech,

Another thing I need to clarify in this regards.
How do I remove the gap for the sub total when there is only 1 record in the group?

Thanks,

Doron

Re: Condtional Group footer field based number of records

Posted: Fri Jun 27, 2025 7:35 am
by Lech Kulikowski
Hello,

Without a report template, it isn't easy to say.

Thank you.

Re: Condtional Group footer field based number of records

Posted: Fri Jun 27, 2025 1:45 pm
by Doron
Hello,

Maybe you can improve upon that.

For instant in another report engine i could cover that area with a conditional object.
Which I can enter some conditions. It was cumbersome but did the job.

I am not using for now a template.

Thanks,

Doron

Re: Condtional Group footer field based number of records

Posted: Fri Jun 27, 2025 9:55 pm
by Lech Kulikowski
Hello,

Depending on the structure, you can use the CanShrink property or the Enabled property for the Panel component.

Thank you.