Hi,
I am using VB 2008 (.Net 3.5), MS Access 2003
I have a report viewer and I have attached an Access query to my repot. It is a simple report, no group etc. Everything
works fine and as I expect it to, however whenever I try to use built-in function RowNumber(), I get the below error-
The Value expr
I have tried
=RowNumber(Nothing)
=RowNumber("Nothing")
=RowNumber(Body)
=RowNumber("Body")
=RowNumber(Table 1)
=RowNumber("Table 1")
I looked at MSDN and few other related posts, however I could not find what I should be using for SCOPE parameter.
Am I using some wrong parameter, doing something wrong here.
Any help is much appreciated.
Thanks in advance.
Pranav
PN-MH, India
评论