How to make a page break so table details are not split to 2 pages? I use table to show details for each record (Each record has several table rows). One page can have several records. But if the blank is not enough for one record, I want that record to be on the next page. How can I achiev...more >>

Hello, I have installed a fresh new Reporting Service sp1, on a Windows 2003 Server, SQL 2000 sp3, IIS 6.0 and am getting an error when trying to send out emails via subscriptions. Cannot decipher the error. Log file is below: -------------------------------- <Header> <Product>Microsoft...more >>

Is it possible to rename the Home directory in Report Services? ...more >>

RS on my Intranet runs perfectly. While most of my reports are designed as email-delivery ("push") subscriptions, I do have some critical "pull" reports that are designed to require report parameters and cannot be subscribed to. Authenticated firewall users can access the home page of the ...more >>

Hi all I am following the 'Deploying the Printer Delivery Sample' in order to add printing functionality to reports. After compiled code was put in both the reports server's and manager's bin directories( and thier config files were set accordingly), I can see the new printing delivery extensio...more >>

I have a few questions: 1.) Is there going to be a RS SP2? 2.) If yes, will it be released prior to 2005 and what can we expect? We have spent alot of time and money on RS but so far its not giving us what we want... Will we have to wait for VS 2005?...more >>

Hi, i am facing a problem to export data to MS Excel. In the financial report, I have month and date from 9/1/1998 to present (hardcode all the column). Users would like to export those data into an Excel spreadsheet. However, if users choose the date from 1/1/2003 to 1/1/2004 then a...more >>

I know that you can set a textbox to be of format Currency, but how can I set the text of a textbox equal to a string that has formatted strings within it? What I mean is, lets say that I am getting back 2 values: MyFieldA and MyFieldB, which are both floats (say 12.3123 and 43.2234). I want ...more >>

I am trying to implement form authentication for reporting service using the sample which is provided on microsoft site. Everything works fine, except that everytime, a user which already exists in database, tries to login, can't see anything unless his name is entered in RSReportServer.config file ...more >>

I have a subreport that gives me the error : An error occurred while executing the subreport ‘PlanLocationbyItemNumberLocations_subreport’: Error during processing of ‘item_id’ report parameter. Preview complete -- 0 errors, 1 warnings This problem only occurs when the value of...more >>

Has anyone successfully installed the Exchange Pack for Reporting Services? I've attempted a couple of times and continue to get "Object Reference not set to an instance of object", which causes the install to rollback. Does anyone know how to correct this problem? Thanks. ...more >>

I have a Reporting Services Solution that contains many reports. One of the things that I have to implement is a function that formats a field that some reports have (but not all of them). I didn't want to create a VB function, because the function was already implemented by someone else in C#...more >>

I have a report in Visual Basic that passes dynamic run-time info to a Crystal Report via CDOSETS. The current function that creates the report loops through for each record and calculates tax on 1 currency field per record. Is this something that I can acheive in Reporting Services?...more >>

I have a web application utilizing Reporting Services and a custom security extension based on the MSDN article that has been referenced many times in this group. I've been trying to track down a problem with losing the current session, which causes the RS logon page to be displayed. It happens ...more >>

Would it be possible to buy a license for SQL server, not install SQL server and then have both the data and application tables in an Oracle database? A customer of ours does not want to support SQL Server at all. I can accept that they need a SQL license to use RS, but is there a way to get ...more >>

I have a report where the row height is allowed to grow as needed. When I export this to Excel, the row hight will not adjust to the proper size. Help Please! I have read this posted by others, but I did not read a solution. ...more >>

Is it possible to get Reporting Services running on a server wtih .NET2 beta1 installed? thanks ...more >>

Right now we have IIS 5.0 installed on Windows 2000 server. Could we use reporting services under this configuration?...more >>

This seems like an easy request but I can't figure it out. I have a table with multiple groups. Each group header contains subtotal fields. I want to hide the contents of the subtotal fields on each group header when that group is expanded but I want the field that contains the name of the ...more >>

Hi I wand to use an Alternating Backcolor in a Report for every Row. In don't find this property. How can i do it? Many thanks. Andy ...more >>

Is it possible (or supported) to have multiple Report Server instances pointing to or using the same SQL Server repository? Thanks, Matt...more >>

I am hoping that someone can direct me to a VB.Net code sample (preferably ASP.Net) which is a good example of programatically setting ADO.Net connection properties, calling a stored procedure, supplying user defined parameters for the stored procedure and outputing the report to a PDF format....more >>

Hi, My report requires a special type of font. I have the font installed on the report server. When I export the report as PDF and view the document on the report server I am able to see the new font. But when I open the same document on a machine which doesn't have the font installed, I do...more >>

Hi, i have a problem with a subreport: I created a main report and included a subreport. The Subreport is linked with the main report over a String field. The column in the main report has the type uniqueidentifier in the sql-server database. if the column in the main report has a value, t...more >>

Hey all I've (now!) got a problem with the Enterprise Edition Reporting Services Installer, in that it doesn't get passed the "Installing required components for the Setup" screen! I was doing the installation across a Terminal Service / VPN connection to our live servers, and although i...more >>

having hard time solving this simple Query. I am using the following Query in reporting services with sp1 installed . ="SELECT {[Measures].[Calls Handled],[Measures].[Transfer In Calls],[Measures].[Transfer Out Calls]} on Columns, NONEMPTYCrossjoin([DestinationDim].[Destination Si...more >>

I am trying to take an output field and use it as a hyperlink into a web application, but am getting an error when trying to specify a URL with a ':' in it. Basically I want to say have a report with 3 fields (ID, Name, Total) and the ID field would be a hyperlink to an external application...more >>

I've been trying to get a legend (alongside a pie chart) completely visible, but can't seem to get it to work. Does the size of the legend come hand in hand with the size of the plotting area? How can I individually set the size of the legend? Thanks in advance!...more >>

Hi there. We are slowly moving to a completely mobile workforce , using pocket PC 2003 XDA type devices and a web based aspx data entry program. Most of our Business Intelligence is done via SQL reporting sevices. SQLRS doesnt render on a XDA type device. Even if you pass in the format pr...more >>

Is there an easy way of doing this? I have a report where the user selects the month and year as parameters passed in. I then want to show these on the report, but display the month as month name rather than ordinal. I tried using the GetMonthName function but it moans about it not refer...more >>

Hi everyone, I'm trying to install Reporting Services with the ReportServer database in a remote server. When the setup program try to connect to the remote SQL Server, I get the following error message: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server co...more >>

I want to display my reports in dutch. Of what is the language dependent? server properties ? Can you explain how the export to PDF-format effects the report-language properties and/or serverproperties ? Thanks in Advance ...more >>

Is there any method to split and merge cells in a matrix? I have tried to add row and column group but it is not exactly I need. ...more >>