Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-07-26 : 04:02:18
|
| Hi,I have an expression in my text field as:=First(Fields!FirstNameEnglish.Value, "Members_DS") & " " & First(Fields!LastNameEnglish.Value, "Members_DS")in which "Members_DS" is a dataset.when I build my report I get following error message:Aggregate functions cannot be used in data set filters or data region filters.The filter which I've set in "Members_DS" is: =First(Fields!PersonnelCode.Value, "shared_DS")Could I know where I'm wrong? [Unsure] |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-26 : 11:57:14
|
| why are you using first(). didnt understand what you're really trying to display. Also it seems like your container is not linked to a dataset ( seeing the scope parameter name). can you explain the reason? |
 |
|
|
|
|
|
String Concatenation