.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

ssrs with sharepoint 2007 for FBA user

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#
I have SQL Server 2008 on different server and sharepoint 2007 on different server. i have to put the SSRS report on the sharepoint site. i have user the report viewer in the site and add the ssrs report url to the report viewer it work. but when the FBA user login to that page it asked for the authentication so how to resole that problem. that FBA user does not have to give the login and he can see the report on the site.  

View Complete Post

More Related Resource Links

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

Chapter 3: The SharePoint User Experience, Part 1 (Professional SharePoint 2007 Development)

Learn how SharePoint 2007 takes advantage of many ASP.NET 2.0 features. This means that you can build ASP.NET web pages and blend them into a SharePoint site without a lot of rework.

Chapter 3: The SharePoint User Experience, Part 2 (Professional SharePoint 2007 Development)

Get an introduction to the out-of-the-box features SharePoint provides. Then learn how to use these features to "develop" a site from within the user interface as well as how to add to code like CAML to the other user interface elements.

[Sharepoint 2007] How can i change the email of a sharepoint user ?

Hi all,

I have created a new sharepoint user.

1. First of all i have added a new user in active directory. However at that time i forgot to give an email address. Big mistake !

I cannot send mail from sharepoint workflow with the new user.

2. Therefore I updated the email addresd in active directory afterwards. But the change was not reflected in sharepoint.

I updated the mail in sharepoint adminsitrative user profile. But it did not make no difference in the user moss profile.

I followed the article in http://sharepointnotes.wordpress.com/2008/05/05/syncing-wss-and-moss-user-profile-properties-with-active-directory/

I did the following commands :

1. stsadm -o sync
2. stsadm -o sync -synctiming m:2
3. stsadm -o sync -deleteolddatabases 6
 stsadm -o sync

None of these commands updated the user properties mail for my new MOSS User.

I also rebooted the machine but my MOSS user email was not updated.

Also I used the tool at http://userprofilesync.codeplex.com/releases/view/13227
like the following :

tool>UserProfileSync.exe -url http://mysite -ssp http://mysite:37239/ssp/admin
I did not make any difference

What else can I try in order to update the email of my MOSS user ?

User Profiles Service Application and Import of SharePoint 2007 SSP data

I have setup a test SharePoint 2010 Farm. I will be using this as a test upgrade of a current live SharePoint 2007 Farm. The database attach method will be used. I have replicated the web application and AAM settings of the SharePoint 2007 Farm to the SharePoint 2010 Farm and have made the 2010 Farm a DC in a new Forest. I don't want to join this to the current domain at the moment. It also has SQL server 2005 with SP3 and cumulative update 3 installed. I have just setup the User Profiles Serice Application and when I go to Manage it, I get this. Error An unexpected error has occurred.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: a1760e87-372f-4711-afac-3ceba34bc599 Date and Time: 8/31/2010 4:22:56 PM I have verified and configured the following. Created the Managed Metadata Service. The status is started via Service Applications and Services on Server. Created the User Profiles Service Application and ensured status is started via Service Applications. I started the User Profile Service and User Profile Synchronisation Service via Manage Services on Server.      

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)  

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    

SharePoint 2007 - Survey list - Getting user's Windows account ID from a web service using display

Surveys...grrrr.   I am developing a .NET console application that accesses survey data from a single survey list using the MOSS web service "Lists".   I am able to enumerate the survey list and get to the items except for the author of the survey response.  When I get to the column ows_Author, it appears to be a lookup value formatted like this:  "1066;#JOHN DOE".   How can I, using web services alone, lookup the corresponding Windows login ID of that user?  If I go to the survey in SharePoint and click on the name in the view, it takes me to a site-based user profile page that does show the account ID I want.  The page that displays appears to be a virtualized page like this "_layouts/userdisp.aspx?ID=1066".   What I really need is JOHN DOE's account ID like "domain\id". Can I get to this with the data I have available? Thanks

Problem configuring SSRS 2008 with sharepoint 2007 on Windows server 2008

Hi All - I am unable to integrate SSRS 2008 with sharepoint 2007. I am new to this part please correct em if am wrong. I have 2 servers one for SQL and one for MOSS MOSS server. Windows server 2008 MOSS 2007 .Net 2008 with basic sql 2005 which comes default WSP builder Everything is working fine SQL server: Windows Server 2008 SQl server 2008 and configured SSRS BIDS. When I am trying to install SSRS plugin for MOSS it is not accepting on both the machines. Please help me if am missing something here. I configured sucessfully on one server but havent done on multi server environment. please help me.   Thanks Saritha    saritha k

Document is read-only in SharePoint, but user sees "check out" option in Office 2007 / Word / Excel

I am finding that when there is a document library in SharePoint with checkin/checkout required, if a user with read-only ("Visitor") permissions opens a document from that library, the document will open as read-only in Word, Excel, etc., but the user will see the "Server Document" bar with the message "To modify this document, you must check it out" and the "check out" button.  When the user tries to check the document out, they are asked to authenticate, and then receive the error "Cannot perform this operation.  The file has been deleted or someone else has it checked out."    How is it possible to prevent a user with read-only rights in SharePoint from seeing the "Check out" option in Word or Excel?

MOSS 2007 - SharePoint Designer Workflow failing when using group vs individual user

I am creating a simple workflow in SharePoint designer that will email a selected user when a list is modified.  I am applying the condition "if modified by" in Designer.  This condition works fine and the email is sent when I select a specific user myDomain\username.  It does not work when I attempt to associate a SharePoint group with the "if modified by" filter. In my example the list has only one SharePoint group associated with it, this is the only group with permissions for the list.  The group contains multiple users. The workflow is successful with the following scenario: if modified by myDomain\user1 or if modified by myDomain\user2 The workflow fails with the follwoing scenario: if modified by mySharePointGroupName  (which includes myDomain\user1 and myDomain\user2) This would be an ungodly if statement with a large membership SharePoint group.  This would also be a nightmare as people leave the organization and their account credentials are left in the large if statement in the workflow.  Looking for the modified condition when associated with a group seems like the logical way of doing this. I also tried "myDomain\domain users" which accounts for all user in my domain, this failed as well. Any advice would be greatly appreciated.

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


Sharepoint Server 2007. Sharepoint Designer workflow not starting for one user only.


We have created a custom workflow in SPD that is attached to a document library within a MOSS 2007 teamsite.

The workflow is set to trigger when a new item is created in the document library.

Previously, the workflow has worked fine for all users but recently has stopped working for one user only.

For the problem user, what we are seeing is that when a new item is created in the document library, the attached workflow never starts.  There is no error, the workflow just does not get triggered.  However, if the problem user goes to an item in the document library and clicks on the workflow she can manually start it and it works fine with no error.

This user has the same permissions on the site as others who do not have any problem.

In the course of investigating this problem, we have temporarily increased the problem users permissions on the document library to full control (was contribute before) but this has had no effect on the problem.  Authentication is being done via Active Directory.  We have tried removing the user from the site and re-instating her but again this has no impact.

Does anyone have any idea how we could fix this problem or further debug it?

Looking for guidance: Integrated SharePoint SSRS migration and upgrade from 2007 to 2010


Our existing prod farm is MOSS 07 with an integrated SSRS instance using SQL Server 2008, both on Windows Server 2003 64bit boxes. SharePoint databases are on a different SQL Server 2008 server.

I have built a new SharePoint 2010 farm on Windows Server 2008 R2 boxes, using a single SQL Server 2008 R2 Enterprise server as the backend for both SharePoint databases and Reporting Services (installed in Integrated mode). We are going to be using the database-attach method of upgrading our SharePoint farm.

Is there any specific guidance out there on exactly how to migrate/upgrade Reporting Services in this scenario? I've read through some of the MSDN content (How To: Migrate a Reporting Services Installation) but nothing seems to deal specifically with doing this when in Integrated mode with SharePoint. Our business heavily relies on SSRS reports in SharePoint and also shared and custom report subscriptions via email.

We do have a dev SharePoint 2010 farm in a similar configuration that I can test migration/upgrade steps. Thanks.

SSRS Reports Not updating in Sharepoint 2007


Hello All,

I created some reports in SSRS 2008, The reports data source is a live transactional data source. The reports are to auto refresh every minute displaying any new info that  was put on to the system in the last minute. The auto refresh property on each report is set to 60 sec. to trigger the refreshing of the reports.

The problem: when i run the reports in the report manager the every thing works fine, the report runs, refreshes, and the figures are updated.

I am now displaying these reports in Sharepoint 2007 via the "report viewer" facilitated by the RSWebPart that i installed on the Sharepoint instance. 

The reports are displayed fine in the viewer, but my problem is that it does not auto refresh with the updated info.


I figure it is a caching issue but how to get around? HELP!

MOSS 2007 to SharePoint 2010 Upgrade Fails - Exception: The user or group 'wsaarole:wsaa administra


Ok the top part of the error I have tracked down to some entries in the SharePoint_Config database (Classes, Objects, TimerRunningJobs) and since I have a VM I am going to study them and try deleting them probably, if it dies I will delete this VM and roll up another VM in my case its a timer job that I am guessing the farm can live without.

The other error further down is more of a concern to me which is the one I listed above. The Group exists and it is in the farm and appears to be healthy no errors in preugrade check or the like or in the Farm. When upgrading the show stopper for me is that the content databases will not upgrade (assuming they upgrade FBA I can configure) the chicken and egg issue for me is this is an FBA farm, so is it the case that b/c FBA is missing not configured yet on the other side of the upgrade in 2010 that these content dbs connected to FBA (by FBA users in the content dbs) will upgrade affter FBA is configured ( I haven't tried this yet sorting my error log one error at a time). The Particular content dbs with an issue are shared services and the main site collection db which includes my sites site collections also.

[psconfigui] [SPConfigurationDatabaseSequence2] [INFO] [9/30/2010 3:44:42 PM]: SPConfigurationDatabase Name=SharePoint_Config
[psconfigui] [SPConfigurationDatabaseSequence2] [WARNING] [9/

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

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