I am trying to build a report model. I have a stored procedure that return a result set. I created a Named Query to exec the stored procedure. But when I clicked OK, it gave me this error: Please help. TITLE: Microsoft Visual Studio ------------------------------ Cannot create the na...more >>

I have a column heading that needs to call a function based on the value contained in the heading (which is a parameter selected by the user). Example: they can choose system, database, network or application. I have functions which do different translations and the functions are named tra...more >>

I am creating a form which requires one page of the form to be blank lines. INformation is pulled from the underlying database, and some of those lines are populated with Data. What I need to happen is I must keep this form on one page. So if it is 20 rows to fill the page, and the databa...more >>

I have an image (jpg/bmp) file on the hard drive. I want to be able to point to the path from the report and display the image. The image stored on the hard drive can change, hence I want the image displayed on the report also to change accordingly. The stuff I am trying to do is about the com...more >>

I was wondering if anybody has upgraded to AS 2005 without having to change their stored MDX extensively to work with the new AS model. The company I work for has 100's of reports with 100's of MDX queries that might potentially need to be updated because 1) it's just not possible to do things...more >>

I have created a sql server report with one main report and 4 subreports and one rectangular label having height as of four subreports in the tablefooter. table has detail row and below there is a table footer which has subreports and rectanle merged in it. When detail and subreportsits fit on ...more >>

I need to extraxt from a table of my db the records that satisfy a condition on a field date. I use this query string for the data set: ="SELECT Cliente, NrDocumento, DataDocumento, NrRegistrazione, DataRegistrazione, TipoDocumento, Descrizione, DataScadenza, Importo, ImportoIncassato FROM P...more >>

Well, it finally arrived, my eval version of vs.net 2005....I was so excited, I think I really must 'get a life'... Anyway, I recall on here mention that in vs.net 2005 you get more control over the parameter area.....can anyone point me to any documentation on how vs.net allows more control o...more >>

I have a multi-value parameter. In preview mode, I have to click the drop-down first to see all the values, with the value "(Select All)" placed by RS at the top of the list. But how can I make RS have (Select All) as the DEFAULT, so the user doesn't have to go to the drop-down at all if h...more >>

I'm working on a software project that requires a reporting solution. Of all the solutions we have looked at RS2005 seems to fit best with our product, however, I had a few queries. 1. Our data is stored in a non-relation format but for reporting the end user can select what data the wish to r...more >>

Hi all, I have RS 2000 SP2 (8.00.1038.00) installed on one server. RS 2005 is installed on another server and I followed the steps from Migrating Reporting Services (SQL Server 2005 Books Online). I managed to copy the MDF files ReportServer and ReportServerTempDB and their associated l...more >>

I am having a problem with creating any report in Visual Studio 2003 and Reporting Services 2000. I can create a datasource and test the connection without any problems. However, when I create a report that uses this datasource (or try to create an new one) it fails with the error message ...more >>

What does =Code.SafeDivide mean in an expression? I have an example below: =Code.SafeDivide (Sum(Fields!revenue.Value), Sum(Fields!volume.Value)) Thanks, Deborah...more >>

I try to get a custom assembly running with Reporting Services on Windows Server 2003. The assembly must access a SQL Server database on the same SQL Server as Reporting Services (localhost) The assembly is written with VB .NET 2003. I have a assembly running accessing a oracle db, this ass...more >>

Hi, I am wondering if it is possible to stop the data from being displayed once the pharse "transaction complete" is read into my report table. Once this field is read i want the remaining data to be displayed on the next page of my report. Any ideas would be much appreciated. Ivan ...more >>

In a report, I have a textbox... and I want to make a new line in the expression builder... I tried that =Fields!ShipToName.Value & "\n" & Fields!ShipToAddress.Value but the \n is not recognized I have tried without the quote, with singles quotes, ... but no way... It is a really stu...more >>

I am getting an error: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" when I run my report on the server. It works fine when it is run locally. Does anyone know what this message means? Have I screwed up something? Thank...more >>

Hi, Hasn't see anybody talk about this issue. 1. I drag a Report Viewer webpart in WSS site and edit its' "Title" then close the "Modify Shared Page" The Title change to "Report Viewer". 2. I click the "Modify Shared Web Part" of Report Viewer and change the title. It can change...more >>

We have a project that is going to report from a sql2000 server utilizing Reporting Services(RS). So the natural thing to use is RS2000, (i assume based on licensing). I am confused concerning client report development tools for each version. For RS2000 - 1) The designer requires some v...more >>