I have a report that has to show values in the Report Header section. This is solved by creating parameters that gets the values from a dataset. But I can't hide these parameters from the user. If I leave the promt field empty it will become read only, but not hidden. Is there a way of hi...more >>

Has someone encountered this issue when reports are run from ORACLE datasource I can view the reports fine in VS.net designer but when I try to view it from RS Manager I get this erro ------------------------------------------------------------------------------------ An error has occurred duri...more >>

I have a table connected to a dataset. In this table I have a column that is being calculated. I need to know how to get the sum of this column. Is it possible to get the sum of a field specified in a group. Thanks, Prashant ...more >>

My users are complaining that the Excel files they are getting back from the web application's rendering of reports in Excel mode are not true Excel, but rather still retain HTML. Has anyone else experienced this? I have included my rendering code snippet below: -------------------------...more >>

Hi all, I´m just beginning using the reporting services, my webapp is working, but I have one problem: In my database there are text-fields containing HTML-Tags. In Output of the report the HTML-Tags are rendered as text, f.e. title<br><a href="...">device</a> is rendered as title&lt;b...more >>

How can I change the deployment folder in a Visual Studio Solution?. I understood it is not possible to deploy to a different folders, is that correct?. Thanks...more >>

Hello, i've installed Reporting Services on "Windows 2000 Server" and "SQL Server 2000 SP3a". During the setup a window popped up with the "System Check Results" showing a warning that "Visual Studio .net 2003" is not installed. I've continued the setup process without any other warnings. Th...more >>

I the Reporting Services Server will be accessed from the web, what kind of licensing do I need on the server? and if the Reporting Services Server will be accessed from the intranet, what kind of licensing do I need on the server? ...more >>

Can anyone help me to see how I can enable the user to select which field they wish to sort on in a report based on a list. I have added a report parameter with the Values as the Field Name (do they have to be in the format Fields!FieldName) and then on my list item I have set the Sort on t...more >>

I'm trying to design a report that takes a parameter, but will show all if nothing is selected. I've tried the following: SELECT * FROM Customers WHERE CustomerID LIKE '%' + @ID + '%' Works great in the data view - asks for the param value - if I leave it empty, it pulls all data. Howe...more >>

hello I am trying to use the reportviewer control in a custom web app. Currently using a frame based design where I have a treeview of all the reports available and a click on the individual report should open the reportviewer control in another frame. Currently facing issues passing the exact U...more >>

I'm a bit confused, what is the point of TIFF format? When I export to TIFF on an 18 page report I get an image of the first page???...more >>

Hi - Some of you may be considering installing a recent hotfix for ASP.NET that was announced this month by Microsoft. I would like to warn users that it will break certain functionality within Reporting Services. The specific thing that happens is that you get an error message when you click on...more >>

Lets say I have very simple report like "Select * from Clients where ClientID IN (@ID)". With @ID as the parameter being sent to the report, how can I make it accept multiple values like 1,2,3,4. If I define the @ID parameter as Integer, it will delete 1,2,3,4. If I define the parameter as s...more >>

I want to add a horizontal bar chart to each line of my results: Question Choice Percentage Chart 1 Yes %75 |||||||||| | 2 No %25 |||| | Is there a way to do thi...more >>

As an MSDN subscriber, I though I was supposed to get a guaranteed response here. I am reposting this since no one responded to my 1st inquiry. Out of the blue this morning our Report Server stopped working with the following error: Configuration Error ..... Parser Error Message: Security ...more >>

I have a simple report taht has no groups and contains a few iif's here and there to colorize a few strings. I set up a border at the bottom of my detail row, it's a 1pt solid border. When i render to pdf, it seems that some lines are doubled and some others not. I double checked my data so...more >>

I built a one page report in reporting services with multiple tables. The tables are layed out in a 2 column format. Here's the scenario: I have tables in the left and right columns. Let's say table A in the right column is just above table B in the left column. The top of table B is just ...more >>

I have a proc that combines the results from 2 queries. I can see all of the data in QA and the Data tab of SRS there are no issues with that part. When I preview the report only the second part shows up, nothing from the first query. I have started over a few times, still the same problem....more >>

Hi, I am using form authentiacation. everything is o.k with ReportServer browser i am able to loging on and running the reports. But when i am using the same username and password at the time of producing reports to ReporServer it is not working. why it is happenning?where i did mistake ...more >>

I have a report that is currently using RowNumber(Nothing) to show the rank of the sales reps. I'd like to modify it so that if two (or more) of the reps have the same value the get the same ranking. Example Rank Calls 1 27 2 25 2 25 4 20 ...more >>

when I'm defining a dataset based on stored procedure I type in the name of my stored proc and hit the ! then define query parameters comes up. My stored proc has default values defined for the parameter. Why not have the define query parameters fill in those default values? It's really ...more >>

Hello, I am wondering why I am receiving an "Error impersonating user" error when I am creating a subscription that schedules, executes, and renders a report to a file share that I have Modify, Read & Execute, Read, and Write permissions to through a user group that I am a part of. When I e...more >>

Hi, we wrote an assembly (DLL), which is called on the OnInit() event of reporting services. One parameter of the called procedure "Report_ID". The report_id has to filled dynamically via SQL and has default SQL based value. That works fine within the report but using this parameter within ...more >>

Hi all, I want to execute a stored procedure from a report. The stored procedure takes nvarchar(50) parameters. When I call the procedure from a report with string paramerers, I get the error 'Implicit conversion from data type sql_variant to varchar is not allowed'. But, I cannot Cast or C...more >>

Tengo un server con windows 2000 server version 5.00.2195 service pack4. En el mismo tengo instalado el sql server 2000 y el analisis services con cubos creados. Instale reporting services y al terminar trato de probar la conexion me conecto desde el mismo server 2k con localhost/reports y me ...more >>

I am trying to run an HTML file from the Report Manager interface. It is an HTML file with a flash file built into it. The interface lets me upload the HTML file, but when I try to open it from Report Manager the web page just looks like it's trying to render a blank page indefinitely. I...more >>

Hello, I apologize if this question has already been asked but I am still learning the ins and outs of SQL Server 2000 Reporting Services through books, this newsgroup, and just experimentation. The report I am working with takes one parameter value currently to execute the report. I am ...more >>

Hi, I was jsut wondering if CASE can be used for an expression of a text box. For example, I tried using this: =CASE Fields!workremotely.Value WHEN 0 THEN "NO" ELSE "Yes" END But I keep getting errors. Is this possible and if so, can somebody modify the above statement to show me ho...more >>

Hi all, I've notice that the page break at start isn't working for the first page of my reports. However subsequence pages are working perfectly. I'm taking the SampleReports provided by Reporting Services as an example since I followed closely to this report. The report I'm using i...more >>

We have two sites and whenever the firewall that handles our VPN between buildings goes down the RS subscription reports always fail. The firewall that handles the VPN also handles sending data out over the net. Now whenever the firewall fails any subscribed reports fail. The email addres...more >>

Hi, we are using an SMTP Server, which just works fine with other applications. But if we try to send reports by e-mail, using the standard e-mail subscription of report manager, we get this message: "Failure sending mail: The message could not be sent to the SMTP server. The transport err...more >>