Search results for query: *

Hi. I just love this site...! [bigsmile] What I don't love is our IT department who decided that the databases I use to extract some statistics no longer need to have the same data form in the only two fields (one from each DB) I use to define my reports. I work as a system admin on a hospital...

Hi. I just love this site...! What I don't love is our IT department who decided that the databases I use to extract some statistics no longer need to have the same data form in the only two fields (one from each DB) I use to define my reports. I work as a system admin on a hospital and the two...

Hi. I'm trying to make a report 'look nicer' by suppressing irrelevant rows. I made a formula field (@Status): if {VWALLNEW.STTEXT} startswith "Udeb" then "Udebl." else "Anden status" I then want the report to suppress the rows where @Status is not "Udebl." How do I do that?

Hi. In several reports I have had the need for a 'contains' expression in a formula in Crystal Reports 11. So far I haven't found it. Is it possible? If I have e.g. {VWALLNEW.RESCODE} can be UXZ01, UXZ10, UXZ20, UXC01, UXC10, UXC20 etc. and it can be in any order in a string. If I want all...

Hi. I'm sitting with a report where I have to determine the number of certain events happening less than 48 hours from the execution of an exam (we're in an x-ray department). The 2 fields that should be subtracted are: {MAP_EVENT_AUDIT.DATE_TIME_CREATED} in the format x seconds since 01-01-1970...

Hi. I'm doing this report in CRXI that should show exams with a certain procedure code ({VWDEPSTAT.RESCODE}="UXRD45") but I only want the exams that has got only that exact procedure code (as in DistinctCount ({VWDEPSTAT.RESCODE} = 1). How can I do that? When I try to CR informs me that 'the...

Hi. I'm trying to create a report that shows the time certain patients have to wait for an examination. I tried to use: local numbervar T; global timevar F; global timevar D; if {RISLOG.LTRANS} = 'Ny status: Besk.afs' then D := time ({RISLOG.LDATETIME}); if {RISLOG.LTRANS} = 'Dokumentation'...

Hi. I found a formula in another thread about this: stringvar x := {yourdbfield}; stringvar z; numbervar y; for y := 1 to len(x) do if isnumeric(x[y]) or x[y] = "." then z := z + x[y] else z; tonumber(z) HOWEVER when I use it it seems that my resulting numbers are multiplied all the way down...

Hi. I'm working on a report that uses a DB with a time field (called {MAP_JOB.DATE_TIME_CREATED}) that is actually the number of seconds past january 1st 1972 i think. How do i extract that into an understandable date/time format? I asked in an SQL forum and got an answer. Unfortunately I'm not...

I'm working on a report in Crystal Report XI that uses a DB (Oracle 10g based) with a time field (called {MAP_JOB.DATE_TIME_CREATED}) that is actually the number of seconds past january 1st 1972 i think. How do i extract that into an understandable date/time format? Best regards Mads Stiig...

I'm working on a report that uses a DB with a time field (called {MAP_JOB.DATE_TIME_CREATED}) that is actually the number of seconds past january 1st 1972 i think. How do i extract that into an understandable date/time format? Best regards Mads Stiig Nielsen, Denmark.

Hi... I would like to make a report that lists up patients who has been to one specific exam AND on the same day to a totally different specific exam. The patient-ID for different exams is in our country ALWAYS unique for each patient; the patient-ID will always be a specific constant for a...

Hi. I'm having a problem getting a report to show for which month the data in the report are in the header (yes, english is not my best...). E.g. "the data in this report are from [March, 2010]". The database uses 'DD-MM-YYYY' as dateformat. Best regards, Mads - Copenhagen, Denmark.

Hi. I'm trying to make a report on patients who have been involved in accidents and therefore have been examined in the ER. I want to have only patients who have been CAT scanned AND have had an x-ray of their thorax in my report. If only 1 procedure has been executed the patient should not be...

Hi. I guess there is a simple solution to this - I just never used this function before. I'm doing a report with quite a lot of entries in the detail section and I wish to separate them from each other. Hence I need a way to put a background on every other (or every 3rd) line in the detail...

Hi. I'm working on a report (Crystal Reports XI)that uses a DB with a time field (called DOSR_STUDY.STUDY_TIME) that is actually a string (e.g. 101904.812000 is 10:19 a.m. and some seconds and milliseconds). How do i extract that into an understandable time format like just 10:19?

Hi. I'm working on a report that uses a DB with a time field (called DOSR_STUDY.STUDY_TIME) that is actually a string (e.g. 101904.812000 is 10:19 a.m. and some seconds and milliseconds). How do i extract that into an understandable time format like just 10:19?

I am trying to get the time diff from two fields. I tried{field1}-{field2} but the time difference it gives me is not the proper calculation (of course...) can someone help me??? I'd greatly appreciate it. example: startime: endtime: difftime: 715pm 745pm 00:30:00 The time fields...