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

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

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

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server

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...


View Complete Post

More Related Resource Links

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)  

How can I filter a Sharepoint 2007 libarry list based on current user login?


Hi all.

I would like to know how I can filter a SharePoint library list based on current user login.

Suppose I have created the followings:

1) A SharePoint form library containing bunch of uploaded InfoPath form data.

2) The InfoPath form template contains a promoted text field called "TargetUser" to store user domain login (ex: DOMAIN\JOE) and every InfoPath form file in the library has a valid domain name stored in the "TargetUser" field.

I have created a custom view for the form library and would like to filter this view so only items whose "TargetUser" field matches current user's login ID are displayed.

I went to Edit View page to customize the view and tried to use the [Me] function but I got a "Filter value is not a valid text string" message instead when clicking OK. Apparently [Me] returns a Person/Group data type and the filter cannot compare its value to that of "TargetUser".

I tried using text functions (ex: TEXT([Me],"") hoping to extract default string value from [Me]. The filter accepts the parameter without any error but the resulting fitlered list does not display any items at all.

I have googled this subject for hours but I have not found any solution.

It would be greatly appreciated if anyone can help me t

SSRS 2008 R2 running in SharePoint 2010 Integration mode - Not able to schedule reports.



I am unable to schedule report am getting following error when trying to schedule an SSRS report from ReportViewer Webpart in SharePoint 2010.

  • The current action cannot be completed. The user data source credentials do not meet the requirements to run this report. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)

I have SSRS 2008 R2 running in SharePoint 2010 Integration mode on Win 2008 R2 System.

I have also setup the unattended execution account from the Reporting Services Configuration Manager, which has appropriate privilates on the database to generate report.

Also, I have reporting webservice setup @ following url (am using the named instance of SQL Server):


Am able to view the report from report viewer webpart but unable to schedule it.

Kindly let me know what's going wrong.

Thanks in Advance,

Sachin R. Chavan.

Sachin R. Chavan.

create current user filter in sharepoint designer or wss3

hi, how can i create a current user filter in sharepoint designer?

Programmatically creating a SharePoint Site based on user input


I am working on developing a “Create Website Wizard” for SharePoint 2007 that would do the following (I am simplifying a little for the sake of this post):


1.      Take user input as follows:



Product Code:

Category (I, II, III):

The category will be a choice field (radio buttons or a dropdown)

Building Reports in SharePoint Integration Mode

 I configured and connected SSRS to my SharePoint farm, but how do I go about creating reports?  The usual <my server>/reports url is disabled in SharePoint integrated mode.  Can someone point me in the right direction? Thanks, Eric

Setting Title on SSRS (SharePoint Integrated Mode) subscription.

I have some subscriptions in SSRS where the report goes directly to a Document Library on Sharepoint.  The subscription works fine, however, I would like to have the Title of the report be the current date that the report is run.  Is there a way to put a formula such as =[today] in the Title field of the File Options section on the Subscription properties?  I have tried this but either it is not possible or I am not using the correct syntax.  Thanks, Tim Olig

Sharepoint and SSRS Sharepoint integrated mode, any side effect ?

Hi, We planned to switch from native mode to sharepoint integrated mode our SQL Server Reporting Server. But it is a production server, so we liked to know if any side effect can happened on existing report and if it is possible to switch an existing database into sharepoint integrated mode ? Thanks, Mathieu Perrin.

AutoLogin for authenticated user via LiveID in Sharepoint 2010 (Claims Based Authentication)

Hi,     Im working in integrating LiveID authentication in my Sharepoint site. Live id gives back a token of the user with which i created a dummy profile using MembershipProvider.CreateUser. Now i have to auto login the user with the profile i created, i mean i have to force login to my sharepoint site using the created dummy user details without asking the user to give username n password.Any suggestion will be a great help for me to proceed.   Thanks Saravanan Michael

Building SSRS reports based on SharePoint 2007 lists

Hi,   I'm building a SSRS report, and I want to get data out of a SharePoint 2007 list. The difficulty I'm facing is the following: The SharePoint server is behind an ISA Server, and is configured for Form-Based Authentication. Is there a way to keep the FBA and retreve information out of a SharePoint list with reporting services?   Kind Regards,  AVermaas    

SSRS 2008R2 - go back to parent report does not work sharepoint integrated mode

I'm currently using SharePoint Foundation 2010 with SQL Server 2008R2 with the SharePoint RS add-in. I have a report with a drilldown to another report.  I can drill down correctly to the other report.  But when I do the "go back to parent report" it will take me back to the parent report, but when I try to drilldown again to another report, I get the following error. "Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near ' <!DOCTYPE html PUB'. Line: 5 Char: 62099" When I run this report in VS 2008 or Report Builder 3, I have no problems drilling down and back and forth. I only have an issue when I deploy the report to SharePoint.  I have also accessed the RDL directly outside of a webpart page, but still get the same error. Wondering if anyone else is experiencing this issue?

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!

Filter SharePoint list based on ID and scope as Recursive in DataFormWebPart


The following is the code in the DataFormWebPart

<DataSources><SharePoint:SPDataSource runat="server" DataSourceMode="List" UseInternalName="true" UseServerDataFormat="true" selectcommand="&lt;View&gt;&lt;ViewFields&gt;&lt;FieldRef Name=&quot;ContentTypeId&quot;/&gt;&lt;FieldRef Name=&quot;Title&quot;/&gt;&lt;FieldRef Name=&quot;File_x0020_Type&quot;/&gt;&lt;FieldRef Name=&quot;RoutingEnabled&quot;/&gt;&lt;FieldRef Name=&quot;Category&quot;/&gt;&lt;FieldRef Name=&quot;Approach&quot;/&gt;&lt;FieldRef Name=&quot;Channel&quot;/&gt;&lt;FieldRef Name=&quot;Competency_x0020_Pillar&quot;/&gt;&lt;FieldRef Name=&quot;Contact&quot;/&gt;&lt;FieldRef Name=&quot;Cost&quot;/&gt;&lt;FieldRef Name=&quot;Cost_x0020_Description&quot;/&gt;&lt;FieldRef Name=&quot;Country&quot;/&gt;&lt;FieldRef Name=&quot;Editor_x0027_s_x0020_choice&quot;/&gt;&lt;FieldRef Name=&quot;Execution_x0020_Plan&quot;/&gt;&lt;FieldRef Name=&quot;External_x0020_Links&quot;/&gt;&lt;FieldRef Name=&quot;Issue&quot;/&gt;&lt;FieldRef Name=&quot;Lessons&quot;/&gt;&lt;FieldRef N

SSRS 2005 - Change 2nd Parameter Value based on 1st Parameter Value (Non-queried)


I am wanting to filter my report based on Fiscal Year.  I have the first parameter as @STARTDATE and 2nd parameter as @ENDDATE.  The values for both of these are hardcoded in non queried.  When the user selects the @STARTDATE , I want to automatically set the value for the @ENDDATE parameter.  I'm doing it this way because I'm using BETWEEEN in my SQL Query.  Ideally, I will just have the @ENDDATE value hidden if possible.

So for example:

@STARTDATE has values of 10/1/2009 and 10/1/2010.
@ENDDATE has values of 9/30/2010 and 9/30/2011.

When @STARTDATE is selected to 10/1/2009, set the @ENDDATE value to 9/30/2010.
When @STARTDATE is selected to 10/1/2010, set the @ENDDATE value to 9/30/2011.

Any idea how/if this can be accomplished?

SSRS SP1 and Sharepoint 2007 build 6529 Integration

Scenario is single server (VM for dev)

Windows Server 2008 SP2 x86
Sharepoint 2007 build 6529
SQL Server 2008 w/SP1 integrated, SSRS, SSIS, SSAS

Kerberos configured for all Sharepoint services and working, SPNs set on machine account for kernel mode auth

SSRS configured to use service acct

get an error occurred during client rendering.  I also cannot get to the SSRS web service url .../ReportServer

Now i switch the account to networkservice, which contains the spn in AD as a sideeffect, i get the .../ReportServer page, but still the same error in MOSS.  Am i missing something?  I have read articles that state that using NetworkService on a single server with MOSS and SSRS is not supported as that account is explicitly denied access, which ironically both services could use the SPN, but how would i configure SSRS's service account?  also, i see the subsite in MOSS .../ReportServer in both scenarios, however because it's MOSS i am unsure if this is the correct behavior as everything i have seen suggests that a new IIS site needs to be created for SSRS.  If this is the case, where is the integration point in MOSS?

ssrs and sharepoint 2010 integrated mode





I have a ssrs server deployed in integrated mode with sharepoint ..and i have a couple of reports deployed to sharepoint server..Now when i go to sharepoint site and view the reports then the first time it displays them correctly but when i change some parameter and then click apply then it stops and gives me this error.




Webpage error details




User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E)


Timestamp: Wed, 20 Oct 2010 14:52:43 UTC






Message: 'null' is null or not an object


Line: 5


Char: 27772


Code: 0


URI: http://test/ScriptResource.axd?d=Py4uDiRG2xcvSKHQoIG5g7XQIl5Ag_3lpZ_2Whd1GKKqcTDzhhbCKzFkdTe3TFZhlvdrXwq3AK-BAMlv5dvADnjhvAReAHeQZLVkLZNeJ2l9TrQuyz4nUfdaZJ1fTgf4jaPnY19Pqz2WZRnQEqe62-zPhqV08iSTnjrTH7ETAAD9jDjV0&t=5c2f384e




Installation of SSRS 2008 in SharePoint integrated mode

Hi All,

I have got a server (Windows Server 2003 x64) which has the Office SharePoint server 2007 and SQL Server Reporting Services 2008 (in SharePoint Integrated mode) installed in a stand-alone machine (System configured and installed by some other guy). We want to use the SSRS 2008 in SharePoint integrated mode.

I want to make sure that installation and configuration of system is done properly. But i am a starter, so i don't know much where to start.

Please help me which points i have to check to make sure that system is configured properly.

Also i visited the server and found the followings:
1. In central administration, under Application Management tab, Report Services section is not there. ( I think SSRS 2008 AddIn is not installed)
2. Single MSSSQLServer is created for SQL Server 2008, SSRS 2008 and Office SharePoint Server 2007 (Not sure Please let me know where i can confirm this)

Any help is appreciated.


Thanks, Cool Developer
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