Ok Thanks Ill Give your suggestion a try

Finally got the pivot to work 🙂

Im puzzled as too why the following is happening

This works...

There are only three records returned from dbo.ApplicationBldTypes...

Back again I have coded my question as suggested 🙂

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

CREATE TABLE #mytable ...

Thank you for your reply 🙂

I have tried the pivot table approach but neither column lends itself to an aggregate function and unfortunatly my skill set with SQL is limited

SELECT...

Thanks for your reply

Sorry Did not make myself clear 🙂

When trying to declare DR as Datarow in the Code window of report, RS throws an error

Datarow does not seem...

Just a quick question

What is the syntax to address the "Last" Column of Table which in this case has only one column.

HTMS

Cheers

I suspect you a correct too...now if I could pass the Dataset as an object then...

Still...dont understand why RS does not "understand" what a Datarow is

Thanks

Hi There

Thanks for your reply.

Yes I am try to build up a string of values.

Interestingly if I do the following

Public Function BldTypes(ByVal DT As DataSet) As String

This line does not...