CountIf not working across pages
-
- Posts: 31
- Joined: Thu May 30, 2019 1:01 pm
CountIf not working across pages
Hi,
I need help with what was supposed to be something straightforward. I have 3 different pages with CrossDataBands and at the end of each one, I have a CrossFooterBand that counts the totals of certain information.
I'm using the following expressions:
Page1
{CountIf(CrossDataBand4,InfoAlumnoIncidenciasBr.Ausencia == true)}
Page2
{CountIf(CrossDataBand4,InfoAlumnoIncidenciasBr.Ausencia == true)+CountIf(CrossDataBand2,InfoAlumnoIncidenciasBr.Ausencia == true)}
Page3
{CountIf(CrossDataBand4,InfoAlumnoIncidenciasBr.Ausencia == true)+CountIf(CrossDataBand2,InfoAlumnoIncidenciasBr.Ausencia == true)+CountIf(CrossDataBand6,InfoAlumnoIncidenciasBr.Ausencia == true)}
On the first page, it works flawlessly but on the second e third pages the totals come up completely wrong.
Could you please help me?
I need help with what was supposed to be something straightforward. I have 3 different pages with CrossDataBands and at the end of each one, I have a CrossFooterBand that counts the totals of certain information.
I'm using the following expressions:
Page1
{CountIf(CrossDataBand4,InfoAlumnoIncidenciasBr.Ausencia == true)}
Page2
{CountIf(CrossDataBand4,InfoAlumnoIncidenciasBr.Ausencia == true)+CountIf(CrossDataBand2,InfoAlumnoIncidenciasBr.Ausencia == true)}
Page3
{CountIf(CrossDataBand4,InfoAlumnoIncidenciasBr.Ausencia == true)+CountIf(CrossDataBand2,InfoAlumnoIncidenciasBr.Ausencia == true)+CountIf(CrossDataBand6,InfoAlumnoIncidenciasBr.Ausencia == true)}
On the first page, it works flawlessly but on the second e third pages the totals come up completely wrong.
Could you please help me?
Last edited by rafael.custodio on Fri Jun 24, 2022 6:34 pm, edited 1 time in total.
-
- Posts: 31
- Joined: Thu May 30, 2019 1:01 pm
Re: CountIf not working across pages
could anyone please help??
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: CountIf not working across pages
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
-
- Posts: 31
- Joined: Thu May 30, 2019 1:01 pm
Re: CountIf not working across pages
@Lech Kulikowski, any news about the issue?
-
- Posts: 31
- Joined: Thu May 30, 2019 1:01 pm
Re: CountIf not working across pages
@Lech Kulikowski, I'm still waiting for an answer, do you have an estimation for a solution?Lech Kulikowski wrote: ↑Mon Jun 27, 2022 8:50 am Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: CountIf not working across pages
Hello,
It is difficult to understand your report logic. But on the 2 and 3 pages, you use CountIf with CrossDataBand4 that placed on the Page1, it will not work.
Thank you.
It is difficult to understand your report logic. But on the 2 and 3 pages, you use CountIf with CrossDataBand4 that placed on the Page1, it will not work.
Thank you.
-
- Posts: 31
- Joined: Thu May 30, 2019 1:01 pm
Re: CountIf not working across pages
Hi @Lech Kulikowski, thanks for replying.Lech Kulikowski wrote: ↑Tue Jul 05, 2022 7:38 am Hello,
It is difficult to understand your report logic. But on the 2 and 3 pages, you use CountIf with CrossDataBand4 that placed on the Page1, it will not work.
Thank you.
The logic behind the report is to use it as means to check class attendance, that's why I need to sum up the total of certain fields at the end of each page.
So, what would be the alternative to accomplish what a need?? I tried to store the information on variables but it doesn't work as well.
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: CountIf not working across pages
Hello,
> The logic behind the report is to use it as means to check class attendance, ...
In that case, you can place that data source as an empty band on each page, and make calculations by that band for each page.
Thank you.
> The logic behind the report is to use it as means to check class attendance, ...
In that case, you can place that data source as an empty band on each page, and make calculations by that band for each page.
Thank you.