I have a problem to set default value with expression like.. =DateSerial( Year(Now), Month(Now) +1, 0). I try with Today, Globals!ExecutionTime,..but it doesn't work. In preview and on server parameter filed is disabled. If i press View Report then fileld gets correnct value. To view report...more >>

Hello I am returning a int value from a database which is for an elasped time in seconds. I want to convert this to mm:ss, however I dont want it roll over to hours or days. I trying something along the lines of: =String.Format("{0:0:mm:ss}",CDate("0:0:0").AddSeconds(Sum(Fields!Airtime.V...more >>

Hi, Currently I display report in my webform (website) using Reportviewer.ReportURL method which fetch report from Report Manger through Http:// port. which takes too much to rendering report. Is there any method through which I can render report in my webpage through reprot API or something...more >>

I am attempting to install SQL Reporting Services Developer edition on a Windows Server 2003 box with SQL Server 2000 SP3A + Hotfix KB810185. The installation proceeds fine until the very end when it is runing some of the SQL scripts to create the objects in the databases. The databases get cr...more >>

Hi; I am trying to use Printing in browser for reports which are developed in SQL Reporting Services. Now, when I try to print reports using browsers and go to file menu and select Print Preview then it preview all the stuff which I have in browser including that header of report which is...more >>

I have a report that works correctly in interactive mode and fails when I program a subscription. I think it works perfectly until I modified the rsreportserver.config. with the rsconfig.exe utility and I haven't a backup of the file. Any idea? ...more >>

I have a problem on the printing PDF. I use the printer is HP LeasrJet 5000N. And I cannont print the report. The error is the following: Error: limitcheck Offending command: string stack: 173155...more >>

I'm fairly new to XML, but it looks to me like my parameters are not being applied to the Select in the Where clause, but rather sometime later (that I don't see right off). Could this explain why I can't even get a report limited to just over 6k records to complete without an OutOfMemory error...more >>

Does anyone know how to fill in a dropdown in VB6 with the SQL reports that have been deployed? And also, is there a way to group those reports, either by folder or another method?...more >>

I have created and deployed Shared Data Sources two different ways, through Report Manager (New Data Source) and also using Visual Studio .Net (deployed the data source). Now, I want to create a new project in Visual Studio and want to access either of the Data Sources. I select New, Project...more >>

Hi All; I am trying to call report which is desigened and deployed into SQL Reporting Services. I used SQL Server Username and password to created that report in report designer and I deployed that report on report server. Now, I got that URL to access that report in my web application and...more >>

Hi guys , I have a client who has RS Ent edition on 2 machines, an IIS box on another machine all working with SP1 , now when he tries to install RS on another IIS box pointing to one of these report server databases on the other box's he gets the below error, he then tried to install it pointing...more >>

Does anyone know if Microsoft is planning on fixing the HTML 4.0 rendering for Netscape 7.1. I hear they are removing support for Netscape 7.1. Is it going to be fixed in the future? Maybe for SQL 2005. It won't be a surprised if they are not planning on fixing it since it does work in IE an...more >>

Ok, I am attempting to create my first report in SQL Reporting services. I am using SQL Enterprise 2000 sp3, VS.NET 2003, and IIS5. I have created a report that has several columns of general information. One of the columns is "employee_id" This report worked fine up to this point. I then...more >>

Here is the scenario We have a WedServer lets call it blah1.ourdomain.com Then we have Reporting Services running on blah2.ourdomain.com We have a webpage that a user is logged into on blah1.ourdomain.com and it has links to reports on blah2 like http://blah2.ourdomain.com/ReportServer?/So...more >>

We are trying to decide between Reporting Svcs and Charting Controls. If we go Reporting SVcs route, we'll have to use Web Service as we are passing datasets as the datasource and there will be no URL access. It's a fairly complex application using stock and candlestick charts. What are the pr...more >>

I have a report that works perfectly in IE but the iframe doesn't show up at all in Netscape 6, 7, and 7.1 (which Microsoft Reporting Services supports). I've tried everything to get it to show from including ID and NAME attributes in the iframe tag in the ReportViewer component, to setting all ...more >>

I have a two column report. However, in the footer, i'd like to present a column similar too: Total spent: $100 Total left: $1,230 So that the NUMBER values on the right are completely right justified, but the text on the left is actually LEFT justified. Can this type o...more >>

I've designed a report that has 2 pie charts side by side. The report size is 11 x 8.5 (landscape). The pie charts reside in their own respective tables. The problem is that when I preview or save the report as a pdf, the pie charts are elongated or oval shaped. The height/width settings for eac...more >>

I have a Text box containing the following info: ="Effective: " & Parameters!PMStartDate.Value & " to " & Parameters!PMEndDate.Value How do I control the format of the date? I want the Format to be dd/MMM/yyyy....more >>

The Page Header in reports does not repeat data on multiple pages: I have a textbox in the page header which references a bound textbox in the body of the report in order to display the bound data in the Page Header. The only problem is the Page header only displays the data on the page ...more >>

We are receiving the below error when reports are sent using subscriptions Using Adobe Read 6.0, I get the following error "Adobe Reader could not open 'report.pdf' because it is either not a supported file type or because the file has been corrupted Our client is using lotus notes 4.5 se...more >>

I have a report hitting an Oracle database. When I run the query from the Data tab, it returns the data just fine. However, when I run it in the Preview tab, it gives the following warning: The data set 'isotopes_eng_data' contains a definition for the field 'AMOUNT '. This field is missing ...more >>

I'd like to be able to give users a link that will take them directly to the PDF version of a report without ever seeing the interactive reports server pages or having to use the export command manually. The PDF would have to be freshly generated each time, rather than simply linking to the ...more >>

I am recieving an "Error!" message while installing just the Microsoft SQL Server Reporting Services Setup Support Files". I have met all the pre-requirements and have this running fine on a development server. Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows Installer 2.0, a...more >>

I have a requirement to have a mailing label the can have up to 3 Address fields Homer Simpson Address Line 1 Address Line 2 Address Line 3 Springfield, IL 999999 If 2 an 3 are not used I would like the City State and Zip to move up under Address line 1, right now there are blank lines...more >>

What is Custom assembly ? Can I use a custom assembly to apply styles ( bgcolor,font,height,width etc) to report elements at runtime using reporting services coding ? Thanks, Anand Sagar anandsagar@gmail.com...more >>

I have 20 rdl reports that I am working on. I will have to keep a consistency at the colours, backgroud colours, fonts etc in all of the reports. Is there any one place where I can define all these attributes and somehow apply the same attributes to all the reports with a single stroke(either at...more >>

When I want to list the reports within my server, I have to set de credentials for the reportingserivce. I do this with the following command: rps.Credentials = new System.Net.NetworkCredential(user, pwd); This works fine when the users exists as windows account on the server. When I use th...more >>

I have a complexed report It makes use of two queries and 2 tables I need to use a group in order to display the information correctly, If I had one query it would have worked perfectly, But the data I am retrieving is so complexed that I need to make use of two queries other wise I ...more >>