Page 1 of 2

How can I count registers from a Data Source?

Posted: Thu Aug 27, 2020 2:04 pm
by Mateus Garrido Kern
Hello,

I did a report with count registers, but de function not working.

I used:

Code: Select all

{Totals.Count(root_retorno_livros.lancamentos)}
How can I count the registers from my Data Source?

In the attachments I show how my data structure is and how I am using the count

Re: How can I count registers from a Data Source?

Posted: Thu Aug 27, 2020 2:07 pm
by Lech Kulikowski
Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

Re: How can I count registers from a Data Source?

Posted: Thu Aug 27, 2020 2:13 pm
by Mateus Garrido Kern
Basically I want to show the databand when there is no record, and when there is more than one record do not show the databand.

Re: How can I count registers from a Data Source?

Posted: Thu Aug 27, 2020 2:15 pm
by Mateus Garrido Kern
Follow the example of the report in attachment.

Thank you.

Re: How can I count registers from a Data Source?

Posted: Tue Sep 01, 2020 9:16 am
by Lech Kulikowski
Hello,

Sorry for the delay with the response.
Please send us a test data for your report.

Thank you.

Re: How can I count registers from a Data Source?

Posted: Wed Sep 02, 2020 12:00 pm
by Mateus Garrido Kern
Hello,

Follow my test data for report.

Thank you

Re: How can I count registers from a Data Source?

Posted: Thu Sep 03, 2020 9:59 am
by Lech Kulikowski
Hello,

Please check
SEM MOVIMENTO - {Totals.Count(root_retorno_livros)}

Thank you.

Re: How can I count registers from a Data Source?

Posted: Thu Sep 03, 2020 1:58 pm
by Mateus Garrido Kern
Hello,

I tested the Totals.Count function in a conditions in my DataBand but it seems not worked fine.

I want the DataBand3 from Page 1(Second page in order) from my report appears when dosen't has registers of root_retorno_livros_lancamentos.

I am working with the 'Conditions' property because of the topic viewtopic.php?f=27&t=57943&p=155143

Follow my report, test data and 3 images explaining in attachments.

Thank you.

Re: How can I count registers from a Data Source?

Posted: Sun Sep 06, 2020 6:40 pm
by Lech Kulikowski
Hello,

In that case, please check the following expression
{Totals.Count(DataBand2)}

Thank you.

Re: How can I count registers from a Data Source?

Posted: Wed Sep 09, 2020 7:10 pm
by Mateus Garrido Kern
Hello,

Thank you, it's worked very well.