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

Okay thanks....anyone else have a suggestion.

Thanks for the input but with 200+ worksheets and 30 cells per worksheet I would much rather come up with data validation rule....plus I do not know how to write a user defined function and I already have a huge amount of code in the on change event.

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

No problem, Skip, thanks for letting me know. And Happy Retirement!!

Yo Skip, are you able to help? I'd really appreciate any assistance you can provide. Thanks.

Hi Skip or anyone else Anyone able to assist me with this? Thanks.

Hi Skip I responded to the post as you requested but haven't heard back. Are you still able to assist? Thanks.

Hi So is anyone able to help with this query? Thanks very much.

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

Hi Skip Thanks for responding. No I haven't created anything yet, was first asking about approach to then know how to proceed. My thought about table structure is that I would have one column per requirement of the Action Plan, with most being text/memo fields. This is to house the data but...

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

Thanks for the tip, Skip. The file extension is xlsm and I will note that in the other post.

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 Charliy Not sure what you're asking but I have 3 groups: 1. ServiceGroupName - i.e. medical, surgical etc. This is the group (in the footer) where I want to be able to create this text note about the findings. 2. Day of Week - 2 possible results of either weekday or weekend 3. Type - 2...

Hi Charliy Thanks...but not sure how this would work if I'm trying to refer to one selection of the group? For instance, Group 2 is "day" which is either Weekend or Weekday as a group. And Group 3 is "type" which has the options of urgent and non-urgent. The text statements will be in the...

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