Hi All, I know that the only stupid question is the one that you don't ask ... but even so this could be borderline :) Is it possible to install SSRS 2008 [stand alone] on a site that has SQL server 2005 installed. I know that you can store the SSRS 2008 Report and Temp databases on SQL Server 2005 [With some restrictions based on th...
HI, Can you upload a file as part of sql server reporting service 2008 parameter? I would like to be able to upload a text file list contract ids and produce a report based on those contracts. e.g for these 100 contracts what date were they entered into the system. I could have a parameter field which takes a list of comma separated ...
Below is my SQL query used in SSRS report SELECT Claimname,CONVERT(VARCHAR,ClaimResponsedate,101) FROM Claim WHERE DataSourceID = 100011 From the above query 'ClaimResponsedate' may get NULL values but in SSRS report for this field displaying 1/1/1990 when the value comes as NULL. I need to display empty value in report if the date va...
Hi I'm very new to SSRS. Just try to generate a chart using some values. It is working fine but along with chart values one extra column displayed in the chart. How to restrict that? Please find the below image. In that I dont want to show 13. Just I want to generate a chart upto 12 only. Hope you understand Thank you ...
I want to design a report with new SSRS feature called tablix, but it seems I've previous version of SSRS installed because instead of tablices there matrices, tables and lists. Where can I get a newer version of SSRS? (I've already googled all over the web but have found nothing) Installed prerequisites: Microsoft SQL Server 2008 (S...
We are using SQL Server Reporting Services 2008 to build reports. We're accessing the reports trough the Webservice (ReportExecution2005.asmx), render them to html to embed them in an aspx page. Everything works quite well. Only on the computer of one developer images aren't rendering. When copying the url of the image and pasting it i...
I have a simple report in SSRS 2008 that lists employee name and their department. table emps ( PersonFullName VARCHAR2(64 Byte) Dept INT(4 Byte) ShiftStartDTM DATE ) I made very simple report to display this data ordered by shift start time. However now I need to make a another version of the report for departmental man...
How do I add a subtotal to a matrix in reporting services 2008? If I right click on a cell I see an option to add a total but no subtotal. (I feel like I'm missing something obvious but I've looked everywhere.) ...
Hi, I would like some guidance on what is the best approach for storing the Report SQL definitions for SSRS 2008 reports. [Our web app will interface with the SSRS web service and display the reports in the VS ReportViewer control] Currently I see 3 options Store the SQL within the RDL [Report Definition] files. Store the SQL in Sto...
We have SSRS running in integration mode inside of sharepoint. When developing SSRS reports we are able to set the date and number formats to recognize regional settings and format appropriately. But when the report is deployed to SSRS the regional formats all revert back to us. Is there a way to have this display properly inside of S...
I'm getting blank page when I open the Report Manager: I've got a header - "...Reporting... HOME", and then just empty space. I'm on SQL 2008 and Windows Server 2008 R2 Standard. Any ideas how to fix? I've confirmed that I am logged in as a local administrator. I tried adding the URL to trusted sites but that didn't seem to help eith...
I have a report in SSRS that contains 12 subreports. After each subreport, I need to insert a page break so that each subreport starts on a new page and doesn't share pages with the other subreports. Does anyone know how to do this? Thanks ...
In SQL Server 2008 R2 Reporting Services, we are developing our own custom data processing extension, using IDbConnection and friends, and we plan to add our own custom query designer, using IQueryDesigner. That all works fine, so far. However, we want to enable the use of the connection string "Edit..." button on the Data Source and S...
Hi, I have a web page accessing the SSRS web service and I have some sample reports created. These reports have some datetime parameters with Available Values specified i.e. 17/07/2009 Report Manager runs the reports perfectly. When I access the report in my web page and retrieve the parameters the available values for the datetime p...
This is my scenario: Database: SQL Server 10.50 and SSRS 2008 R2 App: I'm doing an ASP.NET application using ReportViewer component. The web app is developed on Visual Studio 2010. When i try to print the reports using the development server there's no issue. Once i do a deployment on the qa server, enter the site and click over the ...
Right now I have a project called reports with several reports. In solution explorer it looks like this: Shared Data Sources -- DEV Reports -- Report1 -- Report2 -- Report3 I want to make it look like this and have the same structure carry over to the report manager website when I click deploy. Shared Data Sources -- DEV Folder...
I am trying to find out how to set the chart series group base on a parameter value. Like the total enrollment line chart by Location if the user select location or by course if the user select course from a parameter list. Somebody mentioned using expression in the series property, but I can't get it work yet. Appreciate any help! ...
Is it possible? and how do you do it? Im using vs2008 report designer. Thanks!! MICROSOFT seems to say no...Darn Them... get your stuff together!! ...
I've looked through several other questions here and on other sites regarding this issue, and none of them have solved the problem I'm running into. Hopefully I'm just overlooking something simple. The scenario that I'm running into involves a new installation of SSRS 2008 on Windows Server 2008 R2. After finishing the installation, I...
I have a complex parameter to a web method in my .NET web service, and I want to query that web method with Report Builder 2.0 using SOAP. With soapUI, I get the following SOAP request for that web method: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:qcr="MyNamespace"> <soapenv:Header/> <soape...