Search results for query: *

Hello I am using Crystal 11. I have a database of diagnoses in "long format". Diagnoses have "types" i.e. most responsible, post admit, pre admit etc. The data I'm trying to get at is where a list of codes that are certain types cannot also be other types. So if code I63.0 is a type M it...

Hello I am using Excel 2010 and I'm trying to find a way to limit entries via data validation function. The code in the cells are between 7 and 10 characters with the format of NAANNAA for the first 7 characters and the last 3 could be numbers or letters. The validation for this is cells N78...

Hi I am using SAS 9.3. I have a dataset that is made up of many data elements of a patient visit - one line of data is one abstract. There is the original dataset from the submission and then many correction files. All files have all the same data elements so even if the field isn't being...

Hello I have a dashboard created in Excel 2010 (file extension is xlsm). It has the 12 months of the year for 10 different metrics. Conditional formatting compares the monthly results to the target cell and shows red or green depending on the results. I now want to incorporate performance...

Hello I have a dashboard created in Excel 2010. It has the 12 months of the year for 10 different metrics. Conditional formatting compares the monthly results to the target cell and shows red or green depending on the results. I now want to incorporate performance measurement tracking but not...

Hi I am using Crystal Reports 9.0 reporting from an Access database. I have multiple groups in my report: 1) patient type (Medicine, Surgery, Obstetrical, Psychiatry and Paediatrics), 2) DOW (Weekday, Weekend), and 3) admit type (Urgent, Non-Urgent). What I want to do is create a text box...

Hello I have Crystal XI and was able to link to my Access 2003 table using the Access/Excel DAO connection. Now I've upgraded to Access 2010 and I have to use the ODBC connection. I created the ODBC to the database and Access 2010 drivers. However, if I join more than 2 tables then I get...

Hello I am using Crystal 9.0 linking to an Access database. In a crosstab I would like to have average hospital visits by day of the week i.e. Monday thru Sunday, not actual date of the week. I assume I want the number of visits as a weighted average of distinct days of the week. I have the...