reportingservices-2005

SQL 2005 Reporting Services custom report item (CRI) - what are the limits?

Reading MSDN (and other sources) about custom report items (CRI) for reporting services 2005. It looks like I'm limited to generating a bitmap. Not even with some mapping overlay for detecting mouse clicks on it. Is there away to go around this? There are two things I would like to do: Embed HTML directly into the report, to format dyn...

How do you view SQL Server 2005 Reporting Services reports from ReportViewer Control in DMZ

I want to be able to view a SQL Server 2005 Reporting Services report from an ASP.NET application in a DMZ through a ReportViewer control. The SQLand SSRS server are behind the firewall. ...

3rd party controls for MS SQL 2005 Reporting Services

Can anyone recommend a good 3rd party control(s) for MS SQL 2005 Reporting Services. If you know some open library or implementation of such controls that could be very useful too. ...

How to set sql profiler to profile SQL 2005 reporting services

I'm trying to profile SQL reporting services, used from ASP.NET application. In SQL profiler all the SQL run by ASP.NET shows up. It looks like the reporting SQL (from the RDL) doesn't show. Is there some setting or filter I'm missing? ...

How do I best display CheckBoxes in SQL Server Reporting Services?

One of the many quirks of Reporting Services we've run across is the complete and utter lack of a CheckBox control or even something remotely similar. We have a form that should appear automatically filled out based on information pulled from a database. We have several bit datatype fields. Printing out "True" or "False" just looks si...

Set a table's visibility to false when it has no rows (in reporting services)

Is there a way to set a table's visibility to false, if the table has no rows? I want to hide a table in Reporting Services when it has no rows. Setting NoRows to ="" isn't sufficient in this case as space is still left for the table, and some of the table's formatting is still visible. I'm using Microsoft Visual Studio / SQL Reportin...

How to control the target frame of reporting services (SSRS) drill down

I am using SQL 2005 reporting services (SSRS) with the web report viewer control. It is showing the report inside an IFRAME on the web page. If I implement a drill down functionality, by attaching a URL action to a chart elements, the navigation will happen only inside the IFRAME. I know how to set the target frame for navigation on a no...

Exporting from SSRS to Excel with no headers

Is there a way to export to excel from an SSRS report so that the header that displays on the first page of the report is omitted only in the excel export? Currently, it adds a frozen frame to the top of the worksheet. ...

Rendering SSRS reports from VB.Net

We have a lot of reports on the Intranet that take parameters. All reports are going to be re-built in SSRS. Our goal is to pass all the parameters to the report from the .net application. What would be the easiest and the fastes way to render reports from .NET application? ...

HTTP 400 returned while accessing SQL Server 2005 Reporting Services Report Manager

I have a new SQL 2005 reporting services installation and it doesn't work. Database access works fine. I've setup a new IIS site, set it to run on port 90. It has the two virtual folders - Reports and ReportServer. I can access ReportServer just fine, but Reports (the report manager) throws HTTP 400 error. I've changed the URL in rsre...

SSRS 2005 - How do I find the value of a cell 1 column over and 2 rows up?

I am trying to find the value of a cell 1 column over and 2 rows up using something like excels offset ...

Setting up Windows Authentication In Reporting Services Using Kerberos

Hi, I have yet another problem with Reporting services. Finally I was able to set the ball rolling, achieving success in configuring reporting services with a domain user account. Now I have a problem accessing the server from another machine (in the same domain) using Integrated Windows Authentication in IIS 6.0. I have never had probl...

Using an ASP.NET server control in a sql server 2005 reporting .rdl file

How would I embed a ASP.NET server control on a SQL Server 2005 Reporting file (.rdl)? I am using the design view to accomplish my task? ...

Dimension Security in SSAS & SSRS

I am stuck with a problem of implementing security at dimension level in SSAS. Here is what I did - 1. Defined a role in SSAS and applied security at dimension level (Unchecking cube dimensions that I don't want this role to access and setting Allowed & denied Sets). 2. Tested using Cube Browser, it worked fine. 3. Tested using SSRS, no...

How to use Multiple result sets in Reporting Services

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?...

In SQL Reporting services, is there a way to dynamically hide some parameters (but not all) from users?

Is there a way to have a SQL Reporting Services (2005) dynamically show or hide parameters? For example, if the user is a "power user," show parameters A, B, C, D, but if you're a novice, show only A & B? This isn't a security or "limiting" concern, just an attempt to not overwhelm some users or overly restrict others. Thanks! ...

Report Builder, prompt filter, how to ignore the filter?

Hi, I'm looking at the report builder from 2005. I know I can prompt a filter so the user can filter the data themselves. But what if they don't want that? how can I set the filter optional. so either they see everything or they use the filter. Now I only can have a filtered report. ...

Dual Axis Graphs - Reporting Services 2005

I have a need to output a graph in reporting services 2005 with 2 Y axises. It does not appear that this is possible in RS2005 and I have no idea what options may be available to me. It sounds like RS2008 may solve this issue, but I do not believe that is in the cards for me. What other options might I have? ...

Subtotal error on calculated field in a Reporting Services Matrix

I've got a Reporting Services report that has two row groups: Category and SubCategory. For columns it has LastYearDataA, ThisYearDataA, LastYearDataB, ThisYearDataB. I added two columns (one for A and one for B) to handle an expression calculation (to show a percentage different from LastYear to ThisYear for each). That's working. Th...

Locking SSRS fields in place

We are developing a complex structured report, this report has lots of fields and these fields get populated sometime. when these fields are not populated field placement changes for few fields around that empty field. Is there a way to lock in a field at a particular place. I extract report in PDF. ...