Search results for query: *

Thanks Peter. This is also very helpful.

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.

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

Hi fisheromacse, Thanks, I will apply the workaround and will get back. Naved

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

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

Thanks LBass, Worked perfectly.

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

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

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

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

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

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

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

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.

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

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

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

Thanks all for your feedback, I will try the workflow defined by LBASS, which I hope will be on target. Thanks a lot.

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