Hi I have some unusual problem with e-mail delivery of reports. I need sheduling subscription to daily report for all workers of our company. All these people are members of distribution group in AD named "All workers". I've made subscription and typed in "TO:" field valid e-mail address o...more >>

Hi all, I have a ASP.NET web app installed on a dedicated internet server with an ssl certificate issued to the site. I am utilizing an http handler to automatically switch between http and https between the various pages of the site. The handler is the one from http://www.codeproject.com...more >>

On SQL Reporting Services, Blobs (type = image) do not even get exposed to the report. Note: I am using blobs since I need virtually unlimited text. So, to get the data out of blobs, I normally use ADO methods of getchunk and actualsize. I tried creating a class with the logic that I needed....more >>

Hi all, I need to add a column chart in my report with static values on x-ais like - 10 11-30 31-50 51-70 and >90 is there a way I can do that? Thanks much! Sonal...more >>

I want to give the end user a choice of sorting by one of 5 different fields. In Crystal Reports I: 1. Created a parameter (SortField) with 5 default values. (A, C, N, S, Z) 2. Created a formula (Sort) with If {?SortField} startswith "C" then {BKCMACCT.BKCM_ACCT_CITY} Else If {?S...more >>

I have a report that is pretty simple and includes a table with two groups. A couple of the columns are formatted based on some math. If the value in the column is greater than another columns by a certain percentage, it turns red. If not, it turns black. Pretty basic and vanilla. Works ...more >>

I understand I received this error because of the SQL Server row-size limit, but I'm not sure how to fix it. The report query joins three tables, and brings data from those tables. The problem is each table has a Notes varchar(7800) field. If I comment out all notes field then the query runs fin...more >>

Could someone please tell me how I can show 0 - 100% on Y-axis in line charts. I have been trying Format code of #% but that adds 2 additional zeros like this 20% will be 2000%. Please advise. Also, I am unable to change the series color. I need to add a window outset all around the chart wi...more >>

Hello Group, I am wondering if there is a way to configure a Group within a table which uses a Report Parameter for its Group By. So for example, my table binds to a dataset which has 7 columns and I want the user to be able to choose via a parameter, 1 of the 7 columns to Group By. I fig...more >>

Anyone have any comments on using SoftArtisans ReportWriter that allows Word/Excel users to write reports and publish to Reporting Services? Is it very expensive? is it worth it? ...more >>

Hi NG, if i call a report with http://servername/report everything works fine. If i call the report with http://servername.domain.com/report the report failed because he couldn't find the datasource to the olap-cube. I use win-auth on iis. Any suggests? Frank ...more >>

We have several extensive reports in Excel that I would like to port over to Reporting Services (am in process of testing SQL/RS 2005), if at all possible. From what I understand, the only way to do this is via a third party piece of software, such as OfficeWriterSE for ASP by softartisans.com....more >>

The majority of our users do not have priviliges to install the reports services print dll to their systems. I would like to create a vbscript to do this install and ask our net folks to install it on all clients ( using their domain administrator priviliges) I've found the cabinet file an...more >>

hi I have a running report that has parameter dependencies, ie.: 1st Dropdown = 'USA' 2nd Dropdown = 'California' (depends on 1st Dropdown) 3rd Dropdown = 'Sales Offices' (depends on 2nd Dropdown) etc... I don't seem to be able to take these parameters in a URL so that the interface...more >>

Other posts indicate that Reporting Services has no limit to the size of the query string defining the Data Set in Visual Studio. I am querying MySQL (lots of calculation and conversion statements) and after building and testing the query with another tool, I paste it into the Report Designer...more >>

Hi, I have a report that has loads of rows but only few narrow columns. The preferred way to do the layout would be: Landscape and having two identical tables next to each other. The one on the left would display the first 50 rows or so, the one to the right the next 50. Is that possi...more >>

I have installed SQL Reporting Services and have been trying to implement the Report Pack for SharePoint Portal Server that was recently released. Part of the VERY limited instructions that comes with the Report Pack states that you can import your existing SPS log files using the Data Extract...more >>

Hi, I have created an application with VIsual Studio.NET in C#. I used a webservice in order to view my reports. I want export my report in format that I want with this application. How can I do? What is the solution?...more >>

Hi, I am trying to pass parameters to the report in URL adding &ParameterName=Value.Following is the URL http://rs-xlre-dev/Reports/Pages/Report.aspx?ItemPath=%2fReInsurance%2fDevelopment%2fReport3&rs:Command=Render&Company=34251 If I check Prompt User check box - prompt comes blank waiting for ...more >>

Hi All, I have a small problem when I deploy to the report manager, I get blank pages throughout my report when I go to print. It happens regardless if I print directly from the report manager or if I export to a pdf, excel, ect. I know if you change the margins and the page format that it...more >>