Hi,
I have been using excel 2003 with crystal 11 and now we have excel 2007. When I try to use data from excel 2007 in crystal I am getting a message 'Failed to load database information'. Not sure why? Any help will be appreciated.
Thanks
RM
Hi
I am trying to count only the first visit on a report. If a patient has a first visit in April and a second visit in February, this patient should be counted only once and that should be in April, which will be the first visit. The visit in February should not be counted. The report needs...
Hello,
Is there a formula or a field to run a crystal report by census days.
For example if an admission is from April 1 to April 5. This case should appear in the census reports for April 1, 2, 3, 4 & 5.
The census day should be the runtime parameter.
Thank you.
Hello,
I would like a formula to extract the following information
1.admission April 1 discharge April 14
2.admission April 14 discharge April 25
The formula should excluded the cases when 1. discharge date = 2. admission date.
Thanks
Hello
Can I get a formula to get the following data
Date 1, time 1 = Date 2, time 2
I am trying to extract reports which have admission date & time equal to previous discharge date & time.
I know the formula to make the dates equal, but not one for equal date & time.
Thanks
Hello
I am trying to sort the averages in a column (column C) in descending order. These values are calculated fields in the report. I use Crystal 11. Below is the report.
A B C (=A-B)
27.00 8.19 18.81
23.00 5.76 17.24
15.50 6.98 8.53
20.00 8.10 11.90
15.00 4.95 10.05...
Hello
I am trying to add time in a column. Sum and Running totals are not working. I use Crystal 11.
start end timediff
time time
7:07 7:19 0:12
7:07 7:23 0:16
7:19 7:29 0:09
7:23 7:54 0:31
7:29 8:16 0:47
7:54 8:28 0:34
8:16 9:03 0:46
8:28 9:12 0:43
9:03 9:23 0:20
total timediff?
Thank you
Hello
I would like some helps getting a formula to substract in a column.
I have column a and need the answers as in column b. I have shown the calculation on column c. This is in Cryst 11.
Thank you
a b c
1 10
2 5 -10 a2-a1
3 15 10 a3-a2
4 16 1 a4-a3
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.