views:

1621

answers:

3

I have a table in a RDLC report which is utilized as a subreport, and the first column of this table is a static string. Does anyone know how I can determine if a row is the first in the table. I tried using "=First("My String")" but it didn't work.

A: 

Aggregate functions work with "Scope', referring to the paragraph scope in this MSDN article, might help...

http://msdn.microsoft.com/fr-fr/library/ms252112(VS.80).aspx"

From what I understand you may have to define a scope or try =First("MyString", Nothing).

ThatBloke
+1  A: 

Looking at the link supplied by ThatBloke in his answer, I found the RowNumber command.

Which means that this worked:

=IIf(RowNumber(Nothing)=1,"myString", "")
Stephen Wrighton
A: 

=IIF((RowNumber(Nothing) Mod <>)=0)

<> Indicate No of Rows Which you want To Display