During the question session for the reporting controls webcast which finished a few minutes ago Brian Welcker indicated that the Reporting Services 2003 Service Pack 2 would be available online later today. No URL was specified. http://www.microsoft.com/sql/reporting/default.asp or ht...more >>

I just upgraded SP2 Beta to today's SP2 release. When I tried to print a chart, there were multiple "Error loading resource string" messages before the Print Dialog appeared. Presumably, these messages refer to label strings for some of the push-buttons, which appeared blank, such as "Printer ...more >>

I have a report containing a matrix. The matrix cells contain a textbox with the data to display. I need that textbox to appear only some times, so i wrote a function that returns true or false depending on some field value that i pass as parametter. The report renders fine as PDF, but when...more >>

Hello. We're trying to get drill through subreports to work using the WinForms.ReportViewer control shipped with VS.net beta 2. As a test, we're creating the simplest possible master/detail type report pair. The subreport is hidden with a manual toggle. The master report displays fine in Re...more >>

I receive the following error ONLY when rendering to PDF format. My report has one Matrix in it - no tables, lists or sub-reports. Failure sending mail: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. From ReportServerService log: Re...more >>

Hi MSTR Mentors, I am in need of your Help... I am having this issue for a very long time....Hope I will get a solution from you guys... We have a Custom .net dll, referred in the RDL, the dll has a function which gets the encrypted Credit Card# and returns the Decrypted value to the Report...more >>

When trying to install RS2000 I'm getting a very generic "Error!" message just as it begins trying to install the "Microsoft SQL Server Reporting Services Setup Support Files". It makes it through the setup of WinInstall and .NET Framework1.1 just fine but as soon as it get to trying to ins...more >>

Will it be possible to replace the toolbar with a custom toolbar that can launch the appropriate events (i.e. Print, Export ...)? Matt M. ...more >>

In the report parameters dialogue box I have set up a Non Queried list, when someone selects Grand Rapids(label) I want to return multiple values, 21 OR 22 OR 23, these are the Grand Rapids Department ID's. Can this be done? If so what is the correct syntax? Label Value Gr...more >>

I have a report where I have to do the same expression over and over with the only change being the day of week that the data exists in. What I wanted to do was to create a single code block that I could call: Code.dataByDay(1) That would do the work of checking my Fields and doing all of...more >>

RS works fine locally. When accessed from the internet, I can see the report folders; I can select a report; it processes "Opening....."; then (briefly) "Finding site xxxx"; then nothing. No circular icon that says "Processing Report", just a big blank page. I have tried it as Administra...more >>

I have to create a join between tables on SQL Server & a table/file on an AS400(DB2). I can create the 2 different data sources just fine, but I cannot figure out how to join the data into 1 dataset, since you can only use 1 data source. Has anyone been able to do this? Help!...more >>

I'm trying to refer to a report parameter in my Code block from the Report Properties page. But it keeps giving me an error that says, "Reference to a non-shared member requires an object reference." I'm refering the parameter as Parameters!pBusiness.Label. Any ideas about how I can see my...more >>

Hi, I hope someone will take a moment to answer my question. I'm combining results from 2 databases. The SQL statement works fine in Query Analyser using the full names of the database tables (db1.dbo.table1, db2.dbo.table1). In SRS the dataset executes correctly under the data tab when usi...more >>

I’m having a problem passing parameters to my report thru the url. I’ve read the online text, the manuals we have here, and the newsgroup entries. I created a "non-queried" parameter in my report: TestParam I can test this parameter when running this report in Report Manager. I ente...more >>

Has anyone successfully implemented a HTTP Module in Reporting Services? I added the module snippit in the Report Server web.config and added the dll to the Report Server bin folder, but I still recieve the error " Unable to communicate with report server. Please verify that the report server ...more >>

Hi, The scatter chart in reporting services seems to enforce either a Sum() or a Count() function on a selected data element, depending on data source type. Irrespective of the format of the source data field, Reporting Services will always treat an Analysis services Measure field with a Co...more >>

Hi there, I want to derive the ReportDesigner TextBox to add some special functionality. So i had to know which assembly provides this class. using: - Microsoft SQL Server 2005 CTP (april) - Visual Studio 2005 Teamsuite Beta 2 (april) Thx! In german: Hallo, Ich möchte die ReportDe...more >>

Hi there, I want to derive the ReportDesigner TextBox to add some special functionality. So we had to know which assembly provides this class. using: - Microsoft SQL Server 2005 CTP (april) - Visual Studio 2005 Teamsuite Beta 2 (april) Thx!...more >>

My query returns numbers to the report, these are already rounded (this is made to happen in query as they are cast to int). After I get these integers to my report, I tend to group them, and AVG a group set. If there is a lot of the numbers in the equation, the total tends to decimalise t...more >>

Hello On my header I need the Employee-Name (ReportItem!EmployeeFullName.Value), so i put in a ReportItem that refer to a Field (Fields!EmployeeFullName.Value) in the body. It functions as long as the page wont be divided. When the report is too long and it will be divided, the header will ...more >>

I am trying to install Reporting Services on my live machine, which is a Microsoft Windows 2003 Server, running SQL Server and IIS 6, but when I run the installation it say that Visual Studio .NET 2003 is not installed, do I have to install this on my Live Server? I'f I just hit next after the...more >>