I am using Microsoft Visual studio and have a question. I need to put multiple tables on the same report how can I do that? I got this reply to a previous message but dont understand it "Depending on your needs, you can either create a dataset that is based on a query/stored procedure tha...more >>

Hello everyone, We are migrating from Crystal Reports 8.5 to SQLServer 2000 Reporting services (I know its 2007, I work for the Government ;). In Crystal I was able to set a flag that tells a report not to print if it gets an empty data set. Is there any way to do this in RS?? Any help woul...more >>

I have a database with 2 seperate tables. how can I get those two tables onto the same report?...more >>

All, I have a report that displays statistics for survey results. There are four questions and each question prints on a separate page. There is a single page break that works perfectly in report preview. However, when printing (to multiple printers) or exporting the report, a blank page...more >>

Hi, I have a matrix and a table in one report. I have a subtotal field in the matrix. I would like to display the value of the matrix, subtotal field, in a field in the table. Can someone explain the steps that I need to take to make this happen. Thank you for your help....more >>

I have a database e-mail application that is a shipment notification. One of the columns retrieved for this e-mail is a tracking number. How do you format an html link so that the only thing seen is the the tracking number that is blue and underlined. So far all of my attempts at coding t...more >>

I'm new to Reporting Services. I'm trying to create a report that needs data from two tables. The problem is that they are in two different databases. I've been told to use databasename..tablename in the query, but I still need to have two datasources. Any help would be greatly appreciated. Th...more >>

I have created a custom assembly to automatically display parameter names in a textbox an a report. The parameters display through the previ When I run my report through 'DebugLocal' mode. it breaks here: Public Class ParameterList Public Shared Function GetParameterNames() ...more >>

Hi! When I try configure report data source to connect to database on another SQL Server 200 i receive message: The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services. What can I do with thiss message? ...more >>

I have installed SQL 2000 in Windows 2008 Server Beta 3 with no problem. Now I am trying to install SQL RS 2000. I am getting an error message that IIS is not installed. Any hint to trick Installation to have it working with IIS7? Thanks ...more >>

At the very end of Installation process I am getting an error message: Can't initialize Reporting Services service. Initialize it manually. I am not sure what I need to do at this point. Can someone help, please? Thanks ...more >>

I keep getting asked credentials when I try to login to the above site. Now matter what credentials I use it just gets prompting me. The most frustrating thing is that there are no real errors in event viewer. I get the 401.1 and 401.2 depending if I change basic auth on the IIS side. Any ...more >>

Hi We've got a oddity when exporting to Excel. If you export the same report to Excel twice in sucession (don't refresh between - just export) some report give different results between exports, with some columns being shifted. Subsequent exports seem to be conistent. The problem may be rel...more >>

Hi, I have a LocalReport to which I'm trying to add some code to (Report Properties -> Code). The code is fine syntax wise, but when I attempt to use it in the Expression editor, the function never appears. Other examples seem to just add the function into the code window and it just shows...more >>

I am trying to create a report with many subreports in the detail section. I have as many as 4 subreports on one line (lined up next to each other). The problem is, even if they are spaced evenly in the layout tab, when I preview the report they aren't spaced evenly. If I include some graphic...more >>

Im trying to make it so my drop down box on the parameter for my report automatically fits or at least I can specify the size. Im using ssrs 2005 and there is a sroll bar on on both sides. I would like to increase the size so I dont have these but dont know how to. PLEASE HELP!!!! ...more >>

bs"d While creating the report I looked for a way of filtering the data by "WHERE" to compare two attributes such as ( customers.name = friends.name ) Is there a way to do it by the gui setup? -- dai...more >>

What permission is required to be able to go into the "My Site" settings in the Report Manager? Is it looking for a specific permission in the ReportServer database, config file, or some machine permission?...more >>

Hi folks, I've been searching for a way to get mulitple sub total rows. Here is the requirement. I have a report that looks like this DataCol Emp1 Org 1 Expense1 3 Expense2 5 Expense3 6 Org 2 Expense1 1 Expense2 7 Expense...more >>

I have a report that asks for two dates and wanted to control that the difference between two dates is not superior to two months. Exists some way to control the dates before clicking the button of "View Report"? Thanks,...more >>

Hi all, i have a question, i'm making a report in visual studio, where i have a textbox which i fill with a value from a database and i wanna know how you can change certain strings withing the filled value.... example: This is the expression for the textbox: =First(Fields!MyFieldName.Value...more >>

I have a report in SQL Reporting Services 2005 which calls a stored proc and the report takes a very long time to run and sometimes returns zero records. But when i run the stored proc in query analyzer it takes about 4 seconds. I have checked the execution log on the RS using the below sql: ...more >>

Does anyone know a field to display the report last updated date or version in a generic report footer for my 5th grade computer class? I did this in 4th grade on Crystal and it was too easy. What's up with Reporting Services?...more >>

Hello, I just wonder if there is anyway to compress the report before sending it to customer via email? Thanks Hooman ...more >>

In Report Manager, using a parameterless report or a report with parameters that have default values, if one clicks on the report link in a folder, the report automatically begins generating and then the data is viewable. Is there any way to prevent the report from being (automatically) gen...more >>

Hi all, I need to create some reports in my company and I have SQL Server 2000 and Visual Studio 2005. Well, to create reports I will use the tool Report Server from the SQL Server 2000. When I try install RS I can't because I don't have the Visual Studio 2003. Can someone help me? ...more >>

I have a report that requires 2 "tables". The first table summarizes total lbs by a category and then provides a company total at the end: cat 1 75 cat 2 100 cat 3 200 ------- total 375 The second table needs to display the % of the total for each category: cat 1 20%...more >>

Hello All, I will Appreciate assistance I getting the following error "Syntax error converting datetime from character string." when I run store procedure as follow: exec Store_Procedure_Report5_test1 '06302007' (which the input parameter is from type of datetime) The Store procedue l...more >>

All: I am having a problem with Microsoft Reporting Services. I am running a local report (RDLC) on ASP.Net. Running the report obviously can use a lot of memory because it must consume ADO.Net. My problem is that the report does not seem to be very good about releasing the memory. It...more >>

Hi all, I have to desing an applicaiton which allow user to generates repots. it should allow user to drag and drop image from file system, allow to change text in a page and also allow to export this repot to PDF, Word, RTF, PPT all other fomates. Could you please advioce me how can i start...more >>

We have the need of constructing a report with a main data category and two subcategories, meaning the following: One customer can have n phone numbers (so it is a 1:n relation from customer to phone numbers), and one customer can also have n orders (so there is again a 1:n relation from the c...more >>

How can I have different reports deploy to different subfolders? all of them are currently going to same folder. TIA Dean ...more >>

Has anybody tried to display a Google Map inside a report using Reporting Services? Thank you, Alain Quesnel alainsansspam@logiquel.com ...more >>

I have a matrix and would like to be able to add to the column titles the column number. I have been looking for a function maybe similar to the rownumber() function, but cannot locate anything for column number. Is this a possibility? Thanks! ...more >>

OK.. I'm stumped. My IE 7 is working fine. I can access any websites I want with one exception. What is this exception? I recently installed MS Reporting Services 2000 on this computer. All went well. When I try to access the http:// site where all of my reports have been deployed,...more >>

I am printing report using custom print. For each page it prints an empty page. Is there something I can do? Thanks ...more >>

Good evening. This may be an easy question but I am using SMS Reporting (which is SQL Reporting Services) to generate reports for inventory collections, etc. I am not the greatest with SQL but is / how can I display plain text in my reports? This text is descriptive / comment text and not ...more >>

Below is the query and a screen shot of the report layout - I want to show only the top 10 totals in descending order. If I add top(10) to the select now - it only shows the top 10 clients within a service instead of the top 10 services sold. How do I make it look at the sum total and show ...more >>

Question: Can you have a report were the top half is filled in with one query and the bottom half is filled in with another query??????????????? I have a report that is just fine right now. I was asked to have the comments to the agency print at the bottom of the report. Query1 is big, ...more >>

I am using RS 2000 Eval Edition I have just enstalled it on my notebook. This is where my existing copy of SQL Server 2000 resides. The SQL 2000 Server is working fine (as it has for the past several months) I installed RS 2000 Eval Edition using all of the "default" settings. I then ...more >>

We have an MSRS2000 extension that was originally written under VS2003 (.NET 1.1). We have updated our extension and compiled it under VS2005 (.NET 2.0). We now use the extension under MSRS2005. We would like to use the same, .NET 2.0-compiled extension dll under MSRS2000, but receive e...more >>

I have chart with data grouped by years and months. My data stops in Jan 2010 and the chart is showing this data with a year grouping of [2] instead of [2010]. It appears to be truncating the year because it there is data for only one month and it is the right most value in the chart. Any idea...more >>

Hi. I want to intercept any errors generated when the report's stored procedure executes. I've created a handler for the ReportError event but it never fires. My web page is in C# and has AutoEventWireup="true". I even tried explicitly adding a handler... theReportViewer.ReportError += n...more >>

I am trying to create a .rss file that deploys my reports to the report server. I have everything working except for the creation of the datasource. The problem is that I am using an Oracle database and I cannot set the correct setting in my code. I can create a datasource; but I have to ...more >>

After a server failure and subsequent restoration to new hardware reporting services is only allowing members of the builtin/ administrators to view the reports (or any of the report listing pages for that matter). The steps employed after the restoration from backup to new hardware that I to...more >>

Just wondering if MS Report Builder is a good tool for creating adhoc reports on very large database that contains dozens of tables, several of them containing 8 million records each. So far I have found it takes very long time if your output (report) contains several thousands or pages. If any...more >>

I am trying to find a way to add a simple trend line to a line graph in reporting services. I have been unable to find how to add a linear trend line. ...more >>

I am trying to create a set of parameters that will alow me to select data either based on criteria from dropdown boxes or from a text box. In my DataSet I have something like this (simpified) if @ItemDesc is null select citemno, cdescript, 0.0 as price from icitem where ..... else ...more >>

I am running SQL 2005, I have the latest service pack on SQL 2005 and also on the Windows 2003 server. This is on a single server. I am using my Exchange 2003 server as my SMTP server which is on a different server with the same subnet. -When a domain user schedules a subscription it won't ...more >>

Hi there. There's an iif statement that I'm struggling with on Reporting Services. This statement is on a calulated field. The iif statement is as follows: =iif(x=0, 0, ((y-z)/x)*100). In other words, if x is zero then 0 must be the output. Else the above formula must be the output. The...more >>