Search results for query: *

This is a formula that we use to anonymise names. It doesn't scramble the patient ID but you could easily remove it from the formula if necessary. select{?anonymize} case 'N' : {patients.surname}+' '+{patients.Firstname}+' '+cstr({patients.patient_ID})//[1] case 'Y'...

I've got a report that will be in the format of a letter when I've finished with it (hopefully!). I am at the stage of trying to check that the format is looking correct when the report is printed and finding/fixing the remaining problems in the report. The main issue that I have is that when...

Please feel free to ignore - a fresh cup of coffee has just made me spot my stupidity!!!

I am trying to amend a report to allow for an age range to be selected, so have set up a numeric parameter {?Age} and set the default range to be 20 to 30. My problem is that when the person's age is 30 there is other criteria needed checking that is irrelevant to anyone aged 20-29. How do I...

Fantastic!!! I hate it when someone points out the obvious - I should have spotted that one ages ago! (If there's an easy way and a hard way, guess which way I always end up going!!!) Thanks a lot - That worked perfectly.

Thanks for that suggestion, but I should have stated that I need to access that stringvar elsewhere in the report for other reasons and if at all possible, I would like to keep it so that the product code only need defining the once.

Is it possible to have a selection formula based on a string array? I need to create a report which has a formula that specifies an array of product codes which the selection formula bases the records in the report on. I have tried putting a loop into the selection formula that should check...

Thank you very much to both of you! I went with Gary's method in the end (More because this report is for other people to run and if there are formula's they will only mess around with them!!!) Just one minor comment if anyone else is looking for the same output - the 1st 2 lines of the...

CRXI/SQL Server I have a report that is very tight for space (Needs to fit on A4 Landscape) which has 4 columns in it that need to show a number of days. Some of the day calculations result in 1/2 days which need to be shown in the results. To make the report as readable as possible, I need...

I get this problem quite a lot as the reports I create are run on a number of different databases and machines. I find that this problem seems to occur mainly on Windows 2K (Not sure if that is just coincedence or not) The other main cause that I have found is when the report is attempted to...

Sorry Turkbear, I should have made that a bit clearer. The contracts table has no area stored in it. (Just 20 contracts). the Person table has the area code as it relates to the area that that person belongs to as well as the contract that that person is on. Therefore I cannot link the...

Thanks for that suggestion, unfortunatly that doesn't cure the problem. The only time that the formula returns the 'No person related to this contract' text is for 4 'duff' records that exist in the DB (That I can never be bothered to remove!) I think you have understood the problem fine and...

I have a report that is working correctly but it now needs changing to force it to display info where data may not exist in the database. Current (simplified) setup of the report... 3 tables - Contract, Person, Area (Must remain in that order for the report to work correctly) The report is...

Many thanks for that confirmation - I thought that would be the answer, but it was worth asking! Do you know if the offline viewer would be able to help this situation or not?

Is there any way to make CRS work without using just port 80? The reason for asking is that we have a customer with CRS XI installed on their server and 4 other (completely seperate) organisations/subcontractors logging into CRS to run various reports. 3 of the external...

There's no 'funny' progs like GoBack or anything on the system, due to it's age and lack of HD space I haven't installed anything new on it over the last few months (Mainly use it for web surfing these days). I run spyware / adbot checking progs (Adaware, Spybot etc) at least once a week and...

I thought I had seen or read about most of the peculiar things that can happen in Windows, but I really am puzzled about this one! My trusty desktop PC that has been running in it's current configuration for over a year without problems has suddenly decided that the slave HD is actually a DVD...

Are you having getting problems with Windows freezing (After you get Windows to load fully)? If so, you may have problem with the connectors inside the machine. I had an Inspiron 5000 with similar problems (Would often freeze up immediatly after the welcome screen, or if it loaded Windows it...

Update on this one for everyone else that are experiencing similar symptoms... I have finally got annoyed enough with this problem to do something about it and as it seems to have worked so far(Fingers crossed!) I thought I would let evryone else know what I did. Basically, I took the laptop...

Updated the BIOS by getting the laptop to run by using the 'lift up' trick, waiting for Windows to load and then downloading and running the BIOS update. I know that this 'trick' sounds like a wind-up, but it seems to work most of the time (Or at least until you desperatly NEED to do some work...