I use this script to extract all fields from all tables.

select so.[Name] 'Table', sc.ColID 'Seq', sc.[Name] 'Field'

FROM syscolumns sc

INNER JOIN sysobjects so ON so.[ID] = sc.[ID]

WHERE so.xtype in...

Thanks for your help mysorian

Finally got it to do what I want i.e. to number the visible rows ONLY

Code:

<Code>

Public Shared _RowNumber As Integer = 1

Public Function SetRowNumber(thisQty As Integer)

...

Thanks mysorian for your response.

The xml for this subreport is 625 lines long.

I could have included the entire definition (incl datasource/dataset/margin/language etc) but I chose to submit only the code...