To anybody out there that can help me on this. I'm using report server. I'm using the Render method through a aspx page (C#). When I render to a CSV file, the information from the report is there but also there is extra lines at the bottom that have this below. _________________________________...more >>

i have written a function in report properties, but error returns when i tried to add 1 to a report parameter, saying that parameter.value is read-only. anyways to have editable parameters?? thanks in advance~...more >>

Hi, I created a bar chart in reporting services and I would like to be able to drill down or jump to another report from the chart. Is there a way to do this? Thanks, Manolo...more >>

We are in need of a visualization of all parameters (about 16 of them) for our reports. (When a cutstomer prints a report, we need to have the parameters (mostly filterering input) values available) Is there a way if "looping" the Parameters Collection, creating a String or populate a table...more >>

Is it possible to use an expression to select the dataset which a table should use. ...more >>

Does anyone know if it is possible to pass unnamed parameters to a subreport when using an OLEDB provider (the TeraData provider to be exact) ? If so, does anyone have any links or helpful hints for this effort? Thanks in advance! Tom...more >>

Hello, Here is my query for my report. Can you make this query fetch all rows if @myID parameter is null? SELECT FName, MName, LName, ID FROM MyTable WHERE (ID = @myID) AND (myDate BETWEEN @StartDate AND @EndDate) Thanks, Jim. ...more >>

Hello, I am using ReportViewer control in my asp.net application. It works fine, however is it possible to keep header frozen when I scroll-down? Thanks, Jim. ...more >>

Group, I would like to have a value (basically a scalar from a stored proc) in my header but I keep getting the compile error: 'The value expression for the textbox 'LastSale' refers to a field. Fields cannot be used in page headers or footers.' I tried putting a subreport in the header ...more >>

Can anyone let me know if Reporting Services allows the user to save their reports as their "Favorite" Reports? I know that you could move reports to your "My Reports" folder but was just wondering if you could copy them as your "Favorite" Reports. I guess the other option is to upload the ...more >>

Hi, I've created a bunch of reports locally on my machine, where they all run just fine, but when I try to deploy them to a server I run into some problems. I only have access to the server through a third party remote desktop application (NetOp), so I have to do the deployment by manually...more >>

Hello, I am new in reporting service. How can I create a total line at the bottom of the report. Thanks, Jim. ...more >>

"An error has occurred during report processing. (rsProcessingAborted) Get Online Help. Index was outside the bounds of the array." It seems that we randomly get this error when certin reports are brought up, can't find any consistent reason why? It seems this started after we installed S...more >>

Hi, I need help printing multiple reports using sql 2000 and RS. basically, is something like a search for accounts with balances overdues. So I will get back the accounts, addesses, balances... Now, I would need to create the reports and send them to the printer. I have seen code like: ...more >>

I have created a subscription via Report Manager & would like to launch it via vb code or rs script on any given date or time. That is, even though the subcription may have a set date/time, via CODe I would launch it & modified its date & time as necessary. -- Edgar...more >>

Hi there, Is there any way to add printer icon besides refresh and help icons in Report manager? If not exporting to any other type file, how can we print the report itself in Report Manager when the report has more than one page? Right now it looks like screen print when the report is bigger...more >>

Could you point me in the right direction to samples to create a Subcription? -- Edgar...more >>

Hi there, I have 2 datasets defined in the data section. Dataset1 is a list of customers and their details, Dataset2 returns all the transactions for the list of customers in Dataset1. I would like the report to group by CustomerId, so that on each page of the report, the customer detail...more >>

I have created a report which has dynamic grouping based on parameter selection. e.g. the user selectes student or subject from the parameter drop don box and the report is then grouped accordingly. What I want to do now is have another parameter which is populated based on the first paramet...more >>

(1) We have a report server inside our firewall : UniRS; (2) We have an External web server outsde of the firewall: UniExternal; (3) I use soap web service to render a report AMSMaster (on UniRS) to asp.net page in the UniExternal: The report runs a long stored procedure and sometimes t...more >>

Can anyone recommend a good book on Reporting Services? Thanks, ...more >>

How do I get the sort to sort based on two digits. It is sorting like this: 10 1 2 3 4 How do I get the sort to sort the right way? I have tried the right() but this does nothing? -- Thank You, Leo...more >>

Hi All, It's an urgent help. I want to view the reports using Reporting Web Service API in asp.net applicaton by 1. creating Datasource dyanmially. 2. passing the Datasouce ( Could be new which created above) to existing reporting 3. Creating a dataset 4. Attachiing this to rdl. ...more >>

Our SELECT proc uses a uniqueidentifier as an input parm. Trying to call the proc while creating a dataset yields the error message "Invalid cast from System.String to System.Guid" no matter how we encode the parm value - {Guid}, '{Guid}' or 'Guid'. '{Guid}' works fine in Query Analyzer. ...more >>

Hi there Situration 1.Development Server is on WorkGroup, not main Domain. (win 2003 server(std)) 2.Accessing dev server via \\Main Domain\Administrator 3.SQL 2K (Std) SQL Reporting 1.Using SQL authentication for shared resource, rather win authentication. 2.Shared folder, access set ...more >>

Hi I'm facing a problem when i render a report in HTML format. When i see the report in the preview section of the report designer it is perfect as desired. After deployment, when i export the report in HTML format there are a lot of white spaces inserted vertically. But it doesn't happen when ...more >>

I will like some help please. I created some reports with RS. They were deployed to Report Manager and run well within the office. We have a customer who wants these reports and has a SQL 2000 Server Standard Edition License. What do I have to do to transfer these reports unto the custome...more >>

Hi, I have a problem during installation. I've got the 1603 error. Note that http://support.microsoft.com/?kbid=867872 suggestions didn't help to solve the problem. Quatation from RSMSI** log file: ".... Action 13:57:32: Do_sqlScript. Configuring Microsoft SQL Server Do_sqlScript: Runnin...more >>