I have a field in my SSRS report, that contains a string of numbers delimited with commas (from a coalesce select in sql). It looks like 12, 91, 160, 171, 223. I would like to change the text color of only ONE specific value (160 for example) in the field, IF the value is also in another field of the report. I already have this for an...
I have an app that executes and displays reports from SSRS retrieved through URL Access (http://msdn.microsoft.com/en-us/library/ms153586.aspx) Unfortunately, one of these reports is HUGE, resulting in a lot of generated HTML, causing the WebClient to timeout during the call, or the browser to choke on the amount of HTML coming back. I...
Hi By mistake I deployed wrong version of a RDL file on the ReportServer. This overwrote the existing RDL file (the correct one). Is there any way to retrieve the earlier version of the RDL? Note: No backup of the database is available. Thanks. ...
I'm using Microsoft Reporting Services (SSRS) 2008 with an Extended Datareader/Dataset Provider (i.e. using a Datareader that I wrote myself and integrated it in SSRS). Everytime I have an update (i.e. copy the new binary files to the bin folder in SSRS), I manually have to restart the service. I saw in IIS that the mechanism used in SS...
I am having a problem with SSRS 2008 reports that have fixed column headers. Whenever a report has these fixed column headers and also has rows that get expanded, the row that gets expanded jumps underneath the header. The Row would be moving to the correct place if the header wasn't there but because the header is there the row that get...
Hi everyone, I'm trying to handle the OnDrillthrough event for the ASP .Net Report Viewer control using JavaScript rather than in C# code behind. I've tried lots of different methods so far including adding a attribute in code behind: mainReport.Attributes.Add("drillthrough", "mainReportDrillthrough()'"); Also tried using the $addHa...
SSRS parameters are a pain. I want to be able to re-use reports for many different needs by allowing the users access to many different parameters and making them optional. So, if I start out with code such as: Select * from mytable myt where myt.date between '1/1/2010' and '12/31/2010' and year(myt.date) = '2010' and myt.partnumber ...
Hello all, I have a single server that hosts our production and development databases. It's running SQL Server 2008 (not R2) with SQL Server Reporting Services. I deploy a VS 2008 Reporting Services project to the server to provide the reports. All the reports use a single shared data source, currently pointing at the production databa...
Hi, I have a few SSRS reports running on SQL Server 2008 Web Edition SP1 on my production web server. For some reason, CSV and XML export is not offered to me when viewing my reports in the report viewer. This applies to all reports on that server. As you can see, PDF, Word and Excel still work fine, it's just XML and CSV that are mi...
I have an SSRS report, the layout based on an Excel spreadsheet. Therefore, I have a lot of drawn lines and rectangles to mimic what Excel would print. I also have two images that are loaded from fields in the database, if they exist for the record. If the images are displayed, I have several lines missing from the report. If the dat...
Can I use expressions in Sql Server Reporting services to combine all of the values of a column within a group? I'm trying to accomplish what MySQL's group_concat function does, but in the report (not in the query). Example. I want to make this data: Group 1 Value Test A B Test 2 C D Look this t...
I want a parameter to load available values from a query (or whatever) and "allow multiple values." When I do so the list begins with "Select All." That's great, but there appears to be no way to default the parameter to "Select All" which is not acceptable in my case. This particular report will have 8 optional parameters and if htey ...
In my project I am already having a number of reports and also new reports are being created. Now I need to apply a common Footer (with page number, total page number, user name, report name and execution time) for all these reports. This footer has to be in such as way that we can modify it anytime (at a single place) and all the report...
I try to create standardized SQL scripts for use in my SSRS reports. If I wish to have a statement such as: Select * from mytable and use a SQL Variable (SSRS parameter) in the where clause, is there any speed advantage to using this: Where field = @MyField VS. Where field IN (@MyField) I know the second option supports both mu...
I have an SSRS report that I need refreshed each time I preview it. I have set the properties AutoRefresh to 120, but it still will not refresh. Is there code I need to add to the report rdl, if yes what would that be. Your expertise is greatly appreciated. ...
I need to set up this question a moment. Let's say you've created a database called ParameterTesting and created a table and populated it like so: IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'StarWars' AND TABLE_SCHEMA = 'dbo') BEGIN DROP TABLE dbo.StarWars PRINT 'Dropped Star...
Hello I am trying to consume ssrs service and render a report. first stage: I added aservice reference to ../myserver/reportserver/reportservice.asmx went well ,and a proxy was created named ReportingService; the only instance i was able to call was "ReportingServiceSoapClient" but it does not contain a "Credentials" property, instea...
Please consider the following scripts. Create Table: IF OBJECT_ID('Colortable') IS NOT NULL DROP TABLE ColorTable CREATE TABLE Colortable (Color VARCHAR(32)) GO Insert some values: SET NOCOUNT ON INSERT Colortable SELECT 'red' INSERT Colortable SELECT 'orange' INSERT Colortable SELECT 'blue' INSERT Colortable SELEC...
Is there a simple way to view the SQL Queries actually generated by SSRS other than running profile traces to capture them? Is there some way from within the BIDS editor to see this? ...
Using SSRS (2008) what is the best way you have found to handle null or empty values and replace them with something else to display. The quite obvious solutions is =IIF(IsNothing(Fields!MyField.Value),"NA",Fields!MyFields.Value) That works though it is tedious, my hope was to find something like an EmptyText property on the textbox b...