We have a report that runs via the data processing extensions. Running this report from the reporting service interface or via the web is fine. However, we have a requirement for running this report via some very speciifc schedules. To achieve this we are programatically rendering this re...more >>

We have noticed that SQL Reporting Services uses the 'nvarchar' data type for all report parameters of type 'string'. If the actual datatype of the column is 'varchar' this causes (serious) performance problems as SQL Server must convert the 'varchar' column to match the 'nvarchar' parameter. ...more >>

Normally, the report always display like the follow: Department Employee No. Average Salary ----------------------------------------------------------- HR 15 11250 IT 25 15510 Sales 5...more >>

Hi, After playing around with reporting service for a few days, I can see that it's very easy to create dataset and design page styles within the reporting service. Now I have a question, what if a third party company send me a dataset (not belong to reporting service), then I want to pass...more >>

Hello All, I want to open a report in a desktop application, the ReportViewer control works fine on ASP.Net web form but not on the windows form. Can anyone help me here? regards, Atif ...more >>

The mechanism to link a Crystal Report to data is by giving it a System.Data.DataSet, I was wondering if this same option is possible in Reporting Services. -- Sergio Florez M. Miembro activo de www.alianzadev.net Medellín, Colombia. El que persevera insiste!!! ...more >>

Hi all Does anyone know how I can have conditional formatting in my reports? What I want to achieve is something like. If the field text = "Green" make the background green, etc Thanks alot in advance R ...more >>

It seems First is returning the first row returned by the Dataset, not the first row according to the sorting of the dataregion or grouping (as the First function's documentation implies). This ends up with some mysterious results in my reports. I created a simple example using the SQL North...more >>

Hi, I am using custom data processing extension to render a report. The whole process is as follow: Application generates dataset, saves that to XML file, then it calls the report that uses custom data processing extension to read XML file and construct dataset used by reporting services t...more >>

I am trying to implement forms authentication in reporting services and I would like to use the report manager for rendering reports. What I don't want to use is the built-in tools for item level and system level security. Is there a way to get information as to which item is being accessed...more >>

Infrequently I get the following error message when trying to access the report manager. Server Error in '/Reports' Application. -------------------------------------------------------------------------------- Configuration Error Description: An error occurred during the processing of a...more >>

I am having trouble getting my reports to print Landscape. What I want to do is everytime the user exports the report as a pdf the report will view and print landscape. Can someone shed some light on how to accomplish this?...more >>

I am trying to create a popup window from a report. Looked thru some previous posts and generated this string in the "Jump to url:" ="javascript:void(window.open('http://www.yahoo.com', 'popup','location=no,toolbar=no,left=100,top=100,height=600,width=800'))" But when I try to preview ...more >>

Is there a way to allow everyone or the domain users group to have access to reports using the Browser Role but restrict ppl from accessing reports who are in a certain group. I want eveyone in the company by default to have access to reporting resources by default with the exception of memb...more >>

Hello. Here's the scenario: I have two report parameters, both with default values. As I would expect, the report loads automatically in Preview mode. But why, when I try to change either parameter value, it seems to automatically reload the report on simply setting focus to the text box ...more >>

I need to overlay the bar lines on a chart in reporting services. I have actual and budget numbers that need to be displayed, but they need to be overlayed, not side by side as the column chart does by default. Any ideas on how to do this? Thanks, Josh...more >>

I am just starting with Report Services, so this may be an easy or dumb problem but here goes: I am working in Visual Studio with a simple report based on a sproc with several parameters that returns a result set. In the report I have set up a table and the dataset for it, as well as the para...more >>

Is there a way to reset the page margins for all new reports? I would like to reset them to allways be .5". Also is there a way to create a new template? Thanks...more >>

Hello I'm trying to send the reports in Report Manager by mail, but I have always the same message -> "Error sending email. System.Runtime.InteropServices.COMException (0x80040211): The message could not be sent to the SMTP server. The transport error code was 0x800ccc15. The server resp...more >>

I am generating reports using the SOAP Render API and serving the reports on a Web server separate from Reporting Services. I am using "Jump to URL" as a mechanism to implement hyperlinked (drill-through) reports. I would like to specify the report URL's as relative URL's (such as MyDrillThr...more >>

I am actively evaluating third party add-ons to RS. Before I commit myself to shelling out loads of dosh on something like Cizer ..Net Reporting, I'd like to know whether MS are going to put all those features in V2 effectively for free? As I understand it, SQL 2005 is scheduled for release in...more >>

When I deploy a report from MSDE, the description from within the report properties is displayed under the report name/link within the Report Manager. When I modify the report description in MSDE and then re-deploy the report it doesn't update the one I see in Report Manager? I can delet...more >>

Is there anywhere on your website that lists the current bugs/problems identified post SP1 that will be fixed in future SP releases? I think it would be very useful for a lot of RS developers to have a definitive list, rather than scouring around newsgroups to find that the problem we've got ...more >>

I post a report on report server. I open the report from IE browser, after I updated the database and I click REFRESH button on toolbar, report was not refreshed. The only way is that I have to close browser and launch it again and open the report to display refreshed data. Could anyone let...more >>

Is there any word on when the second service pack (SP2) for Reporting Services will be due? I am especially interested in the built-in printing support and I would really like to know when I can expect this. Is it a matter of weeks or months? Thanks. Richard ...more >>

I created an IIF statement... that selects text for display in a textbox... apparently using a colon within a string in an expression is a no no... because I'm given the following error "Colons and line terminators are not valid in expressions." - is there a special character I can use... how ...more >>

Can anyone show me how to navigate to different reports by selecting different parameters. For example if we have two parameters name, Id selecting name should display report 1 and selecting Id should display report 2. Also is is possible to change the grouping a single report when selectin g...more >>

I have a webform with 2 frames. The top frame contains the main report and clicking on one of the fields generates another report. I want this report to open in the bottom frame and not take over the whole window. I am using this in the 'jump to url' section of the text field: ="http:/ServerName/...more >>

Hi, I have the following problem with AD an RS: when creating a group of users as a "domain local group" in AD, i'm able to give a specific item-level role in RS to members of this group. But it looks like rights are not effective for those users. For example if the group is defined as "re...more >>

if I add a field to a table from another datasource it is always in the form Sum(Fields!Field.Value, "datasource") which is the total sum of the values of the datasource even though the datasource is grouped on the same field the table is grouped how can I break this aggregate by the same f...more >>

We have customers in different countries. And we have to provide the report services in different languages. I mean, the interface including the parameters must be in the language of the customer. Does anyone has an idea how to? ...more >>

Hi I am running Yukon Beta 2 but I still don't see how I can define a Multi-select or Multi-value parameter. (I am using an OLAP data source). Many thanks, Pedram...more >>

I am getting following errors more and more often, when trying to sign-in to Report Manager on the server hosting RS: - "provider load failure" - "Cound not read the Report Manager configuration file. Check to ensure your Reporting Services WMI provider is working properly." I don't have a ...more >>

I am still having this problem even after following the suggested solution. Replacing the config files seems to make no change. Any ideas or suggestions? I have installed the developer edition of SQL and reporting services locally on and XP machine with all recommended updates. Thanks Se...more >>

I have encountered a problem in one of my reports. I use multiple datasets, and inside a List I have two matrices, one for my 'income' dataset and one from my 'cost' dataset. The List uses a field from the 'income' dataset as it's 'Details Grouping'. My problem is that even though i explic...more >>

Hi - I'm trying to create a report (viewed through the reportviewer web control) that has the toolbar hidden, but still allows people to export to excel and pdf. Ideally I need to create two asp.net linkbuttons on the web page itself, that will call methods to save the report being viewed thro...more >>