Using variables
in [Reports]
|
Prev: Large multi-select list box - performance
Next: Using reportingservice2005 and reportingservice2006 soap interfaces in the same application
From: Raj on 6 May 2010 07:34 How do I create a variable whose value is keep on increasing for every record in the report? I need to create a serial number column in the report. I cannot have this column in the database table. Thank you Regards Raj
From: Uri Dimant on 6 May 2010 12:01 Raj Why you cannot have it in T-SQL? "Raj" <Raj(a)discussions.microsoft.com> wrote in message news:9AAC7217-9687-4BAA-9C5C-320CEA03C348(a)microsoft.com... > How do I create a variable whose value is keep on increasing for every > record > in the report? I need to create a serial number column in the report. I > cannot have this column in the database table. > > Thank you > > Regards > Raj
From: Raj on 7 May 2010 00:49
Got it: try using RowNumber(Nothing) "Uri Dimant" wrote: > Raj > Why you cannot have it in T-SQL? > > "Raj" <Raj(a)discussions.microsoft.com> wrote in message > news:9AAC7217-9687-4BAA-9C5C-320CEA03C348(a)microsoft.com... > > How do I create a variable whose value is keep on increasing for every > > record > > in the report? I need to create a serial number column in the report. I > > cannot have this column in the database table. > > > > Thank you > > > > Regards > > Raj > > > . > |