MS SQL Server :: Cannot Deploy Reports From Visual Studio To Sharepoint In Integrated Mode

Deploy/edit Reports In Sharepoint Integrated Mode

Jan 26, 2007

Hi,

I'm working with the Dec CTP of SQL 2005 SP2 and the associated Sharepoint addin.

I've been able to get a report created in VS2005 and manually uploaded to the Document Library holding reports, and the report works when I open it (using an internal datasource, not shared).

My first problem is I can't get VS2005 to deploy datasources or reports to my doc library.
I have configured
TargetDataSourceFolder http://server/site/doclib
TargetReportFolder http://server/site/doclib
TargetServerURL http://server/

When I try to deploy my Shared Data Source, it asks me to login, and will not accept my credentials (I am farm administrator, and site collection administrator, and local administrator, and a site owner)

Secondly, for the report I manually uploaded, I can't edit it in Report Builder (from Sharepoint) because I get stuck on entering something that works into the Select Site or Server dialog box. I've tried http://server/ and http://server/site/ and http://server/site/doclib

Can I have some tips please?

Thanks
Martin

View 10 Replies View Related

Reporting Services :: SSRS - SharePoint Integrated Mode - Reports Are Not Functioning

Jul 8, 2015

We have a Report Server integrated with SharePoint. A month ago we deployed a report (rdl file) in SharePoint, but the person who deployed it was no longer connected with us. So we decided to deactivate it in our Active Directory. Yesterday, our users returned issues regarding they are unable to access their report. I believe the issue was "object reference not set to an instance of an object".

So I tried to download the rdl file and redeployed it but i am getting error upon deploying to SharePoint. My workaround is to delete the rdl file in SharePoint, redeploy the shared datasource and shared datasets and the rdl file. It went and was now able to run the report in SharePoint.

Is there something relation/happened when deactivating the account in AD that users unable to access the report in SharePoint?

View 2 Replies View Related

Unable To Deploy Reports From VStudio When Working In SharePoint Integration Mode

Mar 4, 2007

Hello, I have a configuration where my SharePoint services are running on a web machine and the SQL server reporting services are running on a different machine.
I installed SQL SP2 and the SQL Server Reporting Services Add-in for SharePoint by following all the instructions listed in ��Configuring Reporting Services for SharePoint 3.0 Integration�? (http://msdn2.microsoft.com/en-us/library/bb326356.aspx).
My issue is that when I Deploy a report from a VS Report Server project by running Visual Studio on the machine where reporting servicers is running, everything works fine.
But if I try the same thing on any other machine on the network, I get a ��The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.�? message.

I��m sure I��m missing something on the configuration but I can��t tell what.

Thanks a lot

Gabo

View 1 Replies View Related

Deploy Reports Via Visual Studio 2005

Feb 23, 2007

This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services.

I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out"

When I try to connect to connect directly to the TargetServerURL via a web browser from my client or the server itself, I can browse the structure fine. Not sure why I can't deploy via Visual Studio.

Thoughts?

Thanks

View 5 Replies View Related

SQL Server Admin 2014 :: SSRS SharePoint Integrated Mode Versus Native Mode

Jul 25, 2014

We have reports in SharePoint integrated mode which are really slow when compared to native mode. I have been asked to research and give info on what exactly causes the delays.

Any articles which give me information as to what happens when a report is run from SharePoint server and where does it log.

View 1 Replies View Related

SharePoint Integrated Mode

Mar 14, 2007

Hi,

is possible to integrate SQL Server Express with SharePoint or it's possibile to integrate only the SQL Server 2005 version?

Thank's

View 1 Replies View Related

SharePoint Integrated Mode

Jan 25, 2007

Hi!

I wonder where in Reporting Services Configuration
i can change the mode to Share Point Integrated?
Do i need to create a new database,
or can i change the mode for the one i use?

//C

View 8 Replies View Related

RS 2005 SP2 In Sharepoint Integrated Mode

Mar 6, 2007

Up until an hour ago, I was using the Sql Server Reporting Services Report Viewer webpart in Sharepoint with forms authentication, and was not having an issue. The only thing that I did (or remember doing) before things went sour was upload a new report to the document list and since then whenever I try to access a report, manage the data source on a report, change the report URL in the webpart, I get the following message:

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with the error message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/_layouts/login.aspx?ReturnUrl=%2f_vti_bin%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>

--.

I found some related posts and have tried the following, but none have helped:

Removed all reports and reuploaded only the one that was definitely working.
I changed the application pool for the report server to be the same app pool as Sharepoint (runs under domain admin account).
I changed the application pool for the report server back to it's original (which the Reporting Services Configuration prefers - was running under Network Service acct before the problem started, now running under domain admin acct)
I can browse to http://server/reportserver.
I'm running under forms authentication, which had been working.
I can access the three configs for Reporting Services under Application Management in Central Admin - I've tried changing the settings.
I can access http://server/_vti_bin/reportserver/reportservice2006.asmx as well as http://server/_vti_bin/reportserver/reportserviceauthentication.asmx (that was suggested in one post)
I've restarted IIS numerous times, and also finally rebooted the server.
I've created a new document list and set it for report content, just like the other list.

I also just noticed that even though I've set up my admin account as a site collection administrator, I now no longer see my report options under the New button in the document library (both the old and new). I don't know if this is related.

I'm sure that this is a case of something minor that I did that I forgot about. Any suggestions or other troubleshooting that I can do?

Thanks!

daw

View 9 Replies View Related

URL Access And Sharepoint Integrated Mode

Sep 11, 2007

I am trying to run a Reporting services report and pass a parameter using url access and SP Integrated mode.

I have managed to come up with the following: http://DashBrdRptSite/reportserver?http://npvmdashbrd1:2764/Reports/dashbrdrptstore/real%20time%20running/test.rdl&rs:Command=Render&Year=2006&Year=2007&Month=1

This works perfect as long as I run it from the actual server that has Sharepoint and reporting services installed.

If I try to run it from my desktop, I get prompted for a user name and password. And now matter how many times I enter my user/pass... it does not work.

If I just run the sharepoint link that appears on the report when I run it from within sharepoint... such as

http://npvmdashbrd1:2764/Reports/DashBrdRptStore/_layouts/ReportServer/RSViewerPage.aspx?RelativeReportUrl=%2fReports%2fDashBrdRptStore%2fReal+Time+Running%2ftest.rdl&Source=http%3a%2f%2fnpvmdashbrd1%3a2764%2fReports%2fDashBrdRptStore%2fReal%2520Time%2520Running%2fForms%2fAllItems.aspx&DefaultItemOpen=0

That runs no problem no matter where I run it from (my desktop or the Sharepoint Server), but it looks like I cannot pass it parameters. I guess becuase it is useing RSViewerPage.aspx.

Can someone please help me out?

Thanks

View 5 Replies View Related

SSRS Integrated Mode SharePoint

Aug 6, 2007

I have recently installed Reporting Services Integrated mode with minor issues and at the end I was able to execute reports as well as add the content types.

I am now working on doing the same exact thing except I do not see Report Server Content types. I am able to upload a report and execute it but cannot add the Content Types. When I login into Central Administrator I see the content type in there. Is there something I am missing to add it to "My Site"

Thank you,
Dave

View 1 Replies View Related

Passing Mdx Parameters To RS Through URL (SharePoint Integrated Mode)

Aug 8, 2007

Hi there,

I'm running MOSS 2007 in Integrated Mode, and I have a number of reports that are deployed to the Reports Library, and are working just fine when you go there and run them interactively.

Now however, I need to address the report via a URL, and pass it a parameter. Just to add a bit more pain, the report is in mdx, and expects an mdx parameter.

Here is the parameter "prm_cost_centre":

[DIM LEARNER AIM].[COST CENTRE DESC].&[Business]

Here is the URL of the report:

http://vmmoss:88/ReportsLibrary/Report1.rdl

(If you hit that URL as is, it runs fine, using the default parameter)

Now, I know that we have to escape the ampersand, so I'm thinking that this URL should do it.

http://vmmoss:88/ReportsLibrary/Report1.rdl&rs:Command=Render&prm_cost_centre=[DIM LEARNER AIM].[COST CENTRE DESC].%26[Business]

But it doesn't - It throws a 400 Bad Request error.

I know I must be very close, but I just can't work out what URL I need to pass in order to get the damn thing to run.

Any ideas?

View 4 Replies View Related

Reporting Services :: Integrated Mode With SharePoint?

Nov 21, 2015

I verified logs for reporting services integrated with SharePoint and I found many errors like this:

Cannot find site lookup info for request Uri [URL].

what is wrong with configuration?

View 2 Replies View Related

Jump To URL Not Being Rendered In Sharepoint Integrated Mode

Aug 3, 2007

I have a report in which the jump to URL always works in Preview mode in Visual Studio. However, when I publish it to Sharepoint the link does not seem to want to render.

Most of the time if the link is short like http://server.domain.com it works fine.

When I try ="http://servername/projectcontrols/reports/Pages/PhaseExpenditureBreakdown.aspx?Phase="&Fields!PhaseName.Value as the expression it never works in Sharepoint, but does work in Preview Mode.

If I try ="http://"&Fields!PhaseName.Value then it renders the URL in Sharepoint.

Is there some kind of size limit to the URL?

View 2 Replies View Related

Custom Renderer In SharePoint Integrated Mode

Jun 27, 2007

We have been successful in creating a custom Excel Renderer that works very well on a server configured for SSRS Native mode. However we have another server that is configured to work in SSRS integrated mode that we can not get this custom renderer to work properly. The steps we follow are:

After the report results are displayed we select Actions -> Export -> Excel Custom . So I can see the name of our custom rendering type.
After a very short amount of time (no more than a second or 2) I get a frame that says: an unexpected error has occurred. Here is the URL of the web site:

http://sharepointserver/sites/BI/Reports/Reserved.ReportViewerWebPart.axd?ReportSession=2jqe4e45sm0sze553avovv55&ControlID=5c4fbb59def64efdac050393cd3fb338&Culture=1033&UICulture=1033&ReportStack=1&OpType=Export&FileName=edi001&ContentDisposition=OnlyHtmlInline&Format=CUSTOM_RENDERER

Is there anything that has to be done differently to get a custom renderer to work in SharePoint integrated mode?

Note: here is the article we followed to initially create the renderer that will work in SSRS native mode:
http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/

Any help would be appreciated, thanks.

View 1 Replies View Related

Passing Parameters Via URL When In Sharepoint Integrated Mode.

Oct 23, 2007

I'm deploying a performance point site which includes several parameterized SSRS reports. Reporting services is configured to run in Sharepoint integrated mode.

I'd like to pass the parms to certain reports via URL posts when a user clicks on certain fields in a scorecard.

I can setup the basic URL to open a report, as follows:

http://okcrptdev003:81/sites/pps/PPS%20Reports%20Library/Production%20Control/Monthly%20Flash%20Report%20-%20Mgt%20Summary%20Oracle.rdl

When this URL is executed, the sharepoint site redirects with the following URL, which opens the report and prompts for a text date paramater (DatePrompt) in the format dd-mmm-yy (i.e. 01-Sep-07)

http://okcrptdev003:81/sites/pps/_layouts/ReportServer/RSViewerPage.aspx?RelativeReportUrl=/sites/pps/pps%20reports%20library/production%20control/monthly%20flash%20report%20-%20mgt%20summary%20oracle.rdl

I attempted to modify the original URL call to include the date parameter as follows:

http://okcrptdev003:81/sites/pps/PPS%20Reports%20Library/Production%20Control/Monthly%20Flash%20Report%20-%20Mgt%20Summary%20Oracle.rdl&rs:command=render&DatePrompt=01-Sep-07

This resulted in a page not found error.

I then modified the redirected URL to see if that would work:

http://okcrptdev003:81/sites/pps/_layouts/ReportServer/RSViewerPage.aspx?RelativeReportUrl=/sites/pps/pps%20reports%20library/production%20control/monthly%20flash%20report%20-%20mgt%20summary%20oracle.rdl&rs:command=render&DatePrompt=01-Sep-07

This will open the report, but it ignores the parameter and continues to prompt for the date.

Does anyone have any suggestions?

Thanks, mike

View 6 Replies View Related

Problems Configuring SQL Reporting Services In SharePoint Integrated Mode

Apr 13, 2008

I am trying to follow the instructions on:
http://technet.microsoft.com/en-us/library/bb677365.aspx
they contain many "if"s and links to other sites and I got totally confused and stuck.
The idea is - I need to have one machine with SQL for reporting services and SharePoint databases and the reporting services and the other machine for a complete SharePoint installation (the main server of the farm)

Now I have done the following:
two servers (lets call them SQL and MOSS)

The domain contains the following users:
sqlservices: for running all the SQL services and reporting services
moss: for administering MOSS databases
moss-services: for running all the MOSS services
Machine SQL - installed Windows Server 2003 Standard Edition SP1, joined to the domain as SQL
The following is done from a local Administrator account:
IIS 6 with ASP.NET installed
SQL Server 2005 with SP2, Reporting services installed but not configured
all the services are running as domainsqlservices
.NET 3.0 installed
http://support.microsoft.com/kb/918642 fix installed
done WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regiis ��i
MOSS as Web Front installed, not configured

Machine MOSS - installed Windows Server 2003 Standard Edition SP1, joined to the domain as MOSS
The following is done from a local Administrator account:
IIS 6 with ASP.NET installed
.NET 3.0 installed
http://support.microsoft.com/kb/918642 fix installed
done WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regiis ��i
Computers->My computer->DCOM Config->IIS WAMREG admin Service->PropertiesSecurity->Customize->Edit, added domainmoss-services and domainMOSS users with rights Local launch, Local activate
MOSS Complete installed, configured for: New server farm
Database server: SQL
Username: domainMOSS
Port: Default
Auth: NTLM
SharePointRS.msi installed to enable RS in SharePoint Admin page
Then temporarily gave to the user domainMOSS sysadmin rights in the SQL server on the SQL machine to avoid errors with creating databases while configuring SharePoint from the Admin Portal.
From the Admin Portal configured
Office SharePoint Server Search with domainmoss-services account
Shared Services Administration �� New SSP created with 2 separate web apps for SSP and MySites, both app pools run as domainmoss-services and SSP itself runs as domainmoss-services
Windows SharePoint Services Search configured, Service Account - domainmoss-services, Content Access Account - domainmoss-services

Everything went OK.

Now came back to the machine SQL:
run Reporting Services Configuration and:
Report Server Virtual Directory �� created new, called it ReportServer. When hit Apply, the applicatin suddenly quit, but I checked �� the Virtual Directory was registered on the IIS and working.
Checked if Windows service identity is domainsqlservices, OK.
Web service identity: Application Pool: New
Name: ReportServer
Windows Account: domainsqlservices
Apply, everything went fine.

Database setup: choose server SQL, Connect
Database name: New name: ReportServer,
checked Create the report server database in SharePoint Integrated Mode
OK
Credeantials Type - Service credentials (I guess it means previously set domainsqlservices will be used)
Apply,OK, everything went fine.

Launch SharePoint Products and Technologies Configuration Wizard, Connect to an existing farm, Database server: SQL, Retrieve datbase names: selected SharePoint_Config, Username: domainMOSS, Next, everything fine here.

Now as far as I understand I need to give reporting services an access to SharePoint databases? Went to the machine MOSS, launched SharePoint 3.0 Central Administration:

Application Management-> Reporting Services-> Manage integration settings, URL: http://SQL/reportserver, Windows Authentification, OK
then back, Grant database access-> Server Name: SQL, OK, now it is asking for credentials. And now the problem: no matter what I enter (domainsqlservices, domainMOSS) I get a message: ��A connection to the computer cannot be established�?. Why, why, why?
I can ping the server, SharePoint services are running fine and they are using the SQL server on the SQL machine and there are no errors in the event viewer (they should be if there were any problems to connect the SQL databases).
If I enter wrong credentials, I receive "Unable to log on with the given username and password.", so I guess there IS a connection to the computer (or how else could SharePoint determne that login is wrong?).

Also, if I open http://SQL/reportserver, I get ��The report server has encountered a configuration error�? and the log in C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles says ��SharePoint content service is null. Report Server may not have joined the SharePoint farm, or Report Server service account may not have been granted access to farm.�? I guess it is OK while I have not granted access to the SharePoint databases?
Please, show me, what did I do so wrong that ��A connection to the computer cannot be established�?? How can I grant the access and finalize configuring Reporting Services?
Thanks.

View 9 Replies View Related

Error: Email Subscription To Report (Sharepoint Integrated Mode) Options

Jun 28, 2007

I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.

Below is the message detail:

A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)

Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?

Regards,
Gunady Ng

View 6 Replies View Related

The Operation Is Not Supported On A Report Server That Is Configured To Run In SharePoint Integrated Mode

May 23, 2008

Hi,

I got the following exception from the code listed below:

System.Web.Services.Protocols.SoapException occurred
Message="The operation is not supported on a report server that is configured to run in SharePoint integrated mode. ---> The operation is not supported on a report server that is configured to run in SharePoint integrated mode."
Source="System.Web.Services"
Actor="http://haileizws32b:8080/ReportServer/ReportService2005.asmx"
Lang=""
Node="http://haileizws32b:8080/ReportServer/ReportService2005.asmx"
Role=""
StackTrace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.PerformancePoint.Planning.Client.Common.ReportServer.ReportingServices2005.ListChildren(String Item, Boolean Recursive) in c:Officedev14ppsplanningclientCommonReportingServices2005.cs:line 1001
at Microsoft.PerformancePoint.Planning.Client.Common.DataAgent.RetrieveDirectoryStructureFromReportingServices(Object caller, Object parameters) in c:Officedev14ppsplanningclientCommonAgentsDataAgent.cs:line 2027
InnerException:

The code is like:

ReportingServices2005 reportingServices = new ReportingServices2005();

reportingServices.Url = "http://haileizws32b:8080/ReportServer/ReportService2005.asmx";

reportingServices.Credentials = System.Net.CredentialCache.DefaultCredentials

CatalogItem[] items = reportingServices.ListChildren("/", true); <== This code throws the exception.

I can browser and view the items from both Sharepoint site and ReportServer site without problem.

Can you tell me what is wrong?

Thanks a lot!

View 3 Replies View Related

Reporting Services 2005 In SharePoint Integrated Mode With Forms Based Authentication

Feb 6, 2008

Well, I have SQL Server 2005 SP2 Reporting Services installed and configured in sharepoint integrated mode, so I am deploying reports in sharepoint libraries. Also I configured sharepoint to use forms authentication with builtin AspNetSqlMembership provider, but after this action I couldnot open reports through sharepoint library, instead of this, error was displayed mentioned below. I searched and found hotfix Cumulative Update 3 build 3186 for this issue, request it from microsoft support and applied it, but nothing has changed!

Error I have been experiencing is following:

An unexpected error occurred while connecting to the report server.
Verify that the report server is available and configured for
SharePoint integrated mode. --> The request failed with the error
message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/_layouts/login.aspx?ReturnUrl=
%2f_vti_bin
%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>

I continued to dig and find out that this hotfix should update Microsoft.ReportingServices.SharePoint.UI.WebParts.dll from version 9.0.3042.0 to new version 9.0.3180.0, but when I checked file version after applying hotfix, it remained the same as was before i.e. 9.0.3042.0. Apparently this cumulative update does not fix this issue.
anyone has any idea how to solve it? Thanks in advance.

sorry for my poor english :-)

View 2 Replies View Related

Reporting Services :: Datetime Conversion Of SSRS Report In SharePoint Integrated Mode?

Sep 1, 2015

i have created an report which retrieve data from table which contains a datetime field. The data of that particular field is stored in UTC time. when i navigating the report from sharepoint site i wish the datetime field will be converted into local time based on the selected timezone of the user.

View 6 Replies View Related

Reporting Services :: SSRS 2012 Intermittent Report Reloading In SharePoint Integrated Mode?

Aug 17, 2015

issue where SSRS reports being executed from a report library in SharePoint intermittently are reloaded after hitting the apply button to run. We are using SSRS 2010 and SharePoint 2013 in integrated mode. So a user clicks on the report, fills in the parameters and hits apply. Maybe 70% of the time the report runs fine. The other 30% the report just reloads and wipes out any parameter selections. We do have a load balancer in front of the web servers.

I've ran fiddler to capture some of the error logging.

HTTP/1.1 401 Unauthorized
Cache-Control: private
Content-Length: 16
Content-Type: text/plain; charset=utf-8
SPRequestGuid: 3101219d-876e-60c8-a883-dcdee38b81b5
request-id: 3101219d-876e-60c8-a883-dcdee38b81b5

[code]....

Things we have tried. Multiple versions of IE 8,9,10,11, Firefox, Chrome. All browsers seem to exhibit the behavior.

We ran so more traffic monitoring and it doesn't appear on these refreshes that report actually connects to the data context so it seems to be failing prior to that. (Possibly at the SharePoint server. Logging from the server apparently didn't show much in terms of when this occurred) It doesn't seem to matter if the report has 1 or 10 parameters.

We did notice that when we took the load balancer out of the equation and just hit the web server directly, the refreshes "appeared" to decrease in regularity but still occur.Also, the reports do not exhibit the refresh issue when running locally within Visual Studio 2013.

View 4 Replies View Related

Deploying Reports With WSS 3.0 Integrated Mode

Dec 27, 2006

Hi ,

I am trying to deploy reports through visual studio. In the Target server URL, specified the url of the report server as http://<localhost>:<portnumber>/reportserver/Shared Documents/. But
When i deploy it asks for username and password. when i provide them, again login screen appears. Finally deployment fails when i press cancel.

Did anybody face this kind of problem ?

Thanks & Regards,
Kiran Kumar

View 2 Replies View Related

Report Model Accessing SSAS Cube In SSRS Sharepoint Integrated Mode----- Perspective ID Error

Dec 11, 2007

Hi,

I am receiving the following error when I run the report builder query. I am able to successfully select the dimensions and measures that I am intrested in but when I run the report I get the error message.

The 'PerspectiveID' custom property for the 'query' perspective is either not set or is not set to the string data type.
----------------------------
Semantic query execution failed.
----------------------------
Query execution failed for data set 'dataSet'.
----------------------------
An error has occurred during report processing.

I am testing this against both Adventureworks standard and enterprise cubes. Additionality I saw a post in this forum
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
that seemed related but I am using reporting services in sharepoint integrated mode so I am having a hard time trying to troubleshoot this.

Thanks,
Larry

View 2 Replies View Related

Reporting Services :: SSRS Report Parameters Getting Reset After Hitting Apply (Sharepoint Integrated Mode)

Mar 6, 2015

We have SSRS reports (pointing to SQL 2012) containing cascading parameters that we have deployed on SharePoint 2013 and once a user makes a selection to the parent parameter, child parameters are getting refreshed based on the selection in the parent parameter and then we see this:

Once we hit Apply, the Loading image comes up and approximately10 seconds later, The whole webpage gets refreshed and the parameter selections get reset to default parameters.

This is getting frustrating because there are about 10 parameters in the report and once a user makes selections and hit apply if the page gets reset, the user has to make all the selections again.

We are working with Microsoft support on this who suggested us to increase the timeout setting of DistributedCache service on all our SharePoint servers which did seem to work initially but I do see this issue happening occasionally.

View 4 Replies View Related

Hiding Reports In Sharepoint Integration Mode

Jul 20, 2007

I'm setting the Hidden property to True and then creating the report using the CreateReport method from the ReportingService2006 class. When I check the reportserver database Hidden is set to true. But when I call the GetProperties method it shows Hidden as being false. And in the document library the reports are visable.

I tried calling the SetProperties method after I created the report but it still didn't work.

Here's how I create the report.

Dim props(0) As ReportServer.Property

Dim SetProp As New ReportServer.Property

SetProp.Name = "Hidden"

SetProp.Value = "True"

props(0) = SetProp

rs.CreateReport(Path.GetFileName(fileName), Folder, True, bytes, props, warnings)

Any idea?

Thanks,

-Somsong

View 4 Replies View Related

Reporting Services :: RSS Script To Deploy A Single (or Many) Reports To Multiple Sharepoint Report Servers

Sep 8, 2015

So I get the basics, have a script that can deploy a single report to a single server. I have other simple scripts that work as well. Now I want a script that can deploy a single report to multiple Sharepoint servers. I have about 30. I know we are probably doing this wrong, as in, we shouldn't be deploying the same report to 30 sites, as they are all all technically all on the same server however they are all independent site collections so as far as I know there is no way to deploy them to a central location and then link to them from each site.

So I tried to copy elements of my single report deploy script and duplicate the Sub Main() to Sub Main1() and Sub Main2() with multiple "ParentPath1" dims, yes I know I'm stupid. That obviously didn't work. So looking at some other scripts including my own subscription updater and I'm sure I need to do some kind of "For Each item in X" but where to start. The other lists I've seen all come from rs.Something. My list is just 30 variables in the script, how can I say for each site in this list, Publish this report?

Here's the simple script that works fine. I just don't know how to modify it to make it deploy this to multiple sites. After I figure that out, I was going to accept the challenge of deploying multiple reports to multiple sites in a single script...

Dim warnings As Warning() = Nothing
Dim parentFolder As String = "Reports"
Dim filePath As String = "filepath"
Dim reportName As String = "Report file name"
Dim parentPath As String = "Sharepoint site URL"
Public Sub Main()

[Code] ....

View 2 Replies View Related

Managing Data Sources For Reports In SharePoint Inegration Mode

Jul 18, 2007

Through SharePoint you can upload an RDS file and then click manage data sources to hook upthe report to a proper shared data source. Does anyone know if you can do this through the SharePoint object model? We don't deploy our reports using the designer and we don't want to upload the reports using SharePoint. We want to add the reports to a document library using the object model, when we do this we need to manage the data source so that it will run.

Thanks,

-Somsong

View 3 Replies View Related

Deploy From Visual Studio Doesnt Work

Apr 27, 2007

Hello, I created a new Rs server, but when I try to deploy from visual studio, it asks me for username and password multiple times and never deploys.

I am an administrator on the RS server, even on the report folders.

I can access via IE to the report manager.

View 17 Replies View Related

How To Deploy SQL Server Database Project W/o Visual Studio.

Jun 8, 2007

i need a regex support in SQL 2005 server.
i've downloaded SQL regex support project from http://msdn.microsoft.com/msdnmag/issues/07/02/SQLRegex/default.aspx?loc=en.
but in order to enable regex support i needed to open VS 2005. compile the project and deploy it to SQL server. now i can use Regexp-s in SQL queries.
However this is not elegant way to deploy everytime SQL Database project via Visual Studio to every MS SQL server i want.
my question is : how can i deploy without using Visual Studio?

View 6 Replies View Related

Deploying Report Via Visual Studio To Sharepoint - Error

Sep 7, 2007

Hi guys

I seem to be having a bit of trouble deploying my reports from my Reporting Services Project in Visual Studio to my Sharpoint server.

Both the reporting server and sharepoint are installed on the same server.

The settings within my reporting server are as follows (where report is the site name):

TrargetDataSourceFolder - https://server/Report/Shared Documents/DataSources

TrargetReportFolder - https://server/Report/Shared Documents

TrargetServerURL - https://server/Report

I have not yet changed over all my reports to use fully qualified urls yet. As we have multiple domains in which the reports need to go through before they hit the production server and i haven't yet decided how i am going to handle the issues of the reports requiring fully qualified addresses (if someone has a way i would love to know).

I was getting the following error when i tried to deploy the projects but i delete all extensions from the blocked file types and that error went away. I can only guess that there was a file type it didn't like.

Error - "The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators."

When i deleted all the file extensions i now get the following error.

Error - "File Not Found."

Just wondering if anyone has had any success with visual studio and sharepoint deployment or run into this problem.

Thanks

Anthony

View 8 Replies View Related

Reporting Services :: How To Deploy Report Viewer Runtime For Projects Developed In Visual Studio 2015

Oct 16, 2015

I have converted the VS 2013 WinForm project to VS 2015. Once I installed it on client, report viewer is asking for Microsoft.ReportViewer.WinForms 12.0.0.0.With VS 2013 projects Report Viewer 2012 Runtime worked fine. I haven't been able to locate anywhere newer version of Report Viewer Runtime/

View 2 Replies View Related

Visual Studio Output Information In Debug Mode While Running A SSIS Package

Aug 16, 2006

Hello

When running a package in VS you can see something like this in the output window:

SSIS package "logging.dtsx" starting.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Data Flow Task, Flat File Source [1]: The processing of file "C: est ssis loggingad_data1.txt" has started.
Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.
Warning: 0x8020200F at Data Flow Task, Flat File Source [1]: There is a partial row at the end of the file.
Information: 0x402090DE at Data Flow Task, Flat File Source [1]: The total number of data rows processed for file "C: est ssis loggingad_data1.txt" is 477.
Information: 0x402090DF at Data Flow Task, OLE DB Destination [1011]: The final commit for the data insertion has started.
Information: 0x402090E0 at Data Flow Task, OLE DB Destination [1011]: The final commit for the data insertion has ended.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Data Flow Task, Flat File Source [1]: The processing of file "C: est ssis loggingad_data1.txt" has ended.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "DataReaderDest" (87)" wrote 0 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE DB Destination" (1011)" wrote 1 rows.
SSIS package "logging.dtsx" finished: Success.

This is exactly when I need when a package is running but I want to be able to see it without using Visual Studio.
I would do it in Reporting Services but I need to find out to get the information. The SSIS logging feature in a package does not provide that kind of info.

Did someone try this already?

Thanks!

Mop

View 6 Replies View Related