.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

Distinct Sharepoint Parameter in RS

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server
Hi, I used the previous threads regarding distinct values for sharepoint lists, to add my parameters to my report.  I got the distinct values, I got the main parameter to appear as a dropdown.  However, I cannot get my parameter values to change from the default values.  This also implies that I cannot filter my Dataset.  Any help in this regard?

View Complete Post

More Related Resource Links

Duplicate URLs in Source Parameter of Query String for All SharePoint Lists

After performing a database attach method of upgrading our existing web application from MOSS 2007 to SharePoint Server 2010, all of our lists that migrated now exhibit an interesting but undesirable behavior.  The DispForm.aspx and EditForm.aspx pages that get loaded are given the Source parameter of the query string but instead of the URL being a single entry like: Source=http://sharepointsite.domain.com/Pages/Default.aspx It winds up putting the URL twice like this: Source=http://sharepointsite.domain.com/Pages/Default.aspx,http://sharepointsite.domain.com/Pages/Default.aspx Naturally this makes processing of the form -- either by choosing OK or Cancel buttons -- result in an HTTP 404 error.  The question we're left with is how in the world did the Source parameter get set that way to begin with.   It wasn't that way in 2007. We had thought that perhaps there was something that didn't migrate over correctly for the existing lists, so I tried creating a new list and then added a new item to the list.  So far so good.  Then attempted to Edit Properties or Edit Item or even View Item, etc. -- essentially triggering the load of the EditForm.aspx and DispForm.aspx  -- and we received the 404 again.  At this point we're not sure what's going on or how to fix it.  We've performed the migration three times so far with t

How to pass current user's login name as parameter to a RDL . (SSRS integration with sharepoint)

I have a webmethod which has two parameters. One is for year and another is for Currently logged in user. I call this method in RDL file. From RDL File how can we pass Currently logged in user's login name? I tried  with USER!UserID. It is passing the USERID but i need to pass the login name(SPWEB.currentuser.loginname)  

SharePoint Dataview Insert New Mode - Defaulting a Required Column to a Query String Parameter Valu

I've got a SharePoint DataView with an insert button. there is a required lookup column I want to default to the value of Querystring Value during new mode.  Can I do this in the generated code below? I tried replacing @ApplicantId with @QSApplicantID.. and  tried string(@QSApplicantID) too.. no luck gave me an error: The data source control failed to execute the insert command. Could it be that QSApplicantID (which I've used in my DataView Datasource filter with no problem) is not available during the insert? I think I can do what I want in Javascript but was hoping I could instead right in the XSL markup. *my query string parameter**     ParameterBinding Name="QSApplicantID" Location="QueryString(ID)" DefaultValue="2222222"/ **the new form** SharePoint:FormField runat="server" id="ff4{$Pos}" ControlMode="New" FieldName="ApplicantId" __designer:bind="{ddwrt:DataBind('i',concat('ff4',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@ApplicantId')}" / **the link** a href="javascript: {ddwrt:GenFireServerEvent('__cancel;dvt_1_form_insertmode={1}')}">Insert</a Thanks for any help or information!

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.


"How to get distinct values of sharepoint column using SSRS"


    I have integrated sharepoint list data to SQL Server reporting services. I am using the below to query sharepoint list data using sql reporting services.

   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
         <Parameter Name="listName">
            <DefaultValue>{GUID of list}</DefaultValue>
         <Parameter Name="viewName">
            <DefaultValue>{GUID of listview}</DefaultValue>
         <Parameter Name="rowLimit">
<ElementPath IgnoreNamespaces="True">*</ElementPath>

By using this query, I am getting a dataset which includes all the columns of sharepoint list. Among these columns, I wanted to display only 2 columns (i.e Region and Sales type) using chart. I have created a Region parameter but when I click

Parameter value filter based on user in SSRS (SharePoint Integration mode)


Hello..we have a reuirement where we have to filter the parameter value in the drop down based on the user who is accessing the report. We have form and Windows authenication enabled in the SharePoint site (some users will be from inside the network using windows and some will be accessing the site using internet using the Form Authentication).

Please let me know what would be the best way to handle this reuirement? Do we need to create a separate table  and store the User Information along with the parameter values they have access to, pass the userid from Report to db and then fileter the records using this table? OR Can we create a SharePoint List to maintain the user access information and then directly fetch the user information from the list using T-SQL to filter the records?

Please let me know your suggestion...


how to distinct values of sharepoint custom list using SSRS (new from http://social.msdn.microsoft.c


i hope jin chen would read this.

i followed his instruction from the link above(in the title)

i still got an error message :

System.Web.Services.Protocols.SoapException: An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC42105] Function 'RemoveDups' doesn't return a value on all code paths. A null reference exception could occur at run time when the result is used.’.
   at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetReportDefinition(String Report, Byte[] Definition, Warning[]& Warnings)
   at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.SetItemDefinition(String ItemPath, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
   at Microsoft.ReportingServices.WebServer.ReportingService2010.SetItemDefinition(String ItemPath, Byte[] Definition, Property[] Properties, Warning[]& Warnings)

could anybody tell me what's wrong?

and by the way,

i'm using ssrs 2008 r2

i use report builder(content type) to create reports from sharepoint lists.

thx in advance.



How to get distinct values of sharepoint column using SSRS: paramter Greyed out


I'm referring to a previous thread: How to get distinct values of SharePoint column using SSRS.  I followed all the steps as set out but when I view my report, the parameter is greyed out.  I then downloaded the example report of Jin Chen.  In that report, he suggests a blank parameter label for the main parameter, as well as, a default value for the hidden parameter (which is different from the initial thread posted).  When I change my report accordingly, I get an error: An error occurred during local report processing. MainParameter.  Anyone with suggestions?

Sub Report parameter window - SharePoint Integrated


We use SSRS in SharePoint integrated mode.   I have a report with parameters where the user can call into a sub-report.   When the sub-report is displayed, is there any way to cause the parameters panel (on the right side) to be open when the sub report runs?


Chris Fleming

Chris Fleming

Anyone know how to create a parameter in Sharepoint?

I have a db field that I want to create a parameter for in Sharepoint and I am not sure how to go about doing this within Sharepoint. How I want it to work is when I go to the page in Sharepoint the user should type in a value based off the database field and it will bring up the page  based on the parameter value. Hopefully this makes sense and someone will help.

How to pass parameter in sharepoint form action "Navigate to page"

I'm new to MOSS 2007, currently working on the SharePoint form.
In the NewForm.aspx page, once user entered all the fields and click on the "save" button, the data will be save into the list and also i tried to redirect it to other page.

I read few articles on this issue, most of it is about redirect to same directory but different page. Example: Allform.aspx, Display.aspx or editform.aspx.

I wanted to redirect to different path page.
javascript: {ddwrt:GenFireServerEvent('__commit;__redirect={http://server/test/myForm.aspx}')}". This line works when i click on the "save" button.

Assume i wanted to pass a title parameter to directed page.
javascript: {ddwrt:GenFireServerEvent('__commit;__redirect={http://server/test/myForm.aspx?PageTitle_x003D__x007B_@Title_x007D_}')}  <=== this line not working, what i get from the directed page by using querystring is "{@Title}". 

How can i pass the parameter to directed page and read the value?

Anyone can help me on this?


sharepoint SSRS parameter problem



I had created ssrs report in SSRS 2008 based on sharepoint list in SHarepoint 2007

I had created parameter of EMPGroup from another dataset.

Paarmeter datatype is text.

When I use that parameter to filter the report in tablx properties as

columnname  in parametername  it shows  data on running report


columnname LIKE parametername it shows  error on running report


Thanks & Regards, Vyankatesh Mujumdar

Querying a SharePoint List: Creating a Report Parameter based on a SharePoint List field

I have been struggling with this problem over a week now and am at my wits end.   I have created a RS(2005) report and am currently querying data from a SharePoint List.  If anybody is interested in seeing how I set it up I follow this simply walk through on Code Project.  http://www.codeproject.com/KB/reporting-services/ReportFromSharePoint.aspx.  

I need to create a custom report parameter and reference a field that I have created in my SharePoint list.   When I run the report I would like to 'Filter' the result set with the value selected in the report parameter field.  I have looked anywhere and everywhere and don't know if I am over complicating this problem but I have yet to find a solution. 

Please and Thank you
Software Engineer

Changing the graphics on the home page of a SharePoint site

When you create a site in Microsoft Windows SharePoint Services by using the default Team Site template, the home page includes two default graphics. A Windows SharePoint Services graphic appears in the body of the page, and a picture of a house in a circle appears near the site title. You can change these graphics to customize your site. Changing the smaller graphic requires a Windows SharePoint Services compatible Web page editor

Displaying SharePoint lists in Web Parts

When you create a built-in or custom list in Microsoft Windows SharePoint Services, Windows SharePoint Services creates a Web Part, a basic building block of a SharePoint site, to display that list. These Web Parts are called List View Web Parts. Windows SharePoint Services stores List View Web Parts in the site collection Web Part gallery. (The site collection Web Part gallery is the most central gallery of Web Parts for a work group. By default, the gallery name is the name of the site, such as "Our Team Site Web Part Gallery." )

Take a tour of your SharePoint site

What is a SharePoint site for?
A SharePoint site is a Web site that provides a central storage and collaboration space for documents, information, and ideas. A SharePoint site is a tool for collaboration, just like a telephone is a tool for communication, or a meeting is a tool for decision making. A SharePoint site helps groups of people (whether work teams or social groups) share information and work together. For example, a SharePoint site can help you:

Coordinate projects, calendars, and schedules.
Discuss ideas and review documents or proposals.
Share information and keep in touch with other people.

Six easy ways to customize your site using Web Parts in SharePoint

Becoming familiar with Web Part customization techniques gives you a range of page-customization choices. For example, you can customize your site's home page so that it displays the specific information that your team needs. You can rearrange the list items on the home page, add lists, and even change the images on the home page. As you become more familiar with Web Part Page customization techniques, you can build interactive Web Part Pages that makes the data in lists more dynamic and useful, and you can add new Web Parts that provide access to external data and Web services.
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