Reporting Services :: Where To Install SSRS SharePoint Mode In A Multi-server Environment

Aug 17, 2015

I am setting up sharepoint and sql server integration environment. I am considering the following topology: PowerPivot for SharePoint 2013 and Reporting Services in SharePoint mode Two Server Deployment

[URL]

I am looking to follow the topology example by the letter, which involves installing PowerPivot for SharePoint (aka SSAS in SharePoint mode) in the same server as my SQL, and installing SSRS in SharePoint (SP) integrated mode in the same server as SharePoint.

I understand, however, that if I wanted to install SSRS in SP mode in the same server as SQL, I could but only if the server contains the SP Object Model.

My first question is, what would involve having the SP Object Model in the SQL Server?

Would only installing SP binaries be enough; or Do I need to do a minimal install of SP in the SQL server enough for it to joing the SP farm? And most importantly, what would be the licensing implications for SP in case I want proceed down this route and have SSRS in SharePoint mode installed in the same server as the SQL?

View 4 Replies


ADVERTISEMENT

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

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

Reporting Services :: Using SharePoint Checkbox / Choice Column In Multi-value SSRS Filter

Jul 7, 2015

In one of my datasets, my field "Team" is a SharePoint choice column that is a checkbox, so multiple entries are in it. In my Parameter, I have it as a multiple-value, and I'm specifying the values directly in both available and default.For my filter, I have [Team] IN [@Team], which is where the problem comes in. It will only filter the results of entries that only have ONE listed in Team. 

For example: One entry has "Building" in Team column which SSRS is displaying. But it will NOT display entries where "Building" and "Clerks" are displayed. I believe this is because SSRS sees this as 1 line of text, so it does not just see"Building" but "Building" and "Clerks" so it will omit it.I've tried to have my parameter set to "Get values from a query" but the problem there is the drop-down is too confusing since it interprets it as "Building" and then "Building, Clerks", and then "Building, Clerks, Economic Development' as another drop down, which defeats the purpose of the filter.

how I can get SSRS to show ALL entries that contain "Building" when I choose "Building" as a drop-down choice in my parameter? Instead of only showing ones that is Building only and dismissing other teams?

View 3 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

How To Get Server Mode Option In Reporting Services Configuration For Sharepoint?

Jan 21, 2008


Hi All,
I want to deploy my reports in a Sharepoint site. So I need to change the Deployment mode from Native to Sharepoint Integrated mode. When go to Reporting Services Configuration and in Database Setup - the Server Mode option is not visible. Anyone help me what is the reason for this or How to get Server Mode option in Database Setup in Reporting Services Configuration menu. However the system installed with Sharepoint and SSRS SP2.

Thanks in advance,
Senthil

View 4 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

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

Reporting Services Vs SharePoint Integrate Mode (urgent)

Aug 27, 2007

Dear friends,
I'm having problems changing the reporting services from native modo to integrate mode...
I saw a lot of articles and tips, but I still have problems...
For example, when I change my database setup to integrate mode there is all ok, but in the SharePoint tab has an image with error...

and in the sharepoint server when I need to grant acess to database gets an error to...

and the page that always runned :
http://CGDWX01115883/ReportServer

after I change to integrate does not work and gives me this error:
Reporting Services Error



An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Exception has been thrown by the target of an invocation.

Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.



SQL Server Reporting Services



This page must run ok, no?
Get Online Help

Exception has been thrown by the target of an invocation.

Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.




SQL Server Reporting Services



This page must run ok, no?
http://CGDWX01115883/ReportServer

CGDWX01115883 is the report server and database server
SDC6001SPT01 is the SharePoint Server

Could someone help me?!
Thanks!

View 6 Replies View Related

Reporting Services In SharePoint Integration Mode Problems

Jun 30, 2007

Hi,



I'm having problems setting up Reporting Services in SharePoint Integration mode. The development environment works fine, but I can't get it to work in production.



Problem seems to be in the authentication between SharePoint and Reporting Services. When I go to "Set Server Defaults" in the SharePoint central administration I get the following message:






Code Snippet

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
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.SqlServer.ReportingServices2006.ReportingService2006.ListSecureMethods()
at Microsoft.ReportingServices.SharePoint.Soap.ReportService2006.ListSecureMethods()
--- End of inner exception stack trace ---



I get the same message when trying to deploy a report from Visual Studio to a SharePoint lib.



Some info:



- SP apppool is running under domain account a

- SSRS apppool is running under domain account b

- SP uses NTLM authentication

- SP and SSRS are running on different servers

- SSRS Configuration shows all green checkmarks



Things I tried:



- Basic authentication instead of Windows Integrated on SSRS

- NTLM only instead of Negotiate on SSRS

- Settings SPN's for SSRS, didn't help

- Checked NTFS rights on ReportingServer dir, were fine (Domain users have read/list)



Does anyone have an idea about how to solve this? Any help is appreciated.

View 10 Replies View Related

Reporting Services :: Chart Not Displayed After Deploying SSRS Report In Sharepoint Server

May 22, 2015

I have created a ssrs report using ssrs-2012 that contains 2 tables 2 pie charts and 1 line chart. But I am unable to see 2 pie charts and and 1 line chart after deploying the rdl in sharepoint server.

Why I am not able to see those charts, or sharepoint server will not support charts at all.

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

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 Menu Does Not Appear When Install Reporting Service Add-in For SharePoint

May 14, 2008

Hi all,

I have some problem about reporting service add-in.

After I install reporting service add-in for SharePoint, reporting service menu does not appear in Application Management Tab in SharePoint Central Administration.

I try to uninstall and re-install again, it remain not work.

How can I solve this problem?

Thank you very much.

View 4 Replies View Related

Reporting Services :: Implementing SSRS In A New Environment

Nov 12, 2015

I've been charged with architecting a new SSRS solution for our environment. We're mainly a .NET shop which works with an Oracle Database Server. Our developers want to start using SSRS for report creation and I'm not sure what is the best approach when it comes to this. Normally most of our environments have 3 separate servers, each one is DEV, QA and Prod. With SSRS however, i know that you can create multiple folders each with its own datasource connection, so i wonder if it would be better to just have one server were the developers develop their reports and then move them into a 'production' folder. (Any particular downsides to this approach?)

Also, are there considerations to be taken say, to tune Production SSRS vs a development SSRS or is that not really an issue? Besides that any other resources or tips for implementing SSRS for the first time, we're not going to do much with the actual databases to start we're just going to connect to our main Oracle database. 

View 2 Replies View Related

Reporting Services And SharePoint 2007 Install

Jul 27, 2006

I'm trying to install SharePoint 2007 and Reporting Services 2005 on the same server. However after installation Reporting Services will not load at http://localhost/Reports. Instead I get the following error:

Server Error in '/Reports' Application.
Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'.

Source Error:





Line 164: </webParts>
Line 165: <machineKey validationKey="DA65D9E6980E9CDB52426BF3C793EBAF7FBA3B866117F3CC" decryptionKey="9D7E984E12AA43FDECAB1E05D1E952822680D27BD1F37439" validation="SHA1" />
Line 166: <sessionState mode="SQLServer" timeout="60" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
Line 167: </system.web>
Line 168: <runtime>
Source File: C:InetpubwwwrootwssVirtualDirectoriesc76013d9-5b44-4d06-96dd-24fede1ea955web.config Line: 166

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42


I assume that something is wrong with my virtual server set up. I have the Default Web Site stopped and SharePoint (80) running and set Reports and ReportServer using the Report Configuration to SharePoint (80).

I can get to http://localhost/ReportServer but I get this error when running a report from there:
Reporting Services Error



An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found

Has anyone set these up on the same server? Is there a document around on how to set this up?

Thanks
Kevin

View 5 Replies View Related

Reporting Services :: SSRS Reports Not Running Through Sharepoint

Sep 29, 2015

We couldn't get the report through SSRS deployed URL.  We found dead locks in SQL DB end.how to proceed further issue resolution.

View 5 Replies View Related

Reporting Services :: How To Get Add-in For SharePoint Version To Sync With SSRS Engine

Oct 23, 2015

I have installed SQL 2012 on my DB Server. The SSRS database version table(s) list the current version as 163. The Version number that's displayed in the Programs and Features for SSRS Add-in for SharePoint (yes, on the db server) is 11.2.5623.0.

On my two SharePoint servers the version number for SSRS Add-in for SharePoint shows 11.2.2058. I have installed SQL Server 2012 Service Pack 2 on all three machines. When the SharePoint box calls into SSRS to render a report I get this error:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '163'. The expected version is '162'. --->

Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '163'. The expected version is '162'.

what else I need to install - and where - to correct this error. What is expecting version '162' and why?

View 2 Replies View Related

Reporting Services :: How To Get Distinct Values Of Sharepoint Column Using SSRS

May 13, 2009

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.

<Query>   <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>  
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">     
<Parameters> <Parameter Name="listName">       

[Code] .....

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 preview, the drop down box is giving me all the repeatative values of region like

RG1,RG1,RG1,RG2,RG2,RG2,RG2,RG3..........

I wanted to display only distinct values of Region parameter so that whenever end user select region from the parameter drop down, it will display the respective value of Sales type column.Also when I select only RG1 parameter, it is giving me a chart including the sales type of all the Regions. (it should display me only the sales type of RG1) How can I link these 2 columns so that they will display the values respectively.  

View 36 Replies View Related

Reporting Services :: SSRS Data Driven Subscriptions In SharePoint

Sep 30, 2015

I am looking for a good tutorial on how to set up Data Driven subscriptions through the SharePoint 2012 version of SSRS. I am needing to set up a Data Driven subscription that uses one report, but sends out the specific portion of the report to the appropriate recipients. I have used the information located at URL.... but it doesn't seem to provide all the steps needed to schedule the reports needed. It focuses around setting up the reports to go to shared folder locations. I need something around setting it up to go to email recipients. 

View 5 Replies View Related

Reporting Services :: Mdx Multi Value In SSRS?

May 30, 2015

I was trying to have multivalue options in a ssrs report, and I used this query  

SELECT {[Measures].[Sales Amount],[Measures].[Tax Amount]} on columns,non empty([Product].[Color].[Color],[Product].[Product Name].[Product Name]) on rows

from
( select 
(STRTOSET(@color))
 on columns
 from [Analysis Services Tutorial])

But the report only showed the default value as an option(in this format [Product].[Color].&[Multi] whic is not presentable),and what I also noticed in the parameter option is that, the available values option is set to none , also when I try to use get from query , it does not give me the vales for the parameters,and when I right click the designer pane it does not have the show hidden dataset option.I have created the parameter with multivalue option. what can I do to get the multivalue option to work.

View 2 Replies View Related

Reporting Services :: SSRS Report Run Very Slow Using Mdx In Cube On SharePoint 2013

Nov 21, 2015

I have developed the SSRS report and  deployed them on SharePoint 2013 BUt when I run report  through  broswer It take long time to execute.

View 3 Replies View Related

Reporting Services :: SSRS Drill Through Report Does Not Work When Deployed To SharePoint

Feb 17, 2012

I replied to an thread in the pre-2010 forum before I realized the forum I was in...

I'm using Visual Studio 2008 to Design my SSRS reports. The report viewer is using SharePoint 2010 SP1 integrated mode.

I am using a conditional statement to determine which report to drill to based on the SSRS textbox's column.

=iif((Fields!Type.Value =
"Total")OR
(Fields!Type.Value ="Variance - (F)/U"),"DivisionSpendingReport","DivisionSpendingReportDetail")

Works fine in Visual Studio. Once deployed to SharePoint though, the drill through returns an error that says report can't be found. So I added the .rdl to the conditional statement in the report Design.

=iif((Fields!Type.Value =
"Total")OR
(Fields!Type.Value ="Variance - (F)/U"),"DivisionSpendingReport.rdl","DivisionSpendingReportDetail.rdl")

It now works in SharePoint but not in Visual Studio...

Do I need to keep adding and removing the ".rdl" in order to make any changes to this report???!!!

View 4 Replies View Related

Reporting Services :: SSRS Report Show Blank Page When Executed From SharePoint

Sep 22, 2015

I have a set of SSRS reports published on the server. It can be accessed through a web application or through SharePoint. Most of the reports work fine through both - web app and SharePoint. However, one of the report, which returns large amount of data has some problem:

1. It generates fine from web app
2. It generates fine from SharePoint; only if one or two values selected from Filter dropdown
3. However, if all items (about 20 items) selected from Filter dropdown... and click on View Report, it processes for a while and then shows nothing. The page remains blank.

Did some research and felt the problem is with Distributed Cache Service.

Tried restarting it; tried changing SPDistributedCacheClientSetting settings - requestTimeout, channelOpenTimeout... but didn't work.

I checked Event Viewer logs, SharePoint logs and SSRS logs but couldn't find any relevant error messages.

View 5 Replies View Related

Reporting Services :: Sharepoint Dropping Link To Data Source For SSRS Reports

Oct 9, 2008

I have published SSRS reports to sharepoint and used the Reporting Services Report viewer to present the reports on a Page.  Everything works fine for the day, however in the morning, when I go to view the page, I get an error message 

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

View 9 Replies View Related

Reporting Services :: SSRS - Commas In Multi-Value Parameters

Aug 3, 2015

I have what seems to be a common problem where I have names like "Last, First" that I need to be able to select using a multi-value parameter, which of course, SSRS passes as comma-delimited and gets messed up. I need to find a way to use a different delimiter or pass CHAR(44) instead of the comma, or something. Even worse, some people have suffixes and multiple commas in one name!   

View 4 Replies View Related

Reporting Services :: Can't Find Any Literature On The Native Mode SSRS Databases

Jun 15, 2015

I can't find any literature on the native mode SSRS databases.

so something similar to the MSDB sys tables [URL] Is documentation non existent?

View 2 Replies View Related

Reporting Services :: Create Dashboard With SSRS 2008 R2 Native Mode?

Jul 22, 2015

We want to create interactive dashboards using SSRS 2008 R2. We currently has Report Server installed in Native mode. I see that we can build some good dashboards using SSRS, SharePoint 2010 and PerformancePoint. But I wanted to find out if we can build that level of dashboard using just SSRS. We are still convincing the management for getting SharePoint license. In case if they don't agree for the Sharepoint license, can we build some good dashboards just using SSRS?

View 5 Replies View Related

Multi Value For Single Parameter (reporting Services SSRS 2005)

May 1, 2008

Hi,

I'm using SSRS 2005 which connects to SQL Server 2005. I need to pass Multi valus for single parameter...

E.g. Command type : Text
SELECT * FROM COUNTRY where CountryId IN ( @CountryID)

If i tried to preview using single parameter, it shows the record without any problem. However when i tried to put multi values, it gives error message?? I read somewhere which says, need to set to multivalue. But, i could not find the place to set the multi value option...


How to solve it?? Your suggestion/recommendations greatly appreciated.

Thanks
rama


View 5 Replies View Related

Reporting Services :: Running SSRS 2014 Report Viewer In Standard Mode

Jun 4, 2015

Is there any way to get SSRS 2014 report viewer to run in standards mode? We currently host SSRS report viewer in a standards mode IFrame.  Seems to work fine for all browsers but IE8. In IE8, the report detail is missing.

I'm guessing that SSRS Viewer on IE 8 requires Quirks mode.

I noticed this article which states that SSRS 2014 Viewer only works in quirks mode.

Rendering issues with SQL Server Reporting Services reports in Internet Explorer

How do you get the SSRS viewer to run on IE8 in standards mode?

View 3 Replies View Related

Reporting Services :: SSRS 2008 R2 - Default Multi Value Parameters Are Not Selected

Feb 21, 2011

I've been running into this issue quite a few times, and have been unable to solve it through reading various posts/forums.  Here is the issue

Software Details:
Datawarehouse Database - SQL Server 2008 R2
Reporting Services Version - SSRS 2008 R2
Development Environment - Visual Studio 2008
Problem Details:

I have been writing reports based of a Relational Datamart with dimensions and facts.  The report in question uses dimensions for parameters and facts for content.  Multi valued parameters are enabled in the report query by using the 'IN(@Paramenter)' statement within the report query.  It has a total of 6 multi-value parameters.  I assign the same available values from dimension datasets for each parameter to it's default parameter. Theoretically all the values in the option lists should be selected after first render.  This is not always the case.

Example:
SELECT *
FROM dbo.MyTable
WHERE
TableColumn0 IN (@Parameter0)
AND
TableColumn1 IN(@Parameter1)
AND ....N (continue syntax to 6 multi valued parameters)
 
Some of the multi-value drop down lists are defaulting to have every value selected, and some are not. The problem is I need to know why some parameters are not selecting all by default when specified.

View 23 Replies View Related

Reporting Services :: SSRS Multi-Value Parameter Feed To Table Value Function

Jul 24, 2015

I have an SSRS report with several variables, some of which are multi-valued.  The main query that feeds the report uses some table value functions.  For example, the query looks something like this:

select tv1.a, tv1.b, tv2.x, tv2.y, tbl.m, tbl.n
from tableValueFunction1(@MultiValueParam) as tv1
inner join tableValueFunction2(@MultiValueParam) as tv2 on tv1.xxx = tv2.xxx
inner join regularTable as tbl on tv1.xxx = tbl.xxx

where tbl.abc in (@MultiValueParam).When I try to run this, I get an error saying that I'm feeding the wrong number of parameters into the table value functions.  I've fed multi-valued parameters to stored procedures before and used a splitter function to split out the comma separated values, so I was planning to do the same thing in this scenario.  However, this is different.  When I look at the query in SQL Profiler, it shows discrete values for the multi value parameter.  For example, the same query above looks like this when viewed through the profiler (using 1,2,3 as my multi-value selection):

select tv1.a, tv1.b, tv2.x, tv3.y, tbl.m, tbl.n
from tableValueFunction1(1,2,3) as tv1
inner join tableValueFunction2(1,2,3) as tv2 on tv1.xxx = tv2.xxx
inner join regularTable as tbl on tv1.xxx = tbl.xxx
where tbl.abc in (1,2,3)

In other words, SSRS isn't converting the multi-value parameter to a comma separated string, like it normally does.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved