Recent content by LHSCNaved

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.