malomay

Cheers Garth, So would I need two Datasets to do this, or can it be done with 1 only ? BTW, if it's easier to have the collection name hardcoded into the SQL, I would quite happily go that way at this point. regards Mal.

OK, the site is called windows-noob....and I fit right into that category, so apologies in advance. I am just having trouble getting my head around what I thought should be a relatively simple report. I'm trying to display a count summary of computer Models and the Manufacturer and would like to be prompted for a collection prior to running the report, So for example, in the collection "All Windows XP Systems" ------------------------------------------------------------- Manufacturer Model Count Dell Inc. Latitude E5520 145 ------------------------------------------------------------ The SQL I'm using for the basic report is: ------------------------------------------------------------ select Manufacturer0, Model0, Count(*) from dbo.v_GS_COMPUTER_SYSTEM CS GROUP BY Manufacturer0, Model0 Order by Manufacturer0, Model0 ------------------------------------------------------------ But I'm having real trouble getting my head around the collection prompt, the join clauses etc. Is this something really simple....or am I out of my depth (which is pretty shallow I can tell you !) Any assistance gratefully & humbly received.