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.