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!

  • Congratulations IamaSherpa 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. MarkEdmondson

    Sub-Report Link Based On Multiple Values?

    I'm trying to developed a Crystal Report containing multiple subreports. This is a Crystal Report that has been imported into MIDAS (Medical Information Data Analysis System. The criteria selection occurs on the MIDAS side and goes into the Crystal Report using the PASS Feature (Pass1...
  2. MarkEdmondson

    Crystal Reports Text Formatting

    Good Morning, I routinely use Crystal to pull predominately text based reports out of our Database (MIDAS). The host database has (what I think is) a weird way of cataloging text in that each line of the body of text is treated as a seperate cell of the database. So, when I pull this text...
  3. MarkEdmondson

    Hours Difference Between 2 dates

    Crud, that would do it. There was a couple available, I clearly grabbed the wrong one.
  4. MarkEdmondson

    Hours Difference Between 2 dates

    I'm also seeking a similar solution. I've used the above formula, and it very nicely generates the count, but the result is a string and cannot be used in any additional formulas (in my case I'm trying to calculate Operating Room Utilization and want to multiple that result by 390(minutes the...
  5. MarkEdmondson

    Crosstab: Suppress Zero (but only some zeros?)

    That sounds perfect, would you mind providing a little bit more detail as to how I could implement? Thank you so much.
  6. MarkEdmondson

    Crosstab: Suppress Zero (but only some zeros?)

    Morning All, I'm working on a crosstab that has a string as the vertical axis and date (by month) as the horizontal axis. In the body of the crosstab I've got a formula (average of a numerical formula designed to calculate compliance). Now all of this works just swimmingly EXCEPT when it...
  7. MarkEdmondson

    Line Chart Based On Compliance Formula?

    OK, let me see if I can clearly explain. I've got a database with survey questions, each question can be answered Y/N or NA. Using your formula above (thank you again) I've given them a numeric value in the details line. I've then used the Summary tool and averaged my Y/N calculation field...
  8. MarkEdmondson

    Line Chart Based On Compliance Formula?

    Thanks to all of those that helped with the above. I've begun being able to chart these measures, and it's been a great help. I used lbass's formula to assign a numeric value to the question, and then the summary average feature to measure compliance. I now have one further question. In a...
  9. MarkEdmondson

    Line Chart Based On Compliance Formula?

    I've applied the approach above, and it's working quite well, but there's a wrinkle. The field I'm studying compliance on has three possible answers....Y, N and N/A. If I use the Summary "Average" option, I get the result I want if only Y and N are in field, but if there's an N/A there, it's...
  10. MarkEdmondson

    Display as Hours in Bar Graph

    Good Morning, I'm using Crystal to ODBC into a medical database. I'm currently trying to report out on surgical delays. In my data source there is a field that calculates this. The problem is it's a number in a text format. I've been able to convert this to a time field for detail line...
  11. MarkEdmondson

    Line Chart Based On Compliance Formula?

    It's gonna take some machinations, but that's going to work well, thanks!
  12. MarkEdmondson

    Line Chart Based On Compliance Formula?

    Good evening all, I'm a relatively inexperienced CR11 user (been tinkering for about a year). I've created a number of reports which measure compliance of several measures based off of Y/N entries in the db. I've created Running Totals on those to count up the Ys and Ns. From there I've...

Part and Inventory Search

Back
Top