Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Posts
    114

    Unanswered: Multi choice combo and listing them...

    Hello.
    I have a report that prints out all the meds a client is taking. but if a client takes the same med more than once a day it shows like this:

    Dicyclomine, 10mg. 3 x daily 10mg AM
    Dicyclomine, 10mg. 3 x daily 10mg Noon
    Dicyclomine, 10mg. 3 x daily 10mg PM


    Can I get it to show this:
    Dicyclomine, 10mg. 3 x daily 10mg AM Noon PM

    The Time (am noon pm) is a multi choice combo.

    Any help would be great

    Thanks
    Tracy

  2. #2
    Join Date
    Oct 2009
    Posts
    340
    well your information is fundamentally correctly there and that's a good starting point. essentially you are trying to manipulate the display, not the data - - and it is surprisingly difficult for what seems like a simple thing to make that 'stacked' time info (which is the native database organization) into the side-by-side excel look.

    Consider the patient with an hourly dosage - you would need 24 side-by-side fields! If this is potentially possible - then you could run out of paper in the left-to-right layout concept which may be a deal breaker too. In which case one should pause to consider your original layout.

    So there are 2 approaches; one is to investigate the crosstab feature. that fundamentally gives you what you seek as the name implies.

    the other approach to consider is the grouping feature in Reports which will not give you what you seek but is simple and may suffice. it would give you:


    Dicyclomine, 10mg. 3 x daily 10mg AM
    Noon
    PM

    with grouping you can put the common info into the group header and avoid eye fatique and allow the variable data to stand out. very common.

    hope this helps.
    www CahabaData com

  3. #3
    Join Date
    Oct 2009
    Posts
    340
    note: in the post above - the wrap of lines changed - - and so the time data is skewed and no longer vertical.....
    www CahabaData com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •