In SQL Reporting Services 2008, can you format a field conditionally? In Crystal Reports it is doable. I have a field which I want to be bold if another field is Y, and unbold if its value is N. ...
I have SSRS report with its own datasets coming straight from the database. I have the report on ASP.NET application page. The application page header has the username and user region details defined in the master page. Now, I want to read this region id label from the ASP.NET page and build my report accordingly. Basically build...
Hi All, I am using SQL Server 2008 for reporting. In that when we export report to excel, the footer image or textbox is not exported. Header image is getting exported successfully. can anybody tell me some solution on it? -Kalpesh ...
I'm using Sql Server Reporting Services (SSRS) 2008 to create RDL files, but also need to create a RDLC file. The problem is that SSRS 2008 uses a 2008 schema, while Visual Studio 2008 uses the 2005 schema. Is there a tool or work around for this solution? Note: I'm not using tablix, so that should not be a problem. ...
I have an ASP.NET page which has report viewer control to access reports from report manager. I need to pass report parameter from this ASP.NET page to the report server. I want to pass region number based on user logged in, which is displayed on a label in ASP.NET page. Thanks. ...
Ok, so i am working on exporting my SSRS 2008 Reports to an image. What I would like to do is Export each individual page as an image. From my code, I can only get it to export the first page of the report. Any help would greatly be appreciated. Dim warnings As Microsoft.Reporting.WebForms.Warning() Dim streamids As String() ...
I am trying to produce SSRS reports to integrate with a MOSS Dashboard. Reporting Services 2005 only seems to be able to render .xls out of the box. Does SSRS 2008 have the ability to render in xlsx format? ...
Whenever I wish to debug a single report (.rdl file, Report Definition file), it always deploys everything in the solution. Can someone recommend a deployment strategy in order that I can localize deployment to the specific report I am working on, and not clobber the other reports in the solution? Those may have been worked on by another...
How do you pass in null parameters into a SQL 2008 Report? The code that interfaces with the ReportExecution & ReportService2005 web services always yields an error upon executing the ReportExecutionService.Render() method, after I set the parameters (not including the nullable one) via invoking the ReportExecutionService.SetExecutionPar...
A report needs to be run on multiple sites, each with its own connection string. These site names and connection strings are stored centrally. I want to make a report that Accepts the site name as a parameter Queries for the sites connection string Uses the sites connection string to get the report's data I've tried using two data ...
I have a chart with these characteristics: chart type is XY (scatter ) all XY data have x-values that are integers; they are called "Update Cycle" numbers. This represents "score" data from a given program. in addition to the values that produce the XY data, I've added two other elements to the "Values:" list: one that is the average ...
In Sql Server Reporting 2008, is there a way to truncate the text if it exceeds the bounds of the width of the textbox? Right now it always wraps to the next line, and even though the textbox diallows its height to stretch vertically, the wraparound is still attempted and it is obvious to the report reader/user. I wish the portion of tex...
I have a Report I'm designing in SQL Reporting Services that has column grouping. Is there a way to specify that each column group should be an alternating color? For example, I'd like column group one have a white background, column group 2 to have a blue background, column group 3 to be back to white, etc. ...
I'm modifying my Report Model in Visual Studio (2008). If I refresh my dsv file (after changes to the underlying database), then manually reflect the same changes in the smdl file, it seems that any time I delete an Attribute from an Entity it somehow corrupts the ReportModel project. Deleting an attribute removes a reference like the f...
In SQL Reporting 2008, Is there a way to merge multiple cells that are adjacent to each other along a vertical column? ...
Sometimes when I execute via the ReportServer/ReportExecution2005.asmx web service the command to render a SQL Server Reporting Services 2008 Report in PDF format, there is no form of Exception thrown, but the resulting .pdf file is corrupt; its percentage is 5969% and when I try to resize it it says: "There was a problem reading this do...
I am starting to learn Reporting Services and I read that it uses SQL Server to store the meta data. I am planning to use it in a WinForm app. Does SSRS require SQL Server to be used in a WinForm app? Can it be self contained like Crystal? ...
I'm using this code in my report, to alternate row colours of grouped rows. http://stackoverflow.com/questions/44376/add-alternating-row-color-to-sql-server-reporting-services-report/83832#83832 It works correctly on my development server (SQL Server 2008 Developer Edition), but not on the live server (SQL Server 2008 Express). Is the...
I'm seeing basically the same issue described here I have a table that starts in the middle of the first page, and, depending on the size of the table, it should wrap onto the next page. This behaves fine when using the viewer, but when exporting to a pdf or tif image, things are displayed differently. Instead of starting on the first p...
Summary: Does anyone know what the minimum we have to do is to get the user to be able to press a button in our app and have the report pop up in an HTML control (Delphi App) with no further input from the user? Detail: Authentication is no longer anything to do with IIS in 2008, and a lot of authentication discussion on the web is abou...