I get "A drawing error occurred." error message opening a report that was exported to PDF using the ReportViewer control in VS 2005 on a web page. The report displays fine in the browser. I think I've narrowed it down to certain PNG images in the report but not all. Is there a known problem wi...more >>

Hi I want to know how can i customize browser setting in Reporting services 2000.I wish to show name of my report on browser.I don`t want to show it as Report parameter.It should be text , just name of the report.How is this feasible? can it be done by changing report container, if yes th...more >>

When attempting to run Report Builder I get error below. After reading earlier posts I have tried several combinations on the File Security properties of the 6 Report Builder files and seem to get the furthest (I get the Application Run - Security Warning dialog) while enabling Anonymous ac...more >>

I have set up an installation of Reporting Services on a WIndows 2003 (Standard) server. I've applied sp1 and the cumulative hotfix. The Reporting Services service runs under a domain (admin) account. I can connect to the server and deploy reports, however when I run a report I get this err...more >>

1. No, hosting the file on a web/ftp server is not possible. 2. Yes I know about the Jump-to-URL section. 3. Only http. https, ftp, mailto and news work. file does not. 4. Embedding Javascript (window.open('file://foo/bar.txt')) works, but only if hardcoded, which is useless. Is there a ...more >>

I am playing around with RS 2005, and when I generated a report, the field list is not there and is replaced by a "Server Explorer". The only way I can find to add a column from my query is to add a text box, right mouse click and select expression, and then select the field I want from the e...more >>

I have a report that has a parameter for each agency that I deal with (500 total agencies). I was just told that I have to run this report for each of the 500 agencies and export the results to a PDF file or files. After getting back up on my chair, I started to research how I may automate thi...more >>

I have a client that is using SQL Server 2000 (SP 3a) and Reporting Services (SP2). They tried moving their reporting services solution files to a new server today -- also they are pointing to a new database (Oracle). On their old server everything was working fine. After moving everything ...more >>

Does Reporting Services 2000 have data-driven subscriptions or will I need to upgrade to RS 2005. I would like different employees to pass different parameters by default. I receive the following message in RS 2000 and I'm storing a sql account password so I don't think security is the issue...more >>

Hi, I have a report that accept a due date as a parameter value. That due date value is then passed to a stored procedure that expects a date value. That works fine. Now, the user does not want to always input a due date value, but instead wants the report to query everything that is due a...more >>

Hi, I'm a newbie to Reporting Svcs. My PC has VStudio 2003 and VStudio 2005. I installed Rep Svcs 2000 and created a report with it from VStudio 2003. From VStudio 2005 there's no access to create projects of type Report. The windows end-user application project that needs to display the r...more >>

Maybe I'm just not seeing the obvious... here is my problem: I have a stacked chart, for the point label in the chart I want to show the percent. The value for the chart is just a count of records =count(Fields!Task.value) The problem is, I don't see how I can get a "total count" of all ...more >>

Using SS2000 SP4, VS2003 and RS2000. I copied a report, call it report1 and created a new report, call it report2. When I first looked at the data tab in VS, there was a dataset there from the original report1, call it dataset1. Dataset1 used a different stored procedure. I created a new datas...more >>

Need some guidance on security. My reports are set up for NT Authenticaion - but am not sure how to control the individual reports. For example, only management users should be able to pull up manager reports. ...more >>

I am writing a report to export columns dynamically. The column's Hidden property is controlled by an expression (=Cbool(parameters.hidecol.value)) which works ok in Excel and PDF export. However, whenever I export in CSV, this property is ignored and the column is never exported. Is this a...more >>

I have a query that when executed against the host server, it completes in 11 seconds. When I execute the same query against a linked server it takes 100 seconds to run. I have checked the execution plan for the linked server query and it shows that 100% of the cost is the Remote Query. The...more >>

This is likely very easy, but I'm not sure which direction is the best way to go... Dimension: Time: Date and Hour the record occurred Cube: Has a field that counts the number of times an event occurred in a given hour I want to show a grid that has for each day of the month how many ti...more >>

I installed Reporting Services with CRM 3.0. I opened up the Report site...i.e. http://[website]/reports this opens correctly but when I go to view a report it displays the page display error. It seems like when it generates the report it doesn't send the results to the web site address but ...more >>

We are having problems with SQL 200 Reporting services with large view states being passed to the browser (up to 20Mb). Is there any way of reducing the view state size used by reporting services, or any way of storing view state in a database rather than having it passed to the browser with ...more >>

When running reports inside the Visual Studio IDE the datasources lose the credentials that were previously set up. I use the 'Use a specific user name and password'. Any ideas? ...more >>

Lets see if some of you RS Gurus can help me on this. I have a start_time column that returns the date and time. I have converted these out to return the date for one column and the time (24 hours) in another column. I have a report that I need to group by a 24 hour period that starts at 20...more >>

Here is my situation. I have a group set up in Active Directory for a group of people that will share similar reports. The problem is that there is one report that one particular user in that group doesn't need to see, but everybody else in the group does need to see the report. Right now I...more >>

I am looking for a way to alternate the row color when a value in a column changes. I am using a simple table report. The output of which looks like Application Name Version Usages MicroStation 8.1.2.1 10 MicroStation 8.9.2.1 4 MicroStation ...more >>

Hello Community I've setup a Reporting Server with different reports and users, most of the features work fine. I'm now tring to add a user which is able to modifiy the security roles assignment for his reports. I granted him Content Manager, but I couldn't even access the PropertiesTab from ...more >>

Hi there, I am using SQL 2005, with Reporting Services 2005 and Visual Studio 2005 Team Suite. I have a report which uses 52 parameters to determine which columns are shown. Each of the columns have a value in the visibilty>hidden field of something like '=IIF(Parameters!showname.Value,Fal...more >>

After a long time, I finally got my asp.net application to authenticate with RS 2005.. I have a server with Windows 2003 Server and SQL 2005/RS 2005. I created a user in the domain just for ReportViewer, and granted access in RS 2005. In my project, I implemented IReportServerCredentials l...more >>

Hi On a 2000 platform is it possible to make a parameter field searchable ? So instead of just taking the first letter it should search using what the user enters. For instance when looking for washington entering Was would place the marker on washington ...more >>

installed MS SQL 2005 Express Advanced (with Reporting services). I built a sample report using the wizard. When i click on 'deploy' i get the error as below. There is an application with virtual name as 'ReportServer' in the IIS 5.1 . What could be the possible reasons for this error ? Reg...more >>