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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MSBrady

  1. MSBrady

    data parsing quandry

    Okay. Great. Thanks for the help. I was thinking a pivot was the solution.
  2. MSBrady

    data parsing quandry

    Yes RECORDED_TIME is available. Also PAT_ID.
  3. MSBrady

    data parsing quandry

    Oy! SQL Server 2008 R2 EPIC Clarity 2010 I have a table with flowsheet IDs called Clarity.dbo.IP_FLWSHT_MEAS. The associated value names are in another table Clarity.dbo.IP_FLO_GP_DATA liked via FLO_MEAS_ID. The value names I'm concerned with are vitals like 'HEIGHT', 'WEIGHT', 'PULSE', 'TEMP'...
  4. MSBrady

    Accumulate quantity and amount dynamically

    Yep that's it. I thought that Display Horizontally button turned the text 90 degrees counterclockwise so I didn't use it. I had it flipped in my mind b/c it seemed the default was horizontal. Anyway. thanks LB
  5. MSBrady

    Accumulate quantity and amount dynamically

    Thanks LB, and that works, but they don't want the crosstab. They want it displayed as a field. 0123 RevCodeName {Qty} {Amount} chr(13) 0456 RevCodeName {Qty} {Amount} chr(13) etc Group 1 is Guarantor Group 2 is Account Admit Date Group 3 is Department ID Group 4 is Patient ID Group 5 is Rev...
  6. MSBrady

    Accumulate quantity and amount dynamically

    Oy! Crystal 2008 Oracle db Epic data I have a report that is nearly finished. One last thing the user wants is quantity and amounts billed PER RevId. Group 5 is table.REV_CODE_ID, and they want the summary displayed in GF2 table.ADMIT_DATE_TIME. GF 2 currently contains a subtotal of...
  7. MSBrady

    Simple array formula needed

    Used this again today. Thanks!
  8. MSBrady

    Simple array formula needed

    That worked a treat! As always your expertise is very much appreciated.
  9. MSBrady

    Login failed for NT Network Service in Crystal Reports 10

    I remember getting this error a lot when I was building Crystal reports for Dynamics SL. Seems like I would open the rpt file, click Database -> Log On or Off -> Expand the connection -> expand Properties -> set Trusted Connection to 0. I think.
  10. MSBrady

    Simple array formula needed

    Oy! CR 2008 No access to DB Epic source data I always have trouble with array formulas. I have 2 TABLES named CLARITY_EDG and HSP_ACCT_DX_LIST. HSP_ACCT_DX_LIST is linked to CLARITY_EDG w/ a LOJ on DX_ID. In the report I need some identifying information, the primary diagnosis and ALL...
  11. MSBrady

    Row width autosize in crosstab?

    I tried the font size suggestion. Anyone else have an idea?
  12. MSBrady

    Row width autosize in crosstab?

    Thanks LB. I tried that and I see what you're talking about. The unnecessary space is not acceptable to the client. Any other suggestions?
  13. MSBrady

    Row width autosize in crosstab?

    CR 10 SQL Server 2005 Oy! I have a crosstab report that has data fields that vary in length depending on options the user selects at runtime. I need to see if there is any way to get the crosstab rows to size themselves according to the length of the field. The choices the user has are...
  14. MSBrady

    strange IF statement

    Crystal syntax cut and pasted directly from the formula.
  15. MSBrady

    strange IF statement

    I'm posting here b/c I intend to alter it to a more conventional format and I wanted to make sure I didn't miss anything.
See more

Part and Inventory Search

Back
Top