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 strongm 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: *

  • Users: LHSCNaved
  • Content: Threads
  • Order by date
  1. LHSCNaved

    Matching Records in Master Details Tables

    Hello, Environment: Crystal Report 2011 and Access 2003 I want to categorized patients who had a specific procedure or combination of procedures. For an example Category 4 - Colonoscopy inspections with Excission have the following condition At least one of: CCI Procedure Code 1NK87BA...
  2. LHSCNaved

    SSAS Newbie Question

    Hi All, Need some thoughts about the following Scenario. I have two Patient Related Fact tables, one has patient Visit Number, Diagnosis, Discharge Date, Length of Stay,...... and and the second one has the Visit Number, Lab Order Date, Lab Test,Lab Result ...... both have Visit Number in...
  3. LHSCNaved

    Need help with Graph........

    Hi All, VS2008/CRXI/SQl server 2005. I have created a quarter wise report for the Board and different committees of the Board. For each indicator or measure we represent the results and targets for five quarters. Now the management does not want to see the targets values for the year 2009...
  4. LHSCNaved

    SQL Expression Sample Code

    Hi All, CRXI/SQL Server 2005 I need a sample code/syntax to create a sql expression field to calculate sum and count using Sql Server 2005. I have tried multiple option without any luck. Any help in this regard will be appreciated. Thanks and Regards Naved Altaf
  5. LHSCNaved

    Sort on Variance Formula

    Hi All, SQL2005/CRXI. I am calculating Laboratory Test Per patient for the year 2008 and 2009 by dividing (Number of Patient/Number of Lab Test Volume) and then calculating Variance like following. Lab Test Per Patient for 2008 (@TPP2008) if DistinctCount({@2008Case}, {@GroupOne}) > 0 then...
  6. LHSCNaved

    Dynamic Formula for Instr

    Hi All, Environment: CRXI and SQL Server 2005 I am looking for a formula which can count some tests out of thousands using instr. I have thousands of Lab results need to grouped and counted. For example: NM THERAPY ENDOC. MALIG. LN*C 46 Records NM THERAPY ENDOC. MALIG. LN*S 46...
  7. LHSCNaved

    CR Gurus: Need Images in Crosstab

    Hi, I am building a report in CR XI and SQL Server 2005 which has a Crosstab, currently I am using Highlight Expert to make my cell turned into Red, green and Yellow based on the indicator ID. I do have images for Red,Green,Yellow in my table as well but I cannot use then in Crosstab. Is there...
  8. LHSCNaved

    Compare , Sort and Grouping

    Hi All, Before starting this thread I reviewed all previous post but could not find a clue, I am using CR XI and Access 2003. My scenario is like this. I have to track patients with their previous admissions within 90 days, and then count them for particular Wards. In the first step I pull...

Part and Inventory Search

Back
Top