.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

sort desc a parameter list

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

The following generates a parameter list with dates that are in the fact table - which is what I wanted.  Now I am try to do two things.  First, I'd like to get the list in descending date order.  Secondly, I'd like to further restrict the list to dates within the past 30 days while continuing to show only those dates that have corresponding fact rows.

Here is the code:


 MEMBER [Measures].[ParameterCaption]


 MEMBER [Measures].[P

View Complete Post

More Related Resource Links

Urgent!!!How can we sort the parameter list in report created using report model in ssrs 2008 r2?


How can we sort the parameter list in report created using report model in ssrs 2008 r2? Do I need to change some property in Model or elsewhere?


Sort by gridview SortExpression parameter via Stored Procedure


I have a gridview that calls data via a stored procedure.  I am unable to enable the gridview columns to be sortable. I need to set the parameter in the Stored Procedure, can someone help me with this?

Here is my gridview:

<asp:GridView ID="AllUsersGrid" runat="server" AutoGenerateColumns="False" DataKeyNames="UserName"
                        GridLines="Vertical" Width="900px" DataSourceID="SqlDataSource1" AllowSorting="True"
                        SelectedRowStyle-Height="30px" CellPadding="4" BackColor="White">
                            <asp:TemplateField HeaderText="Full Name" SortExpression="lastname">
                                    <asp:Label ID="DisplayName" runat="server" Text='<%# Eval("firstname").ToString() & " " & Eval("lastname").ToString() %>' />
                            <asp:BoundField HeaderText="User Name" DataField="UserName" />

.Sort a List problem



I have a little problem with sorting a List<String>.

I have put 4 elements like this and now are trying sort them correct. My example below shows the problem. I am not sure of how sort the names so they comes in this order: "Folder1, Folder2, Folder10, Foler11"  ?

List<String> GetNames = new List<String>();

GetNames .Add("Folder1");
GetNames .Add("Folder10");
GetNames .Add("Folder2");
GetNames .Add("Folder11");

GetNames.Sort(); //Sort the list

The sort comes in this order now which is wrong:

How to sort the list to have this order: ?



How to Sort a List

Hi, I have  aList<String> with textFiles. I wonder how it is possible to sort this List<String> so the  textFiles gets in order starting with the lowest number to the highest number. Now the order is like this and below the example is the sorted order I after to achieve: ( .Sort() does not sort it in this order)List<String> Listing = new List<String>(); Listing.Add("1.txt"); Listing.Add("23.txt"); Listing.Add("12.txt"); Listing.Add("3.txt"); Listing.Add("2.txt"); //Sort so the above list have this order ? Listing.Add("1.txt"); Listing.Add("2.txt"); Listing.Add("3.txt"); Listing.Add("12.txt"); Listing.Add("23.txt");    

Cannot delete external data list column due "Parameter name: combinedEncoded" error

Hello!   I migrated a Sharepoint 2007 to a Sharepoint 2010 by dbattach method. And now I want to delete the BDC list columns, but I'm getting this exception: System.ArgumentException:   Parameter name: combinedEncoded    at Microsoft.SharePoint.BdcClientUtil.SplitStrings(String combinedEncoded) What should I do to delete properly this columns?   Many thanks!

How do you sort the library list under "Document Library" ?

How do you sort the library list under "Document Library" ? I am using SharePoint Service 2007. So far my SharePoint page is still mostly default and haven't gone far yet. The library LIST under Document Library, named "Document" are all not in order. It just keep adding to the last one in list. I am not talking about the folders or files under each library. I am talking about the Library list on the left hand top side below the section called "Documents". I can't find a way to sort it..... HELP    

Delimiter in parameter list

I use multivalue parameters that have data labels with commas in the data.  Specifically, the data label is lastname, firstname When presented in the list box after selection it is sometimes difficult to separate the data from the delimiter.  Is there a way to define a different delimiter than comma for presentation in teh list box? Leo

Report Parameter type for a list of Employees to prompt like AJAX Textbox intellisence when the user


Hi All,

I have around 300 employees report to run for a specific employee, I cannot have a Dropdown as it would be too long for the report user to choose from. Is it possible in SSRS 2008 to have a text box that would provide intellisence like AJAX textbox and provides user with Employee name to choose from database or is there any other better way to select the right mployee name to run this kind of report. being a newbie to SSRS I am unable to go furthur on this. All help is great help. Thanks in advance for responding.

Problem in parameter list while executing the report in sharepoint



I have created one SSRS 2005 report with 3 dependent parameters ,they are BusinessUnit,Account,Project.In SSRS solution file when i click a specific BU name ,then at the same time Account parametr refreshes and shows the corresponding account names and the same for project.

I deployed the report in to sharepoint 2007,that time the account parameter filed is not refreshing paralleling when i click a BU and it shown as inactive.Only when i click the apply parameter acoount fild shows the corresponding account names.Please help me to avoid the issue.Thanks in advance.


List of Month and Year in SSRS report parameter?

Hi, I have two parameters in my SSRS Report i.e. Month and Year. I want to show the list of all Months in dropdown and years for a particular range say 1995-Current Year.
Can any one suggest me the query for how to get it to work.
Thanks!! MCP

SSRS 2008 R2 - Parent Child Hierarchy - Searchable Parameter List


Hi dear,

I'm, workin at the moment on a report for my company. I have a problem with searching in a parameter list which is based upon a parent child hierarchy. The users asked me for type in the first few characters to search the parameter faster (like in this post ) , because it's a large hierarchy with about 1700 values. In a "normal" list ("linear" without  a hierarchy) this feature is available.

So my question:

Isn't it possible to search in the parameter list in general if this is based upon a hierarchy?

Are there any possibilities or suggestions to get this feature?

Or is this the only way to do this:



Thanks in advance!


Infopath 2007 Repeating Sharepoint List Sort Auto Number


Infopath 2007
Browser Enabled
Sharepoint List in a Repeating table

I have a view with a Sharepoint List showing in a repeating table. I have conditional formatting to hide items that should not show based on Line Total.

Line Total = 4

Approver    Min Amount        Max Amount  
Jim                      3                  9
Jack                    1                   7
Sally                   2                    5

Based on this, I need to sort the Approvers based on Max Amount and send an email to them in order of the sort.  Is this possible?


Sort list in dropdownlist



I have created a custom list in sharepoint and then I created a dropdown col (as lookup) to use that list.

All I want items in the dropdownlist to be appeared in sort order. How can I do that.

Any suggestions! Thanks

dropdownlist to sort (ASC/DESC) in Listview



Someone who can help me make a sort (asc / desc) in my ListView through a dropdownlist ?


Sharepoint 2007 list troubles: IP fields and sort by IP


Help! I've created text fields that have IP's but they do not get sorted right.


I know this is correct sort for normal text. Do anybody have any clue of how I can use IP's in Sharepoint 2007 lists?

Assign values to SqlDataSource Parameter from drop down list in InsertItemTemplate


Good Afternoon;

I have a Detailsview grid with an SqlDatasource, this DVG is only going to be used to insert records. The primary purpose of the DS is to populate a DDL control in the insertItem Template that I created my code is this:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
            ConnectionString="<%$ ConnectionStrings:testdbConnectionString %>"
            InsertCommand="INSERT INTO tblSelections(sTesterID, sTestDate) VALUES (@TesterID, @TestDate)"
        SelectCommand="SELECT tName, tExternalID FROM tblTesters">
                <asp:Parameter Name="TesterID" />
                <asp:Parameter Name="TestDate" />

The DDL control populates correctly, but when I try to modify the  INSERTCommand property in my DS, I try to assign the value to my parameters "TesterID" and "TesterDate" but the only options for controls to pick from, is the DGV but not the DDL in it. I assume it has to do with the InsertItem template but even if I reset it I still cannot pick

Can I populate a the drop-down list of a report parameter by custom code


Hi there,

I have a custom assembly that returns an Arraylist and I am wondering if I can populate the drop-down list of a particular parameter by this list. To me, it seems that I can either have static values for such a drop-down list or that I can query the items from a dataset. However, I do not see how I can populate the list using custom code.

Best wishes



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