reporting-services

Question about Reporting and Data Warehousing Software bundled with SQL Server 2005

We currently use SQL Server 2005 Enterprise for our fairly large application, that has its roots in pre SQL Server 7.0. The tables are normalized and designed mainly for the application. The developers for the most part have the legacy SQL Server mindset. Only using the part of TSQL that existed back in 7.0, not using any of the new f...

How do you search between two columns using a parameter and a case when statement? SQL Server

I would like to search between to columns in a s query or a table depending on the variable on a paramenter e.g Declare @SelectAll as interger Set @SelectAll = 1 Declare @Column as interger Select mt.Column1, mtColumn2 From MyTable as mt Where Case When @SelectAll = 1 Then mt.Column1 IN(@Column) and mt.Column2 (' Selecting...

Reporting Services Error "Could not load file or assembly 'Spring.Web' or one of its dependencies"

Hi, After installing and configuring Reporting Services on a virtual site with a ASP.NET MVC running on the root folder, I get this "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 ap...

Reporting Services 2010 RDLC: Passing Querystring Parameters from an RDLC

I'm trying to build a simple RDLC report that shows some data, and has a 'select' link that sends the browser off to a certain url with some data in the querystring (a key). In the vs2010 report designer, I can double-click on the column, then select action, and there are a bunch of thigns that seem like they might work. But none of th...

SSRS 2005 concat values in dropdown parameter

Hi All, I have a dataset which I want to use as a parameter for my chart in SSRS. The puzzle that I am trying to solve is as below. My DataSet has 4 columns and in the Dropdown parameter I can only specify label and value. I am not able to specify two columns as Label and two columns as value. Does anyone know how to concat the values...

ASP.NET Session does not timeout on using ReportViewer Control.

Hi, We are using the ReportViewer control to display SSRS reports in our ASP.NET application. On pages where we use the ReportViewer control the session does not time out. The reason for this is the ReportViewer control emits a "setTimeOut" javascript function which reads the Session timeout value from the web.config and pings the serve...

How to handle when SSRS does not automatically update fields based on database query?

So I am trying to change the number of fields in my dataset in SSRS and the refresh button is not picking up the added field from the SQL server. The query is definitely returning the correct data, as I have double checked in the server engine itself. Also, I have tried manually adding the field using the SSRS menu, but as soon as I exec...

SSRS and two different parameter issue

Hi, I have two parameters using two different datasets. One is where you select a Sales Rep and one is where you select Account Manager to show their sales. I want to show all records that match the Sales Rep or Account Manager that are selected. Some are Sales Rep are also in the Account Manager list. Is there a way to make sure if...

Custom ordering of series field for stacked chart in SSRS08 TFS

Hi all--I'm having some issues with a report I'm trying to create for TFS work items that creates a stacked chart based on work item state and the cumulative count. I have Sum(Cumulative_Count) as the data field, System_State as the series field and Date as the category field. The problem I'm having is that for this stacked chart to be ...

SSRS 2005 - Running Group Count

How do you you display the running GROUP count via SSRS 2005? I have a report that has n groups where the source data must remain anonymous and I want that number in the header of the group... So instead of the name in the group header like such... Employee - John Smith Employee - Mary Swain ... Employee - Ahmad Sal I want... Employee...

SSRS - Page break problems

The structure of report is like Main table Row 1 - Another table with master data (sort of header) Row 2 - Split into two sections : 1st section has 4 columns, second section is a table. Row 3 - Detail Table Row 4 - Kinda footer. Now there are no page breaks anywhere. Somehow after Row 2 in some records there is a page break. The ...

Reporting Services Exporting Problems

I'm working on a Microsoft Dynamics CRM Quote with a separate header report and sub report. The sub-report has a detail grid of what is quote, a terms and conditions statement which amounts to a large block of text, and other items. When the report shows on screen, the Quote looks just like I intended. However, when I export to Word ...

How to display PDF report inline in browser when viewing report from reporting services?

When create a report and deploy it on reporting service, I can access it with folloing url as PDF: http://localhost:81/reportserver?/MyReports/Report1&rs:Command=Render&rs:Format=PDF It is fine but it will give you a download dialog window and the open the PDF report by Adobe reader seperately and leave the browser window empty...

How to view soap request based on webservice url?

I need to call SSRS Report WebService using jQuery ajax request. Since the ssrs webservice is SOAP based and considering the example shown for "calling share point web services using jquery" I think I need to pass a soap envelope. Based on the ssrs webservice url how can i find out the soap envelope required by a particular method? (ex...

Reporting Services Textbox Format Question

Good Day, I am creating a report with Reporting Services and am using several text boxes horizontally aligned next to each other. I would like to put periods so that report looks like: 1234 Robert Jones................... (234) 921-4922 1235 Jennifer Wilson................ (919) 582-2914 Is this possible to right-pad the text box w...

Why isn't my iif statement evaluating true when the condition is correct?

This is my statement: iif(sum(Fields!myfield1.Value) = 0, 0, sum(Fields!myField2.Value)/sum(Fields!myField1.Value)) Any suggestions? ...

SSRS 2008 - How to hide the plus icon in a group visibility toggle cell

I have a report that shows or hides columns in a group based on a header cell. SSRS makes this pretty easy and is kind enough to place a little plus/minus icon in the toggling cell. I want to HIDE this plus/minus icon when there is only one column of data in the subgroup, because it shows that one column by default so expanding the gro...

Comparison of ASP.Net Reporting Solutions

This week my team spent way too much time trying to do simple things in reporting services, and I've decided to start evaluating other options. I know there are some good options out there now that aren't too expensive. I've heard that Telerik, ActiveReports, and a few others are widely used. I was hoping to get some first hand accoun...

Import data from an SSRS report via SSIS package

First, I ask that you not ask 'why.' In the famous words of Tennyson "Ours is not to reason why. Ours is but to do and die." It's one of those, "This is what you have, deal with it." situations. The source data comes from SSRS report. The goal is to load the data into a database via SSIS. The hopeful goal is to avoid human interventi...

Reporting Services - SQL query takes 10 times as long, 100% cpu, when in a stored procedure vs inline SQL

I have a SQL query - fairly complex, but not too bad. When I run the SQL query in Management Studio, the query runs in about 10 seconds or less. When I put the SQL query directly into a reporting services report, the query runs in about 10 seconds or less. When I put the exact same SQL query into a stored procedure, and cal...