Search results for query: *

Thank you Ian, I had the report grouped my meter and just had to had the group qualifier to the formula and it worked! datediff("d",minimum({COMPRD.READDTTM}, {COMPRD.COMPKEY}),Maximum({COMPRD.READDTTM}, {COMPRD.COMPKEY}))

I need to know how many days there are between meter reads. I could have upto 6 read dates in one year, but i need to know the days between the first read and the last read. My report is grouped by the water meter and in the details section i have the read date. I have tried...

Good morning all! Using Crystal 11 on SQL server 2005. I am receiving an 'Out of Memory' error when i run a report I have ran many times in the past. Any suggestions on what to look at? :)

Good morning LB~ Can you give me an example of the concatenate,variable and literal match? Thank you !

THANK YOU!!! lb

Thank you again LB!!! one more (I hope) what if i had a combination of Sewer, recycled and Landscape? Since i have a combination of Water/Sewer/Recycled and Water/Sewer/Landscape. How would i pull it?

LB r u there? I need to added more combinations... and i can't figure it out. Water, Sewer and Landscape Water, Recycled Water, Landscape Please help THANK YOU!

LB ROCKS!!!! I would have never figured this one out. THANK YOU [thumbsup]

Yes accounts should only fall into one of the combinations of services. Thanks again.

I spoke to soon. It is not distinctly counting accounts with Water and Sewerwa only. It's counting all accounts that have either..?

THANK YOU LB!!! I tried this, BUT i forgot to change the count to the acct number and not the service. duh!!! THANK YOU!!!!!

Hi all newbie here... I need to count accounts based on 5 different combinations of service types. My report is grouped on the account number and the services are listed in the details section. The service type is one db field and the combinations would be: WATER RECYCLED RAWATER...