I've created a table with two group header rows and a detail row. I would like the second group header to 'overlap with' the detail row when the report prints. Is this possible? And if so, how do I go about accomplishing this? Thanks! ...more >>

I'm trying to SUM values using an IF statement. I have a table that shows employee's time and hours for 3 different shifts. The results are grouped so each day I can see the employee total hrs and also another group that shows the grouped results for a range of dates. At the table footer, ...more >>

Hi All, I have a table and the dataset it populating all but four cells. These four cells I want to populate using data from a different dataset (I couldn;t figure out a query to do what I needed). The main dataset returns a value I can use as a parameter in the second dataset. Is this clear?...more >>

Hi can anyone help i have the following data in ms sql reporting 2000 A B C D E F G H i 1 - Drilldownable sum Sum 2 - Drilldownable sum Sum 3 - Drilldownable sum Sum 4 Detail Detail Detail Count Count A,B,C(1,2,3) are drilldownable and row 4 is the detail row. Is there ...more >>

Hi, Is it possible to rotate a table in Reporting Services? In other words, I need the columns to run vertically down the left of the page, and the rows of data to also run vertically. Here is an example of what I need. The column names are Product Name, description, etc. The rows of data...more >>

Pleas help me! Following Problem: I cant get a sum of the group Value. For example my Table: Date ID KM_from KM_to Sum_KM ID2 Text cost 20061001 1 100 200 100 1_1 taxi 100 20061001 1 100 200 ...more >>

I have a very strange problem. I'm using a table and I've conditionally hidden columns before without any problems, but all of a sudden, this one report I'm working on has a conditionally hidden column in the table, but when the column is hidden and I export the report as PDF, there is a solid ...more >>

I want to prompt the user for a specific ID number or use a * for all records at the time of running the report So in my criteria for the employee ID field I put "= @empid" In the report the input box is there. If I put in an ID number it works great. However if I put in an asterisk "*" no...more >>

Hi Group, I have this subreport that displays information from 2 fields of type nvarchar(4000). If I try to preview the subreport from the designer, everything works fine - there are about 2 pages of information displayed. Export to pdf works normally. After deploying it on the server, if...more >>

Hello, Can you install SQL 2000 Reporting Services on a Windows Server 2003 box running SQL 2005 server? Thanks for any help. ...more >>

Hi! I was wondering if Reporting Services could be used to implement VLOOKUP and COUNTIF functions in particular available with MS Excel on a Table. I would like to venture a guess and say no. Unless there was someway I could use RunningValue or something to simulate these implementations. ...more >>

I have seen this issue posted a few times in the forum, but have not any replies or solutions... In Report Viewer, the report is listed as having 10 pages both in the Report Viewer navigation bar and in my footer (="Page " & Globals!PageNumber & " of " & Globals!TotalPages). When the report...more >>

Hi, im working on a Report which needs to be able to display an unknown number of columns; the only one that are always present is the first one with a timestamp. An example of the data: [timestamp], [value 1], [value 2], [value 5]. Is that possible with Reporting Services? The only solut...more >>

Hi, I have a report in which i have sales value displayed for 4 zones (north, west, east and south) for all months of the current year. I want to display the subtotals (North + West) and (South + East) and the Grand total. Can some one help me Thanks in advance EggHeadCafe.com - .NET Deve...more >>

Hi, We have a user in the System Administrator and System User roles of 2005 SSRS. He is able to connect to the website (http://<servername>/Reports) and do whatever he needs to do. But, when he tries to connect to Reporting Services in Management Studio, he receives the following error: ...more >>

I have set up some basic parameters on a report. Start_Date and End_Date. Currently, the user is able to select an End_Date less than the Start_date. I would like the user to not be able to select an End_Date less than Start_Date. Where would I put this constraint?...more >>

Hi all, I am a newbie to reporting services and am assigned the task of building an architecture for hosting reports for different departments in the organization. I am setting up a prototype and have a few questions: Environment: SQL Server 2005, VS 2005. 1. I understand that I can use ...more >>

Hello, Is there a way to divide a "dynamic column" by another "dynamic column" ? Example: Assume matrix has 2 columns column1 and column2. I want a third dynamic column called column3 based on an expression column2/column1 Matrix will look like colmn1 | column2 | column3 (value is c...more >>

This is my second day with reporting services so forgive my ignornace. Question: Looking into how to change the language property at runtime. Could anyone give me a simple example? Example: I just created this quick function Public Function CustomFormat(Value as Integer) as String ...more >>

Good morning, This is a continuation post about a problem I am having where I can't open Report Manager. Here is my scenario - win2003 server running Sql Server 2000 Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last year to ..Net framework 2.0 so we could use Visual Studio...more >>

I have a report with many subreports. Recently the user requested that they would like the subreport to show even if no data is returned in the subreport. (They want the space on the report to show) Inside the subreport is a table where the data is returned. Can this subreport be shown spaces a...more >>

Hi...... I have developed a application which create the report and save it in user selected location. All this i done in one class. this application shows all the reports on report server and render the report for user selected parameters. and save it with folder browser option on a locati...more >>

Hi All, i am new to this reporting services 2000. Can anyone clear the following SQL Reporting Services 2000 is free software or license software. If I install the MS SQL Server 2000, then will MS SQL Reporting Services 2000 be installed automatically? Do we need to purchase or req...more >>

Is there any easy way to find out whether Reporting Services has been installed on a SQL 2000 Server ? Thanks Peter ...more >>

Can someone tell me whether Wombats live only in Australia, or also on other continents? Apart from zoos, of course. 14 -- Posted via a free Usenet account from http://www.teranews.com ...more >>

Hi people My IT department have reinforced at change of domain and username upon my Reporting Services/SQL 2000 server. At first everything seemed to be working much to my suprise. But I later found out that all the scheduled emails ect doesnt work anymore. At closer inspection I find th...more >>

Hello I have been asked to get involved with SSRS and was wondering what version I should be installing. I have seen two downloads Enterprise and Standard. Also will this work with SS Express 2005? Kind Regards Ricky ...more >>

Is there a way to show how a row is ranked in a table? For example, I know I can sort by a value like Hours Worked: Employee HoursWorked 3 23 1 12 2 5 Can I have a table that sorts by the employee but shows the employee's ranking by Hours Worked?: ...more >>

We are trying to get our business logo to appear on our reports. It prints ok but does not show up on the HTML rendered page. I have done a lot of searching: We have rc:HTMLFrag=true in our URL. I have the image set as external I have the value pointed to the directory the logo is...more >>

Greetings, I can't open Report Manager (sql Server 2000, win 2003 server). I log into our server as SA where Reporting Services is/was installed (I did not perform the install). I go to start/Programs/Microsoft Sql Server/Reporting Services/Report Manager. This brings up a page that has ...more >>

I am trying to develop a "customer statements" type report. I have no issue creating "one off single customer at a time" versions. I have an issue reporting groups of customers at a time. The scenario is this: Single Parameter = All Customers in Canada (for example) 3 different data sets of...more >>

I have a report in matrix format. The weeks are across the top and the calculated field is in the rows. I need to be able to count accounts that have ordered for that week which I was able to do. I also need to count if this is the first time the customer has ordered "ever" and if they are ...more >>

Hi, My site is currently down. When users try to view a report they get An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Could not allocate space for object 'ChunkData' in database 'ReportServerTempDB' because the 'PRIMAR...more >>

Hi All: I have a report that will be shared by a number of sales agents across a number of different communities. The agents select a set of parameters and run their report. Currently Community is one of the parameters they can select. I'd like to know if there is any way to dynamically...more >>

Hi, I need to be able to create a Table of Contents for a Price List Catalog in Reporting Services. Using the AdventureWorks example report (Product Catalog.rdl), I need to be able to create something similar to the following: Table of Contents Accessories Bike Racks ...more >>

Hello All, I need an expression that hides a column based on the report parameter. So, I add the following expression to column Visibility property: =IIF(Parameters!active.Value = "Current", True, False) Which gives me the following expression error: "Input string was not in the correct ...more >>

Hello, I have following Situation: I have a Dimension "SourceDirectory", whis has Elements "SourceDirectory1", "SourceDirectory2", ... until "SourceDirectory10". My Statement in MDX is whis: SELECT {[Measures].AllMembers} ON columns, {[SourceDirectory].Children} ON rows FROM [CheckstyleError...more >>

hello, I have some reports using OLAP cube as data sources. When I use mdx query builder to create any mdx statement as dataset, my computer will hang up and pop up a window says: Preparing Query: The query preparation is in process, to cancel, press CTRL+C for at least half a second...more >>

Hi, I'm working on a report within the development environment. A couple of the parameters are Date/Time parameters for which RS provides a Date Picker. The Date Picker returns dates consistent with my regional settings i.e. in dd/mm/yyyy format, however, once I've selected a date from the...more >>

I wrote a udf in sql server for my dataset for a report in Reporting Services. I publish the report to the Report Server, and I can invoke the report, but other users get an error message that they don't have the permissions to run this udf. How do I establish permissions so that everyone ...more >>

Hi, I worked on SQL Server tutorials in Books online, "Data Driven Subscription". In this tutorial, reports are delivered via email on a scheduled time. as per the tutorial emails are being delivered in "MHTML" format but it does not deliver the report in "PDF" or "Image" format. The report m...more >>

While installing CRM 3.0 on the server - we get this error: Setup failed to validate specified Reporting Services Report Server http://loud-yia6ffpnmy/reportserver. Error: Object reference not set to an instance of an object Reporting Services seem to be running but the URL does not come up....more >>

Hi everyone I've a report set up which requires cascading prompts to select report criteria. This works fine on my development box, but not once it's been deployed to the report server. The error I'm getting is: One or more data sources is missing credentials. The scenario is that a ...more >>

I get the following error when trying to connect to my Report Server. I'm running SP2 on Windows Vista. Apparently this is an ASP problem. But how do I solve this ? I already tried running aspnet_regiis. Doesn't work. I'm pretty that is has to be such a pain in the a.. to run RS. My Report ...more >>

Hi, We are planning to use SQL 2000 Reporting Services in order to create and deliver reports to our end-users. It is our understanding that we do not need any extra licenses for Reporting Services as long as our SQL Server is properly licensed. However, in order to use Report Designer we n...more >>

Within Tsql or RS field design environment, how can you return the Monday of each week from either an ISO date or SQL week no value Have been looking at DateAdd and DatePart functions with no luck Thanks Ian...more >>

I am trying to render report but the following errors keeps show up: the code where the exception shows up is: execInfo = rs.LoadReport(reportPath, historyID); System.Web.Services.Protocols.SoapException: The permissions granted to user 'SYS40\IUSR_SYS40' are insufficient for performing th...more >>

im developing a report server Project in VB.net 2005 with reporting service 2005 and i have a dropdownlist parameter, i just want to have this parameter with a specific value, not with <select a value>. I populate this dropdownlist with a ds (of course). I dont know how use the Default Values in...more >>

There is probably no way to pipe to a report control and have it update (i.e. append) detail items without regenerating the whole report each time? -- William Stacey [C# MVP] ...more >>

I am having an issue with a dataset in SSRS2005. Basically, this is a simple dataset from a stored procedure, with two char parameters. I just picked the stored procedure name and let the BI Studio pick all the default settings. Then I try to preview the data. The BI studio locks up. This h...more >>