Search results for query: *

That was a great idea, LBASS but alas I only have read-only access to the databases. Though you gave me an idea. Since I only need to get data from at a max one month's exams I could do a report with data from the images from that month containing the necessary fields, save this as an excel...

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...

Oh, of course. I just found a 'Start a new thread' button - didn't notice it was the wrong forum. Thanks :)

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. Thank you both for your response. @hilfy: yes I'm sorry I didn't mention but I need the counts on "Anden status" so your advice didn't help [wink] @kray4660: Worked like a charm - thank you [bigsmile]

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...

... oh and I forgot This is happening in Crystal Reports XI, btw - sorry ...

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...

Now I may understand it: I used group expert to group by {VWDEPSTAT.DID} (patient ID) and inserted this in the group selection: distinctcount({VWDEPSTAT.RESCODE},{VWDEPSTAT.DID})=1 and {VWDEPSTAT.RESCODE} = "UXRD45" ... but I still get exams with more than this single RESCODE. What am I missing...

That sounds fairly reasonable ... I just don't know what the groupfield is/should be. I have never worked with group selections... :-( Can you please specify? Or do you need more info on the DB or table? Regards...

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 guys. I've been fiddling a bit with this not being able to finish the report (luckily it's not all I do, hehe). I've found another obstacle: I need to subtract a DateTime field from a Time field. How do I do that. Can I make CR ignore the 'Date part' of the field or ... what to do here? Best...

No - sorry about that. I run CR 11

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'...

... the '-' doesn't count in the number by the way. In the system the number would be 0407670735 ...

The reason why I need to convert from string to number is that I need to anonymize some patients in a report and want to multiply the number by a constant (e.g. 0.4 to make the number smaller and immediately unrecognizable but still recognizable if needed). A social security number in Denmark...

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 trying to convert a string into a number as well and I have tried this solution but when I do it seems that my resulting numbers are multiplied all the way down through the report. My string {VWDEPSTAT.DID} is actually a patient-ID (which in Denmark is always the same number for each...

Yes I could: dateadd("s",{MAP_JOB.DATE_TIME_CREATED}, datetime(1970,1,1,02,00,00))