Is there any way in SSRS2008 to deploy multiple instances of the ReportServer running separate code sets? I'm developing a very specific deployment of reporting services where I have a number of custom extensions plugged in. But, my company typically deploys multiple versions of a release at once on the same server. I'm at a little bi...
I'm trying to access the Reporting Services via Web Services in my Visual Studio 2008 Application. How/where can I find my WSDL? ...
I need to send mail via data extension I am having Visual Studio 2008. I am migrating from Visual Studio 2005. Will it possible. ...
Is there any chance of installing Reporting Services 2008 against an instance of SQL Server 2000? The docs clearly state that only SQL Server 2005 or 2008 are supported, but I thought I should ask anyway, for ways to bypass this limitation. I should mention that I am not talking about the data source for my reports (which is a remote da...
I have SSRS 2008 setup on the database server. The server is part of the domain. Reporting Services is running under NetworkService. When I try to add a domain user using the web interface (Site Settings --> Security --> New Role Assignment), the page posts back but the user is not in the list. The server's log file contains the foll...
I'm starting to look into SSRS Report Builder 2.0, and I see in the documentation that it supports connections to SQL 2005. Does anyone know if the reports made against SQL 2005 can then be upload to the SSRS 2005 website and ran from the site? Or, can they only be run from the SSRS 2008 website if they were generated in Report Builder...
I've got a report in SSRS 2008 that is using a web service as one of its data sources. The basic look of the XML returned is <table> <row> <column1>data</column1> <column2 xsi:nil="true" /> <column3>data</column3> </row> </table> Any tags with the "nil" attribute are showing up as blank on the report. I...
Our product leverages Analysis Services combined with Reporting Services, we recently made some changed to add compatability for SQL2008. Everything works great except with certain dimensions, drillthroughs or measures added to a report we suddenly get this following error: Server: The operation has been cancelled. Errors in the hi...
Our company has a reporting solution utilizing Analysis services + Reporting Services, with excel reports being a priority. Everything's sort of fine, but several annoying things are bothering us: No ability to rename the sheets Embedded images stretch the containing cells vertically, thus making scrolling a pain Cross-sheet links are ...
I am testing an upgrade to SSAS 2008 and verifying existing reports working properly. I am able to get some SSRS reports that are using SSAS as a datasource to run without any issues. They are simple and only have a single dataset. The reports that I am unable to get to work correctly against SSAS 2008 have multiple datasets and h...
In SQL 2005 Reporting services we were able to spoof a user when calling a report. This doesn't seem to work in 2008 and the technet articles that appear relevant seem to be implying that you need to create a seperate security extension( Technet Article )if you're wanting to expose reports to the internet. Is this what people are using i...
When using multivalue parameters in sql reporting services is it more appropriate to implement the list filter using a filter on the dataset itself, the data region control or change the actual query that drives the dataset? SSRS will support any scenario, so then I ask, is there a reason beyond the obvious of why this should be done a...
Is there a way to make items right aligned, say with the page or with some other item in a report, using reporting services 2008 ? Right now, I'm sort of emulating this behaviour by shifting items to the right manually so that they look right aligned, however, when there's an item with a dynamic width (e.g. a tablix with data ir the hori...
I would like to have a chart in SQL Server Reporting Services 2008 show the top X values and sum/group the rest as other. Is this possible without doing the grouping in T-SQL? Example: A query brings back the total sales from 50 US states. I want to show the five states that have the most sales and group the rest as "All Other States" ...
Is it possible to use objects as a datasource for a remote SSRS report? I know it is possible to use objects locally from within an application. I would like to like to use business objects as a data source for reports that are run on the SSRS server. In the past I have created stored procedures that returned the same information a...
I have a stored procedure which returns multiple result sets similiar to the following: ALTER PROCEDURE sp_XXXX ( XXXXXX ) AS SET NOCOUNT ON SELECT XXXXXXX IF @@ROWCOUNT = 0 SELECT XXXXXXX RETURN I want my report to use the first result set if it has data or use the second one in case the first one is empty. Any help?...
I ran the solution conversion for a bunch of reports I maintain, but a handful (about half a dozen) failed to convert. I managed to convert some by hand, but some are different enough that changing the RDL by hand is difficult. Is there a better way to fix these reports? ...
Is there a way to set session variables during login that are then available to reports? We have a reporting services server where we move and denormalize data from our transaction system for reporting purposes. In order to allow our users to login with the same user name and password from the transactional system we have set up custom ...
I have a reporting services (SQL 2008) report with two Date/Time parameters - begindate and enddate. I need to constrain enddate to the same month and year as begindate. This seems like it should be an easy thing to do, but I cannot figure it out. Currently, I am checking the parameters passed to the stored procedure and raising an ...