wow it works when I drop it in the footer
is there any way to show it that total anywhere else in the report?
THANKS
THAT is Awesome
Thank you very much for your help
orb353
I tried it and the repeat returns a value of 1 every time .
new returns 0 every time.
It should work but i cannot get it to.Any suggestions as to what I may be doing wrong.
the directions LB gave me seem to me to say in english
running total(distinctcount) of {table.clientid) where...
that does not really give me the info i need.
The nearest i come to getting the right info was creating the formula
if{transhead.iapptype}=2 then 1 else 0
then i create a summary-count of that formula.
this returns the total number of transactions that =2, but but each client may have several...
I have created a report pulling from a dataset.The report is based on transactions coming through the dataset from a fox pro database. These are some of the fields i am showing in my report.
Transactions Clientid headerid appttype
10028 5001 1007 2
10029...
I have created a report pulling from a dataset.The report is based on transactions coming through the dataset from a fox pro database. These are some of the fields i am showing in my report.
Transactions Clientid headerid appttype
10028 5001 1007 2
10029...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.