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

    Matching Records in Master Details Tables

    Thanks Peter. This is also very helpful.
  2. LHSCNaved

    Matching Records in Master Details Tables

    Hi, Thanks for the help it has started showing results. The other thing which is happening is the distinct count as it suppressing the group header so at the end number is overall. I just wanted to distinct count qualified cases. Thanks.
  3. LHSCNaved

    Matching Records in Master Details Tables

    Hi fisheromacse, I Need to initialize the formula, as when it find the value then TC1 starts adding up. For your kind feedback please. Thanks Naved
  4. LHSCNaved

    Matching Records in Master Details Tables

    Hi fisheromacse, Thanks, I will apply the workaround and will get back. Naved
  5. 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...
  6. 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...
  7. LHSCNaved

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

    Thanks LBass, Worked perfectly.
  8. 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...
  9. LHSCNaved

    SQL Expression Sample Code

    Hi All, Thanks Ian/Lbass this really helped. This forum is really very helpful. Have a Nice Day. Thanks
  10. LHSCNaved

    SQL Expression Sample Code

    Thanks for the reply SELECT count("TempDIRAD"."Encounter") FROM "CaseCosting"."dbo"."TempDIRAD" "TempDIRAD" and I got the Error compiling sql expressions...... native error 156 vendor code 156.....
  11. 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
  12. LHSCNaved

    Sort on Variance Formula

    Thanks Lbass, I create the summaries in the view or Store Procedure and will move accordingly. Have A Nice Day.
  13. LHSCNaved

    Sort on Variance Formula

    Thanks for your email SQL2005/CRXI I am using the following view. SELECT dbo.DIRADCactus.DG_ENCOUNTER AS Encounter, dbo.DIRAD.VisitType, dbo.DIRAD.OrderPhysician, dbo.DIRAD.PhysicanID, dbo.DIRAD.Orderable, dbo.DIRAD.OrderableCount, dbo.DIRAD.ActivityType...
  14. 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...
  15. LHSCNaved

    Dynamic Formula for Instr

    Your solution has worked perfectly and I have achieved first milestone. The small issue which I have is that I cannot use this formula in group sort expert for top 10 tests. Thanks.
  16. LHSCNaved

    Dynamic Formula for Instr

    Hi, Thanks Lbass for your quick response, I did created the inner group and do have 46 records per inner group but would like to have 46 records NM THERAPY ENDOC. MALIG. LN as upper group total. Is is possible that we count number of inner group so that I can divide Upper group total counts...
  17. 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...
  18. 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...
  19. LHSCNaved

    Compare , Sort and Grouping

    Thanks all for your feedback, I will try the workflow defined by LBASS, which I hope will be on target. Thanks a lot.
  20. 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