How can i link a sql server job name
to the SSRS report server process that uses it? the name looks like a guid, but i need to find the reporting services reports that use it. thanks very much ...
reporting-services
SSRS report page break problem
I need look at a problem with page breaks in an SSRS report, and I'm by no means an expert. This is in the XML mark up to provide a page break: <TableGroups> <TableGroup> <Grouping Name="AdjustmentPageBreakGroup"> <PageBreakAtEnd>true</PageBreakAtEnd> <GroupExpressions> <GroupExpression>=CInt(Ceiling(RowNumber(...
Repeated Reporting Services Login issue when deploying through BIDS to a remote server
We are having a problem deploying a reporting services report to a sql reporting services computer that is configured in SharePoint Integrated mode. I can successfully deploy to the SharePoint document libraries set up for reports and data connections if I do it locally from the box that SharePoint and Reporting Services are deployed on....
SRS Reports: URL Parameters, Multiple Values
Similar to this question: link However I have already mastered that. My problem is a new report we just added at work has values for parameters (i.e.:10-New, 20-Cancel, 30-Complete). For the life of me, I cannot figure out how to pass multiple values for the same parameter. (so from the previous example, choosing 10-New and 30-Complete...
Can we set parameter width manually, in SSRS?
Hi All, Is it possible to set the report parameter's width manullay in SSRS. I could see that the parameters are given the width by SSRS itself, and the XML coding is not having any attributes mentioning its width. I was wondering is there anything that we can add in to to set the report parameter's width? Thanks for your help all in...
SSRS 2008 Fixing the Row Header
In SQL Server Reporting Services 2008, I cannot always fix the Header row of a Tablix. Right-clicking the tablix and checking Repeat header rows on each page accomplishes nothing. Expanding the group panes to Advanced View and right-clicking numerous (Static) row group sections and changing properties RepeatOnNewPage to True works only i...
What's your preferred method for generating datasets in SSRS?
I am trying to figure out what is the 'best' (read: "your preferred method") way to generate datasets for SQL Server Reporting Services Reports (either 2005/2008): In-report queries Stored procedures Views But more than just choosing one of the above, why would you use that particular method? Also, please include your perspective (De...
Do I have to use ServerMode for Microsoft ReportViewer in a WebForm?
I'm trying to view a "Hello world" report using Microsoft Reporting Services in a web application. The reports I'll be creating are always refreshed when viewed (ie. no saved data) so I see no reason to use the Report Manager. I want to include the rdlc file's in my web application itself where I'll have an aspx page that hosts the Rep...
SQL 2008 report manager not accessible
I have a SQL 2008 developer edition with SSRS and the report manager is only available from the local machine. If I try to access it from any other machine I get challenged for my domain u/name and pwd 3 times and then the screen stays blank. I have made changes to some config files (originals copied out) in order to get a 3rd party app...
Returning Data without Accesing a Table
The Situation (Ignore this it is boring): I have reports that I created using reporting services. Some of these reports take the parameter, "Month". They enter in an integer for the month they want. Example: December = 12. In order to view the report, I am simply using the Report Viewer in visual studio. I need the month field to be a dr...
ReportViewer height issue. Hiding scrollbars.
Hi, I'm using MSSQL 2005 Reporting Services and in this case I need to display some reports on an ASP.NET page using the ReportViewer control (I guess thats the only way, right?). The problem is that I can't get the property SizeToReportContent to work. When displaying the report, I get a vertical scrollbar because the report is too la...
Creating and managing annotations in SQL Server Reports
Hi I need to load SQL Server reports over the web and make it more interactive for a set of users by: Allowing them to put up their annotations/comments on different visualizations being shown. Track these annotations for each screen. Is it possible with SSRS or any other visualization mechanism? Please let me know of any means to d...
SQL Reporting Services maximum subscribers
Hi, I'm just wondering if anyone has had any problems having too many subscribers for a report in reporting services. I had 11 people in the "to" address and the 11th person never received anything. On one of the reports I moved the 11th name to the "cc" field and they occasionally received it, but on another report with the same parame...
Consuming web services with reporting tools
Hi all, a customer of mine happend to ask me to come up with a technical solution for the following scenario: basis is a crm tool where the customers (i.e. the ones who bought the system) are not wanted to access the database for queries directly (in terms of table level access) there's plenty of reporting in the software, but someti...
Is it possible to use Excel 2010 like sparklines in SSRS
I want to know if it possible to repoduce the idea of Excel 2010 sparklines in a SSRS 2005 Report. I want to show a report that has an indication of the price fluctuations over a 3 month period for a range of products. I could just give the figures over the 3 month period but it is very hard to quickly distinguish what is happening to ...
Subscriptions etc with SSRS and SQL Server 2005 Work Group edition
Does anyone have any suggestions about how to schedule the creation of reports and how to allow users to view them in a SQL Server 2005 Work Group environment where scheduling and subscriptions do not appear to be supported. SQL Server is installed on a separate machine to that running IIS to support multiple production websites. ...
Exporting a Dyminics CRM Report to excel with sum fields
Hi I created a custom report for CRM in SSRS. within this report I have some number (decimal) fields that are summed. I need to be able to export this report to Excel to allow for changes (some times the user needs to make custom changes to the data) but I need the sum fields on the group to actually be a formula field so that it is u...
How do I make it possible for SSRS 2008 reports to be viewed by everyone on the web without logging in?
I have SSRS setup and working fine. I can even access them from a web browser. The only problem is that it requires me to log in every time I want to review a report. I need anonymous users to be able to view these reports. Is this possible? ...
How to use WebService of SQL Server 2008 Reporting Services
I created a report and published it to the Report Server 2008 that worked fine. I can call http://servername:81/Reports in my browser and view and export the reports. What I want to do now is write an application that uses the report to create a Excel file out of it. According to the Reporting Services Configuration Manager the WebServi...
How to create and retrieve a snapshot programmatically using SSRS?
I'm trying to create a snapshot and pull it back out later programmatically. I have the first part working (shown below) but I can't seem to find a way to pull this same snapshot back out later based on some unique identifier ... Dim rs As ReportingService2005.ReportingService2005 = New ReportingService2005.ReportingService2005() rs.C...