The requierment is tyo have a dynamic report, that has a table with number of columns decided on the input from recordset. The SQL procedure takes in parameters and returns recordset, that can have varying number of columns. All we want to do is to link this recordset to a table on the repo...more >>

I know a lot of people were trying to open links from reports into new window. I know about a rc: commands and its limitation to open ALL links into a new window. I think I have a solution. If you want a particular link to be opened in a new window, enter this into the "Jump to URL" field: ...more >>

I am using form authentication to login into report service. When I execute a report, the following error is displayed: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'DAISYS'. (rsErrorOpeningConnection) Get ...more >>

Hello, I would like to get some feedback from the users/customers of SQL Server Reporting Services and other reporting technologies on common customization requirements for reports. Let's assume that you have purchased a customizable business/ERP application from an Independent Solutio...more >>

I have an error when i use an expression like this one Sum(IIF(Fields!Flag.Value=0,(Fields!Qte.Value*Fields!Price.Value),0)) I have no error whith this one Sum(IIF(Fields!Flag.Value=0,(Fields!Qte.Value),0)) I try with a calculated Field like ML=(Fields!Qte.Value*Fields!Price.Value) and Sum(II...more >>

I have a shared datasource already installed on the ReportServer. Later I want to deploy reports that use that datasource. The reports are created with a shared datasource which is not the same as the one deployed. How can I specify the datasource programatically when I am deploying the re...more >>

Hi, Can I use SQL Reporting Services with Visual basic 6 or will I need to write a lot of plumbing code? ...more >>

I have a web application which invokes MS reporting service, gets the result of a render call and writes the result out to the Response object. Everything is fine except when the rendered format is html and the report contains an ‘External’ image (image in Report Project) - here the browse...more >>

I'm building a simple report request page that makes use of the reportviewer found in the samples. From the web server that hosts this page, I'd like to impersonate a user to gain access to RS running on another server. I've not been able to find instructions how how to do this. It appears th...more >>

Two export issues. I suspect they are known issues, but I figure it's worth posting. My report is a very simple matrix. 1) Exporting to PDF results in lots of blank pages. This one has been discussed here before. The old 'group it in a rectangle' trick doesn't seem to help. 2) Export...more >>

I want to render a PDF report and view the copy of the report in the HTML viewer. What I did is to use rs.Render(...) to get the PDF report and the SessionID, and then pass the SessionID to the URL string and run the URL. But the rs:SessionID=xxxxx command does not work, it alway create a new se...more >>

Hello, In my report application, I had to remove anonymous authentication and set integrated windows authentication in IIS manager, in this case, http://localhost/ReportServer?%2fReport+Project1% 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098- 4b71-8511-c7e08926c50a works fi...more >>

Unable to send e-mail to outside smtp addresses. Local domain smtp address work. PremittedHosts has no value. The following error is generated: ReportingServicesService!emailextension!4558!08/26/2004- 11:50:03:: Error sending mail, CDO error -2147220977, will not resend ReportingServicesS...more >>

I am new at RS so be patient. I created some reports on my PC (windows xp sp1). I have SQL Server 2000 installed and the reports are at http://localhost/reports . The reports on my pc were just for testing and I don't care about preserving them or the database on my PC. Now I want to start m...more >>

Hi, I have problem with denying access to reports to some windows domain users. I gave "Browser" role to windows "Domain Users" group in the home directory level. Now all users of the windows domain can view all the reports. I want to deny access permission for certain reports ...more >>

I uninstalled Reporting Services SP1 from the development environment. My Database is on a distant Server. I want to re-install Reporting Service and I have this message when I select my Report Server Database (the same as before the uninstal) : "The Report Server Database is a different versi...more >>

Greetings. I found an odd issue when working with a series style in a line chart in SP1. I was using my own function to determine the color of the series. So I entered =Code.PickColor(Fields!ResultSort.Value) for the formula. My code is this: Public Function PickColor(iResultSort As Intege...more >>

I am getting following error when trying to load the Report Manager: The underlying connection was closed: Unable to connect to the remote server. This appears to be related to using SSL. If I point the config files (RSReportServer.config & RSWebApplication.config) to http instead https ...more >>

I have a report server: DEV05 I have a web/data server: DEV14. It also has a SQL Server Database for data to be displayed. I have my pc: DEV01 IIS on the Report Server: Reports – anonymous is disabled ReportServer – anonymous is disabled On the web server I have a virtual directory ...more >>

Hello, I have a matrix on a report with an underlying data set of 15 fields. When the report viewer exports to HTML with Office Web components, they can only access fields that have been added to the matrix layout. Is there a way to make all fields of the underlying dataset available to th...more >>

After formatting the report and making it look like I want too in the Preview window of Visual Studio. I deploy the report to the web server and when I open it - the web rendering (formatting) does not duplicate what I see in the Preview window. It looks like it's adding extra rows between the o...more >>

We are implementing toggle items (twistie: +) for some rows in our reports. We would like to know if there is an expand/collapse all functionality that we can use, to basically expand or collapse all twisties on click? Please advice. Thanks in advance....more >>

Hi !! I want to create a scheduled delivery, with email & file share used together with a single execution on a report. This means that i will sent the report attachment thru an email to the recipient, and the same time copy that report using the file share in a folder. Is this possible to ...more >>

there are times i realize why people are resistant to .net... in vb6, i can use: format$(fields!phonenumber,"(###) ###-####") in vbnet: 1 - problem: no support for string formatting, only numbers compensate: use csng result: format(csng(fields!phonenumber),"(###) ###-####") 2 - new pro...more >>

The requierment is tyo have a dynamic report, that has a table with number of columns decided on the input from recordset. The SQL procedure takes in parameters and returns recordset, that can have varying number of columns. All we want to do is to link this recordset to a table on the repo...more >>