.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

IN operator in Group filter

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#

Hi friends,

I am using IN operator in group filter.

I need to give a set of value in value expression. I am writing like this :

="one", "two", "three"

But its not working for multi valued.

can anyone tell me the expression of multi valued?


View Complete Post

More Related Resource Links

How to filter view using ListViewXML with group by option?

I try to filter my view in list using ListViewXml property. The view has group by section. After implementing a filter for the view data under groups are the same(not filtered), but group rows show quantity of rows for each group  like filter is implemented. So it works well without group by.    XmlDocument document = new XmlDocument();  document.LoadXml(webPart.ListViewXml);  XmlNode queryNode = document.SelectSingleNode(".//Query");  XmlNode whereNode = queryNode.SelectSingleNode(".//Where");    if (whereNode != null)     {        whereNode.InnerXml = query.Query;      }   else       {        queryNode.InnerXml += "<Where>" + query.Query + "</Where>";        }  webPart.ListViewXml = document.InnerXml;    

Any way to filter group or limit the view with recurring events??

It seems that recurring events (in Events view) cause greatlimitations in the views available. For example filtering or groupingon the start date of events does not work.I tried to use a calculated column that makes a 'Start Date' of theStart Time in order to filter on it, but the result is that only thefirst date of a series of a recurring task is shown, which of courseis useless.It seems that the Calendar view is the only way to limit views in day/week/etc.Did anyone else come up with an acceptable way to group or filterrecurring events?  Specifically filtering these recurring events by Week and Month.

group on or filter multiple datasets in 1 table?

I am fairly new to using BIDS, so please bear with me. I currently have 2 datasets, and 1 table.  The layout of the table is: Header HeaderGroup1 HeaderGroup2 Details FooterGroup2 FooterGroup2 Footer Group1 Footer Group1 Footer This is working, but what I need to do is figure out a way to add another Footer Group2 that includes an expression which involves either using data from a 3rd data set because of needing a different filter, or figuring out a way to filter the same data set twice in the one table.   I can give more specific info if you let me know what you need. Thanks!

Trouble Using More Than One LIKE Operator in a Table Filter in SSRS 2008


Hello All,

I'm having what I'm hoping will be a simple issue -

My co-worker has created a large report which contains several tables in SSRS 2008.  Each table is tied to one dataset, yet only certain data can be returned to each respective table.  Right now he's applying filters at the table-level behind each table, however as you can imagine this is not efficient because there is a LOT of data returning for this report. 

I'll try and give a simplified example -

There are two tables in the report body - one for containing products relating to both Cats and Dogs, and one for containing products relating to Birds.   Each product starts with the name of the specific animal - for example "Cats-Mouse Toy", "Dogs-Frisbee", "Birds-Rubber_Leaf".  

Now I need to somehow filter out each product so that they go to their proper tables.  As mentioned above, my co-worker was creating a specific filter for each product, but this is proving to be inefficient.  For example, there are 52 different products for Birds alone.  That would mean 52 different filter entries for each product.  What I would like to do is use the LIKE operator but i'm not getting the results I want on the first table.

So, on the first table I need something like:  =(Fields!Products.value LIKE &

group by with filter


Hi we are using sql server 2005. I created a stored procedure that is used by SSRS report. Actually I am doing grouping in a report.

My Stored Proc generates the following data:









Calendar View: Unable filter Recurring Event by Start/End Time and Group by Recurring Event View

Hi All,
I have just found several issues with Calendar View from WSS 3.0:

Unable to filter by [Start Time] and [End Time]
I am not sure why these 2 columns doesn't appear in the Filtering column in the View Settings. The workaround found in the internet is to create calculated column for Start Time and and End Time. However, it doesn't work for Recurring Event, the calculated column will show only first recurring event Start Time.

Unable to use "Group By"
When I create new view in Calendar using format: "Standard View, with Expanding Recurring Events", there is no option to specify "Group By". Anyone knows how to show all recurring event in List view and grouped by Start Time (or any other column).

Thank you and apprecate for any idea.

[SQL] can we filter data after group by?


with SaleSheet(SaleDate,SaleAmount,VipId) as
select '2010/02/01' as SaleDate ,10 as SaleAmount,'Allen' as VipId
union all
select '2010/02/01' as SaleDate ,20 as SaleAmount,'Allen' as VipId
union all
select '2010/02/01' as SaleDate ,20 as SaleAmount,'Joy' as VipId
union all
select '2010/02/02' as SaleDate ,10 as SaleAmount,'Allen' as VipId
union all
select '2010/02/03' as SaleDate ,20 as SaleAmount,'Allen' as VipId      -- Allen reach the thresold  on 2010/02/03
union all
select '2010/02/04' as SaleDate ,10 as SaleAmount,'Joy' as VipId
union all
select '2010/02/05' as SaleDate ,10 as SaleAmount,'Amy' as VipId
union all
select '2010/02/05' as SaleDate ,10 as SaleAmount,'Joy' as VipId
union all
select '2010/02/05' as SaleDate ,50 as SaleAmount,'Amy' as VipId        -- Amy reach the thresold  on 2010/02/05
union all
select '2010/02/06' as SaleDate ,10 as SaleAmount,'Joy' as VipId
union all
select '2010/02/06' as SaleDate ,10 as SaleAmount,'Amy' as VipId
union all
select '2010/02/06' as SaleDate ,10 as SaleAmount,'Joy' as VipId

-- I run Query on 2010/02/06 and want to know which member reach the thresold ( SaleAmount > 50 ) be

Filter, then sum then group


I have data like this:

day    Qtr    version   items booked

1        Q1      459        45

1        Q1      459        50

2        Q1      459        30

1        Q2      459        35

1        Q4      459        35

1        Q1      460       45

1        Q1      459        50

2        Q1      460        30

1        Q2      460        35

1        Q4      460 &

Filter in group




I have a report similar to the one below –


Region    Customer            Transaction          Amount

123          ABC                 Purchase            

One user in group waiting results forever using BDC data filter


I gave a group of users to be able to search a plan name through a BDC filter on SharePoint 2007. All the users have no problems to access BDC data sources, but only one user in the group got waiting on the searching results forever. But this user has no problems to use any other SharePoint features.
I will appreciate it your any ideas.


Using jQuery to Filter Table Rows

The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:

Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

GridView Multiple Filter AJAX Control

This AJAX control enables the user to filter data within any column inside a GridView. The user can add multiple filters and can delete existing ones too.

Group Calendars in SharePoint 2010

One of the many requests I had in SharePoint 2007 was the ability to place SharePoint Calendars on top of each other like you can in Outlook 2007 saving you having to look at each and work out when the best time is for a meeting.

ListViewControl - how to group items by their value, for eg. date range



I have a table containing courses, columns are 

Name - "Yoga Classes"

DateStart - "2/23/2010"

DateEnd - "2/24/2010"

I am using ListView Control to bind it, is there a way to display them and group them by Month? 

for eg.


Piano Class (10th Jan 2010 - 11th Jan 2010)
Guitar Class (10th Jan 2010 - 11th Jan 2010)


Yoga Class (15th Feb 2010 - 16th Feb 2010)

Thanks for help.

Where to Filter the companies returned by the EF?



I am just starting with dynamic data. I have an enttity framework called UsersModel.edmx.

It returns a list of all companies in the tblCompany table. This list is really big.

I need to filter the list returned to all user controls on the client so that it only returns the company that have a CompanyTypeId= 2 or CompanyTypeId= 3 and company name != "".

1 - Is it possible to filter the company list returned on the server so that I can filter only once for all the controls that use that on the client?

My ideas was to do something like this using linq and lambda but I am not sure how:

return tblCompanys.Where(c => c.CompanyTypeId == 2 || c.CompanyTypeId == 3 && ).Where(c=>c.CompanyName != "").OrderBy(c => c.CompanyName).Distinct().OrderBy(c=>c.CompanyName);

2 - I have created a partial class and a metadata class and added the DisplayColumn attribute to use the company name and sort by company name ascending.

Could I use the code to filter the returned companies in this? where?

namespace MarsMedicalModel
    [DisplayColumn("CompanyName", "CompanyName")]
    public partial class t

Filter by Computed Column



After looking for a driver to open legacy dbf drivers to connect, the next level trouble a have is this one:

first, i can retrieve the data but when trying to filter by a parameter (somesc columns) i get an error.

The error says about the database can't determine some blah blah!

The error is a columm tha is formated (  1234  ) about  8 space, fixed. The values in the query appears like that. I resolve this by Trimming Ltrim(ColumnName) and i get this (1234).

Now in SqlExpress, how can i filter by the new Trimmed Expression? (This is a primary key that the DBF use)


SELECT column1, column2, column3


SELECT Ltrim(column1) as NewExp, column2, column3
Where NewExpre = @NewExpres                  -Error-


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend