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.