I have been searching and found the answer to my problems in the XML string sent from the reporting services engine on scheduled jobs. I know I need to add a Noheader command and also change to ASCII. I wondering how do I do this to scheduled jobs with in the reporting services environment...more >>

We have found that post SP2, leading spaces are being stripped off text in reports exported to PDF format. Pre SP2 the export was working fine. i.e. The Text " Product XYZ" was displayed as " Product XYZ" in the PDF output pre SP2. It is now displayed as "Product XYZ". Has anyone e...more >>

Following kb 842425 I successfully and reapeatedly moved a report server database from my laptop to my desktop with little problem. (i.e. backed up dbs, keys on source pc; moved files to destination pc; stopped services; restored dbs; restarted services; ran config utility; applied keys; test...more >>

I 'm calling a web service using this code: ReportingService service = new ReportingService(); service.Credentials = System.Net.CredentialCache.DefaultCredentials; I was getting an "Access Denied" everytime, but it works when I use this code : ReportingService service = new ReportingServ...more >>

When opening an RS folder in IE 6 I get a Detail View and must click "Hide Details" is there a way to make it open in summary instead of detail? Thanks! Glen ...more >>

Hi, I am using SQL reporting services.The problem is that My report generation takes a lot of time. What is the reason for this? I know of 3 reasons : 1. The database is on the data server and report manager is on webserver. 2. There are 2 images in my report which are project images and no...more >>

I have installed RS with SP1. I can send e-mails with reports attached to it, but when I open the attachment I only see garbage, no matter what kind of format I select (excel, pdf, etc.). Any ideas?. Should I change something into the configuration files? Thanks, Daniel ...more >>

I am using RS SP2 with SQL 2k SP4. I have a fairly large report, in the region of a few hundred pages. It has a couple of parameters that filters the data. I have it linked from a web application and it goes directly to PDF. If the parameters are set the report renders to PDF pretty quickly...more >>

I want to force users to export my report into PDF or Excel then print from those applications. So I want to hide the print button on the toolbar. Does anybody know how to hide the print button on the toolbar? Thanks a lot....more >>

Hi, I was wondering how some other organizations had organized their directory structure in report manager? Maybe by subject area, authorization level, by department? Feel free to comment....more >>

Is there a way to programmatically change the Title of a chart? Thanks - G...more >>

It seems like there must be a way to do this basic task. A winform app calls a report, passes the parameters and then outputs that report directly to the printer without user intervention, or browser sessions. I really dont want to go back to Crystal to do this. Thanks, Mike ...more >>

I am creating a report in RS where I need to display "N/A" when the value in the date column is NULL else it should display the date. The date column is being pulled from the database and has datetime datatype. Basically in CR I can write the formula as: if isnull({sp1.Close Date}) then 'N/A...more >>

Hello, There were a couple of posts about this but no answers. I wanted to see if anyone has been able to resolve the "Generic error occurred in GDI+" message when they attempt to preview the report? I'm just trying to create a simple stacked column report. Are help would be greatly a...more >>

I have an oracle query like: Select x, y, indate from mytable where indate BETWEEN to_date(<what goes here>, 'yyyy-mm-dd') AND to_date(<what goes here>, 'yyyy-mm-dd') I have input parameters already created in the proper format that i want the query to use . How do i include them in this...more >>

We want to allow user select what columns of report (we use simple 1-table reports) he wants to see. Is there any way to do it except of generate custom rdl file on each request?...more >>

We send reports via subscription and the attachments are blocked by Mailsweeper saying "Invalid base64". It seems that the server encodes the attachment wrong so it's blocked by mailsweeper. In notepad the "extra" character is visible. I encoded an attachment locally and no extra characters ...more >>

Hello, Hopefully I can explain this clearly. I understand how to sort columns that reference fields in a table. However, I have created a column titled "Total" which basically totals my "QTY" and "COST" field columns. Crystal reports allows you to sort an @TOTAL formula in a column, ...more >>

Hello! Is it possible to store rdl files not in VS project directory? I've created a new project and when I add existing report to it, VS copies this report to the project directory. Thanks....more >>

I'm trying to install the Mom Reporting service, My MOM 2005 (W2k3 w/sp1) server also hosts the sql database (sql2000 w/sp3). While running the install for the reporting services I get this error. Failed to create data source for data warehouse, check to make sure you can access the SQL service...more >>

Hi NG I am not that familiar with RS yet, but it seems to me that the only reasonable Report Designer is Visual Studio. We have the situation that the business will design and maintain (the design of ) the reports on their own. As we don't want to install VS in the business, I am looking for ...more >>

how to set the connection string to connect a csv file with reporting service. TIA. Donald ...more >>