David Burrows, you are a life saver.

I'm doing the joining to the dataset, acting as a table.

I'm not a beginner to SQL, but this trick was definitely not in my...

Hey,

Yeah the Units count blew up. Initialvisit was correct though ha.

This is the reason I had different datasets, because it is too complex of information spanning many different areas,...

I'm getting closer guys.

Here is the SELECTEDPROPERTIES dataset, this is the dataset the table is based on.

SELECT RMPROP.RMPROPID,propname, AVB_GMSCM.PDSPDID, AVB_PDSPD.VPID, AVB_VICEPRES.SVPID, AVB_SVICEPRES.EVPID, AVB_EVICEPRES.OWNID, COUNT(UNIT.UNITID) units

from RMPROP INNER JOIN AVB_GMSCM...

I'm using SSRS 2005.

SQL.

There is no real reason for multiple datasets other than I was trying to split up "sections of columns" that belonged with each other.

Most of the datasets...

I believe the problem I am experiencing at this point is this.

Each row is referencing every single value selected from multi value parameters and I only want it to reference...

This is the table...the only row pulling data is the middle row...that row has a group by rmpropid. And the table as a whole has a dataset of selected...

I tried to simplify my issue, here are all the factors.

I have 1 table. 1 have 1 multi-value parameter listing all properties called PROPERTIES. I want the table...

bump