注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

樱之花

叶散的时候,你明白欢聚;花谢的时候,你明白青春.

 
 
 

日志

 
 
关于我

分类中“我的实验室”是我在日常工作中的一些知识总结,有些写的比较匆忙,可能大家在阅读时会产生困扰,后期有时间我会重新整理编辑,谢谢大家的到访,您们的支持是我前进的动力!

网易考拉推荐

RowNumber() fails for Report viewer in VB .Net  

2009-11-26 10:35:10|  分类: .NET/C# |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

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 expression for the textbox ‘textbox6’ has a scope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.

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

All Replies

  • Thursday, August 13, 2009 1:29 PMRowNumber() fails for Report viewer in VB .Net - IDesire - 樱之花 yinzhihua2008Waleed El-Badry Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    You may replace RowNumber (nothing) with RowNumber ("")


    Waleed El-Badry Teaching Assistant Faculty of Engineering Misr University for Science & Technology
  评论这张
 
阅读(628)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017