Hi. I would like to know if someone tried to call a custom assembly function from inside a matrix and have it worked...coz i tried and it didn't On the other hand, i called the same function from a field outside the matrix and it worked. is there a way to solve this issue? i need it urgently...more >>

I have Sql Server Personal Edition SP3 installed on my PC. I get an error message when trying to install the reporting services trial package. Does the reporting services not work with a personal edition of Sql Server? The error message is "The edition of the report server database is not s...more >>

Hi, I have a DataSet which I want to pass to the DPE, how i pass the DataSet as a parameter to the DPE Please Help! Thanks Girish Kumar...more >>

I created a summaryreport.rdl, with a dataset that runs a stored procedure. The stored procedure takes an Input Parameter, creates a summary and a detail table in the SQL Server, and at the end outputs a the summary table as the resultset. The summaryreport.rdl has a jump action to a detailre...more >>

I use URL to pass parameter to a report of Reporting Service It is ok when the parameter is a number or English characters But the parameter result into ??? when the parameter is a Chinese word. How can I do? ...more >>

I've got a report that can have about 50 possible parameter combinations. The underlying query is fairly expensive, so I want to cache the dataset every morning after I expire yesterday's cache. So I set up a data-driven subscription to run every morning and execute all the parameter combinati...more >>

i would like to ask how to execute the email delivery setting? can it be done in the report server homepage??it is a must to get it work through web service programming? thanks in advance...more >>

I am trying to populate the object ParameterValue from the Reporting Services class provided by Microsoft. I keep getting the following error. I thought I was instanciating the object correctly. Can someone tell me what I am doing wrong? "System.NullReferenceException: Object reference not ...more >>

I have a report that has different layers of resolution: Global, Region, State, Facility and Issue. For different each level chosen I want to display a different set of parameters and execute a different SP for my dataset (which will return the same rows). I've seen posts where I can do the dy...more >>

I need to run a report ON DEMAND from a stored procedure (which was supposed to be a feature of the new reporting system) and then send the output to a file on the network. I can attend to the SQL Server part by creating a VB.net program that I can call from the stored procedure. Now, if I can...more >>

Hi I am trying to create a custom data processing extension that queries a Sybase database (ie odbc), then on the basis of this data queries a SQL Server database. However, when I get to querying the Sybase database, the method instantly crashed with a SecurityException "Request Failed." excepti...more >>

Any help would be helpful: (1) Report Server is inside firewall (2) RS Server query another sql server hosting database I render a report on ASP.net pages in a web server outside the firewall. everything os OK on my local test pc, but trying to render report in the outsite web server, s...more >>

Hi, I've got a few reports that have subreports built in. These sub reports take a parameter which is the index of a particular item to return in the dataset. The problem is our database is considerably large and has a lot of records, consequently when generating the reports, occasionally t...more >>

When the IIS port for the Report Services site is set to something other than 80, the following error returns: [ The underlying connection was closed: Unable to connect to the remote server. ] This looks like a custom error from RS. When the port is set to 80. There is no problem. What...more >>

I think I am getting this error because it cant interpet the Dataset option? Is this a bug or am I doing somthing wrong? Statment: =IIF (ReportItems!JobPriceS.Value / (Fields!Pieces.Value + Fields!SetupPieces.Value) > (Fields!TrussPrices.Value, "DataSet1") / (Fields!Pieces.Value + Fields!Se...more >>

Hi, We have an App Serive Provider model, where we have one server hosting multiple sites(clients). Each client has a separate web site/URL and a separate DB for their data. Ideally I would like to publish the Report Definiton once, but depending on the URL show clients their respective ...more >>

we are aware of KB84245 Titled: "How to move a Reporting Servides database from a computer that is running Reporting Services to another computer". this seems rather clear. But I have I a question. Does this article assume the original DB is on the web server machine, and if so would these...more >>

I would like the output of a particular report to be able to specify that the grid lines in MS Excel be turned on. I do not find any property values that would specify this. How can I accomplish this? Specifically, in Excel, if you goto Tools->Options->View Tab, there is a checkbox under ...more >>

Hi All, I accidentally deleted .sln file and now I can't deploy my report to the Report Manager. Does anyone know how I can recreate a new '.sln' for my report's RDL? Please help, anyone? -Ch...more >>

Hi all, RS first did work for me after installation on my notebook, but some silly changes of our network admin ruined everything: RS does not run any more, gave me some access denied errors. Complete RS Re-Installation told me at the end that it could not initialize RS: "Setup could not in...more >>

Hi - When creating a report without using the report wizard, how does one specify the directory on the RS server that each SPECIFIC report is to be deployed to? I know that the report project has a "Deployment Folder" property but that is project-wide. We want to do it for each specific re...more >>

Like several other users I have had problems moving to a new web server: 1) backup existing RS databases on database machine 2) delete existing RS databases on database machine 3) install RS on new Web Server 3a) allow RS to create databases on the original database machine using the same con...more >>

I have a report, it has a table, and one cell has a simple subreport that returns a list of numbers. I set the background color of the subreport table and the subreport itself to blue. If the subreport has data, all is well, if not, it shows the subreport area as the main report row color....more >>

Is it possible to create charts in Reporting Services and save them as image files? Just the charts, not the text info. -- Sergio Florez M. Medellin, Colombia ...more >>

Can anybody point me to some book or site with Reporting Services expression syntax reference or set of examples. I was able to find only few. Need it asap. Please. Please. Please. Julia...more >>

Hi, I installed a SQL RS without SMTP acount,. support, and now I need configured a e-mail suscripticion, but i don't knok how can I configureted a MS Exchage server fot send mails. I don't want to reinstall SQL RS because it's a critical server. Heeelp!!! -- Sorry for my English :...more >>

When I edit an expression for a textbox, I notice a 'Constants' node in the tree along with Globals, etc. How/Where do i define the constants that will show up here? For example, i would like to define a path to a server in a constant, be able to use it for various expressions, and only have...more >>

I tried to install SQL Reporting Services on a Windows 2000(SP4) with SQL Server 2000. I installed the SQL 2000 SP 3a. The InstallShield Wizard extracting package contents to the C:\SQLRSEVAL. Then I marked the checkbox in the End user License agreement window & clicked Next. Then dispalys "Com...more >>

How can I enable the Graphical Query Designer to work with my custom data processing extension. My extension provides the same as the SQL provider it just configures the connection string from some application settings. Regards...more >>

What tools are available to manage which users are currently running what reports, parameters selected, load on server etc. Basically I'm trying to figure out how I determine if Reporting Services is slow, what report/user is causing it, or if it's just a lot of people asking for reports and ...more >>

I am experiencing an issue when I try to export a few of my reports to Excel. Sometimes when I export to Excel I lose the last row. My reports are very simple and do not include anything other than a table. I can export it one day and all of the rows will be included and the next day I will...more >>

Hi I have the following Problem: I have to do a Graphical analysis from a survey, for that i decided to use the ReportingServices for VS.NET. And for the Data Displaying i took the Chart object. The Data is placed correctly into the chart, but there is one problem. For the Y-Scale i ...more >>

Hi, Cells in a matrix have a the navigation property set to a drillthrough type of report. We don't want a link there if the cell is empty. Is there a way to test for "emptiness" of a cell in a matrix ? Thanks, Tom ...more >>

I have a report where the query for the main table has 7 unions, and the approx. size for this is 12k. When I run this in SQL Query Analyzer it works just fine, but when I copy this into the Dataset in RS and try to run it, the whole application goes into a hang-situation. Three-finger-salut...more >>

I have a report which is group by invoice no. For each new invoice no, page break is inserted. I want to set page number for each invoice (e.g. Page 1 of 1). But if the invoice has so many charge line that occupy more than 1 page, I want to set page 1 as Page 1 of 10, page 2 as Page 2 of 10...more >>