I need Help to customise the error message in SSRS
I have SSRS REport accessing from Report Server. Is there any way i can give an error message of my own, if my report is failing to open there. ...
reporting-services
SSRS and Excel color compatibility
Hi, I have SSRS Reports created and rendering in Excel format. I used a custom color(mentioned in excel spec R23,G123,B87) in SSRS. But it shows a different color with the same combination in SSRS. And once I render the report to Excel it shows the color different though I used the same color combination. Why is the color difference i...
How to design good looking reports?
Hi, i'm currently doing some reports for SSRS, and i just confirm what i already knew, i suck at this thing of color matching and making things look pretty. Does anyone know a good site or something to help me figure out how a report should look. I need help! any website or recommendations would be highly appreciated. I tried trying to ...
SQL Reporting Services 2005 - Printing in FireFox
Printing button is not shown in the report toolbar when they are opened in FireFox. Is there any solution for print button not showing in FireFox ? Can it be enabled or there is no workaround for this? ...
Different results exporting to CSV or Excel
I have a simple report that I want to export to a CSV file. There is only the detail line that is grouped by one field, no group header, and a group footer for totals. The problem is when I export to CSV format, the total row for a group is listed in front of every record? If I export to Excel and then save as a CSV file, the total ro...
Display Parameter(Multi-value) in Report
Hi, Can anyone tell me how to display all the selected value of my multi value parameter in SSRS report. When giving parameter.value option it gives error. Thanks in advance. Suni ...
SSRS Report Builder - Issues From Experience?
I'm looking into the idea of rolling out the web-based SSRS Report Builder to our end users to allow them to create their own reports against our production application databases. From what I have seen so far, this tool is easier to use than the VS Biz Intel Studio report designer, plus it is easier to install, and deploying the reports...
SSRS Report , Dynamic selection of fields
Hi, I want to create a report where my report's fields should change according to my input parameter values. eg. if i select '2 months'. there should be 2 fields in result, having month wise calculation. if select '3 weeks'. there should be 3 fileds each for each weeks calculation instead of the 2 months field. How do I achieve...
Unable to track down Report Processing Performance Issue...
We're having a very frustrating problem in our production environment. We have a report that will sometimes return very quickly, and other times not return at all. When the problem is happening, the report will process for 15 minutes or so then the browser will display a "Cannot display webpage" error. This problem is sporadic usually...
How to caculate last business day of month in VBScript
How do I caculate the last business day of month in VBScript. It is for a Reporting Services report. Thanks ...
Reporting Services Interactive Sort and Paging Problem With ReportViewer
I have been having a strange problem with interactive sorting and paging within a ReportViewer that I can't figure out. I am using a local report definition and a ReportViewer control within an aspx page. I have AsynchRendering set to true. Everything seems to work fine except for this problem. Here are the steps to reproduce the pro...
Reset button to the SSRS Report
Hi, Is there any possibility to have a reset button in SSRS parameter window. Thanks in Advance ...
Text Wrapping in SSRS
Hi, How do I accomplish text wrapping of table fields in SSRS Report, and proper landscaping when rendering the report to PDF format Thanks in advance Anna ...
SSRS 2005 Exception not being exposed
We are using SSRS 2005 SP1 and the lastest Reportviewer controls. We are having situations where certain reporting infrastructure exceptions are not being exposed to any of the exception handling routines. A specific example is when the SQL Server Reporting Services Windows service was unexpectantly stopped due to a VM issue. In this ...
Radio buttons in SSRS Report
Hi, How do I add radio buttons as my parameter type in SSRS reports? Thanks in advance, Anna ...
Reporting Services - Percentages in a Matrix
Hi Reporting Services 2000 SP2 I've got a matrix displaying the number of employees Business1 Business2 Business3 StartBefore99 9 14 4 StartAfter99 30 20 34 I'd like to display percentages eg Business1 Business2 Business3 ...
Viewing Word Docs READ ONLY
I have a report reading records out of a DMS system and I thought it would be nice to have a link to the documents that it is listing so that the users could view the actual documents. However when it displays a Word doc it allows you to make changes and then save them, which rather undermines the DMS system. I don't think there is a par...
How can I hide duplicate records (within a crystal report) which have already been reversed?
This question is a follow-up to a question I asked the other day ("Need to find duplicate records but exclude reversed transactions"). I have a Crystal Report which displays customers' fuel transactions. There are occasions when a duplicate transaction will be imported erroneously. If/when this error is discovered, the admin will reve...
Any way to programatically set auto refresh on a report in a ReportViewer?
I know you can set the auto refresh interval in the design of the report itself, but what I am trying to do is allow a user to set/change this interval himself in a web app (ASP.NET) that uses a ReportViewer control. Is there any way to do this? ...
Expand Rectangle Report Item as the Report expands in SSRS
Hi I have a SSRS report. I am using a rectangular to display textbox values in my report header. My data region is having a table which expands according to the input parameter selection. How do i expand my rectangle in length in accordance with the table. Please get me an idea. Thanks in advance, Anna ...