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 are something like this...
SELECT (SELECT XY FROM XX WHERE RMPROPID IN (@PROPERTIES)), (SELECT YY FROM XX WHERE RMPROPID IN (@PROPERTIES)),(SELECT YX FROM XX WHERE RMPROPID IN (@PROPERTIES))[/CODE]
Could how this is structured be a problem?