Correct.

My bad. 12-21. So, if they are 12 on 1/1 then, include them. If they turn 22 on 12/31, exclude them.

The result is 1.

My bad. I use another forum and they require zip files. I would like to get the percent of the Subtotal so, How do I divide the value in [PtCount]...

Thanx. That's exactly what I needed.

Thanks but, I know how to do that. I need assistance with adding another matrix then, aggregating the dataset.

I added a Matrix to the report using the same dataset. Then, tried to group by Location and use an expression to get the counts for Yes and No's. I...

Here is some test data.

create table #Test

(

Location varchar(10),

PatientNumber varchar(100),

TobaccoUseInLast30Days varchar(5)

)

insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p1','No')

insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p2','No')

insert into #Test(Location,...

Thanx. I thought so.

I should have mentioned this but, this code begins the procedure. So, there are no temp tables.

Thanx

Thanx.

I figured it out. I added a group with a footer then, I added the expression =Count(Fields!EdStatusName.Value) in a cell in the footer.
Thanx.

I added this line to the where clause, "and TextLine<>''. Then, used a subreport for the chest x-ray result.

I found that I need to use a List to drag the fields onto.