In the crystal report go to file menu on the top--> insert--> summary--> choose a field to summarized, in calculate, change to count or district count from dropdown list and insert that into header or footer of your report or where ever you want it.
Thanks! this gets me going and this works partially. your assumption is correct the date is empty, sometimes the clinicians don't input it as they are suppose to. This code gives me everything like last years too but I want to get the date range between "from" to "to" only, including the admit...
Thanks Kray, Yes I missed the range [1.4] Can you modify my formula and sent it back to me? I am not sure how to modify this? I think my format is an old format date that turns string to actual date 4/8/2014 like you said .
Another word what the best way to minimize this code /shorten it?
Thanks!
HI All,
I keep getting errors with below formula: All I want to say is give me the date range inputed including date range for form/to that are null.
Any help is appreciated!
I have to change the date into string because the date is in sting.
(
isnull...
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.