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...
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. ...
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. ...
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? ...
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...
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...
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...
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. ...
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? ...
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...
I am trying to find the value of a cell 1 column over and 2 rows up using something like excels offset ...
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...
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? ...
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...
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?...
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! ...
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. ...
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? ...
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...
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. ...