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 |
|
Tart_SQL
Starting Member
41 Posts |
 Posted - 2008-12-09 : 22:15:07
|
| I have this list which I am using in my report and it is grouped on a particular field. There are two values in this group/field "A" and "B" which I want to do a sum on, hence I want to use the "In" operator to filter out other values. But the problem I am having is that I cant seem to know the correct expression to use for the "In" operator to work in the Filters tab of the List property. Any help will be appreciated.That is something like this;=Fields!Alp.Value In ("A", "B") |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-10 : 12:10:12
|
| just use left side rightside=Fields!Alp.Value =A Or=Fields!Alp.Value =Bin filter tab |
 |
|
|
Tart_SQL
Starting Member
41 Posts |
Posted - 2008-12-10 : 12:46:32
|
quote:
Originally posted by visakh16
just use left side rightside=Fields!Alp.Value =A Or=Fields!Alp.Value =Bin filter tab
I tried this and the list repeats for each value. I want the total of specified values displayed in the textbox. |
|
|
|
Zoma
Yak Posting Veteran
76 Posts |
Posted - 2008-12-11 : 08:50:41
|
| I am tryng to understand your request but i cant u want a grouping method or the total of that specified values?If for a total in that text box where u want total right click edit , then expressions, clear the exp. there use CountRows(). It will bring up the total |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-11 : 10:41:49
|
quote:
Originally posted by Tart_SQL
quote:
Originally posted by visakh16
just use left side rightside=Fields!Alp.Value =A Or=Fields!Alp.Value =Bin filter tab
I tried this and the list repeats for each value. I want the total of specified values displayed in the textbox.
what do you mean by list repeats? did you add it to filter tab? |
|
|
|
Tart_SQL
Starting Member
41 Posts |
Posted - 2008-12-19 : 15:34:33
|
| Sorry for not getting back to you on time, I did add it to the filter tab and it did not work. Is there an article that explans how to use list in SSRS? |
|
|
|
|
|
|
Problem with list grouping