I don't know if Grasshopper wants to only display the subprojects that aren't null or not create the report at all if any of the subprojects are null. If it's...

Thanks I'll try it out later.

Cursors are SLOW! Use a loop instead. Try something like this:

DECLARE @Count INT,

@LoopCount INT,

@MyField1 VARCHAR(50),

@MyField2 VARCHAR(50)

SELECT IDENTITY(INT,1,1) ID, MyField1, MyField2 INTO #Temp FROM MyTable

SELECT @Count = @@RowCount

SET...

Hi if your getting the following error your subquery contains more than one record:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <,...