Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TechSlinger

    Comparing Data Array to Other Data Array

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

    Limit Format in Cell to NAANNAA Format Using Data Validation in Excel?

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

    Limit Format in Cell to NAANNAA Format Using Data Validation in Excel?

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

    Limit Format in Cell to NAANNAA Format Using Data Validation in Excel?

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

    Link Data to Excel Dashboard (Same Document)

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

    Link Data to Excel Dashboard (Same Document)

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

    Link Data to Excel Dashboard (Same Document)

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

    Link Data to Excel Dashboard (Same Document)

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

    Link Data to Excel Dashboard (Same Document)

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

    Updating SAS Dataset With Files in Sequential Order

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

    Link Data to Excel Dashboard (Same Document)

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

    Link Data to Excel Dashboard (Same Document)

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

    Link Action Plan to Excel Dashboard

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

    Link Action Plan to Excel Dashboard

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

    Reference Different Groups Values?

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

    Reference Different Groups Values?

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

    Reference Different Groups Values?

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

    Crystal XI and Access 2010 - Issues Retrieving Data

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

    Denominator for Day of Week?

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

Part and Inventory Search

Back
Top