aggregates displayed in group header.

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - SSIS and Informix We are using Informx for our transactional DB and want to be using reporting services to provide reports. We have some using ODBC directly to Informix, but need to start extracting data from Infomix and aggregating it in SS 2005. Is anybody else doing this Where can I find information of how to do this We are totally new to SSIS. Thanks JPS Tag: aggregates displayed in group header.
  - 2
    - QP is missing and it is required to evaluate default expressions? Hi everyone I have a really odd problem that has manifested its self. I have a Windows Mobile 6 device that I debugging my application on, the application uses a local Sql Compact sdf file, if I just run the app, when it comes to executing some ado.net against the database I get the following error:- QP is missing and it is required to evaluate default expressions. Ensure that sqlceqp30.dll is in the same directory as the storage engine (sqlcese30.dll) If however I open the the database using query analyzer first on the device then everything is ok until I next soft reset the device Has anyone else come across this Thanks in advance Dan Tag: aggregates displayed in group header.
  - 3
    - XML Format Files Hi I am trying to use the bulk insert command to import a large amount the data from a fixed with text file. I have got this working with the old style format files but i can not get it to work with an XML fromat file The XML version tells me the first column is to long. any one know what i am doing wrong this is the old style format file that works 9.0 9 1 SQLCHAR 0 18 "" 1 Field1 Latin1_General_CI_AS 2 SQLCHAR 0 6 "" 2 Field2 Latin1_General_CI_AS 3 SQLCHAR 0 6 "" 3 Field3 Latin1_General_CI_AS 4 SQLCHAR 0 8 "" 4 Field4 Latin1_General_CI_AS 5 SQLCHAR 0 14 "" 5 Field5 Latin1_General_CI_AS 6 SQLCHAR 0 25 "" 6 Field6 Latin1_General_CI_AS 7 SQLCHAR 0 9 "" 7 Field7 Latin1_General_CI_AS 8 SQLCHAR 0 9 "" 8 Field8 Latin1_General_CI_AS 9 SQLCHAR 0 9 "\r\n" 9 Field9 Latin1_General_CI_AS this is the XML file genrated with the BCP TOOL < xml version="1.0" > <BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <RECORD> <FIELD ID="1" xsi:type="NCharPrefix" PREFIX_LENGTH="2" MAX_LENGTH="510" COLLATION="Latin1_General_CI_AS"/> <FIELD ID="2" xsi:type="NCharPrefix" PREFIX_LENGTH="2" MAX_LENGTH="510" COLLATION="Latin1_General_CI_AS"/> <FIELD ID="3" xsi:type="NCharPrefix" PREFIX_LENGTH="2" MAX_LENGTH="510" COLLATION="Latin1_General_CI_AS"/> <FIELD ID="4" xsi:type="NCharPrefix" PREFIX_LENGTH="2" MAX_LENGTH="510" COLLATION="Latin1_General_CI_AS"/> <FIELD ID="5" xsi:type="NCharPrefix" PREFIX_LENGTH="2" MAX_LENGTH="510" COLLATION="Latin1_General_CI_AS"/> <FIELD ID="6" xsi:type="NCharPrefix" PREFIX_LENGTH="2" MAX_LENGTH="510" COLLATION="Latin1_General_CI_AS"/> <FIELD ID="7" xsi:type="NCharPrefix" PREFIX_LENGTH="2" MAX_LENGTH="510" COLLATION="Latin1_General_CI_AS"/> <FIELD ID="8" xsi:type="NCharPrefix" PREFIX_LENGTH="2" MAX_LENGTH="510" COLLATION="Latin1_General_CI_AS"/> <FIELD ID="9" xsi:type="NCharPrefix" PREFIX_LENGTH="2" MAX_LENGTH="510" COLLATION="Latin1_General_CI_AS"/> </RECORD> <ROW> <COLUMN SOURCE="1" NAME="Field1" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="2" NAME="Field2" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="3" NAME="Field3" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="4" NAME="Field4" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="5" NAME="Field5" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="6" NAME="Field6" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="7" NAME="Field7" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="8" NAME="Field8" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="9" NAME="Field9" xsi:type="SQLNVARCHAR"/> </ROW> </BCPFORMAT Tag: aggregates displayed in group header.
  - 4
    - Custom security extension - Report Manager and Report Server on different machines Hi, I'm trying to deploy Reporting Services on an Internet-facing web server using a custom security extension (forms authentication). We will be putting Report Manager on the Web Server outside of the firewall, and Report Server on another machine inside the firewall. When testing the solution in a development environment with Report Manager and Report Server on the same box, the solution works fine. When testing it using the Internet-facing environment described above, it almost works but there seems to be an issue with the authentication cookie that is generated. Here's what happens: 1. User enters credentials on UILogon.aspx and submits form. 2. In the code-behind, LogonUser() is called through a web service proxy and the authentication cookie is returned successfully. The code used here to set the cookie is the same code used in the Forms Authentication sample that ships with RS2005. 3. The user is redirected to Folder.aspx, and the request hangs for a while, and eventually kicks you back out to UILogon.aspx, as if it lost the authentication cookie. When doing a trace on the HTTP header, the cookie is still there. Is there anything special I need to do to make the Report Server "see" the cookie when I have Report Manager and Report Server on different machines Any help would be much appreciated! Mike Tag: aggregates displayed in group header.
  - 5
    - Root Element MIssing & For security reasons DTD is prohibited in this XML document This error comes up in the print preview and nothing prints. We are using VS-2005, SQL 2005 and SSRS 2005. We had the same problem yesterday , so we have reinstalled IIS, .Net Framework 2.0 and Reporting Services, then reconfigured RS security, uploaded all the reports and enabled remote errors. After doing everything this error was gone and we were operating pretty fine. Suddenly just we started getting the same annoying message." ROOT ELEMENT MISSING " from Report Server and from Report Manager we have " For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. " Please Help. I need to fix this ASAP. Tag: aggregates displayed in group header.
  - 6
    - Date conversion woes: Cast? Convert? I have been having some trouble trying to get the date format YYYYMMDD 00:00:00.00 to convert to MM/DD/YYYY. I am using SQL 2005 and Reporting Services. I attempted several variations to solve this problem as outlined below, with the final working conclusion at the end. I am not saying that this is the BEST or the ONLY way to achieve the solution, but it worked for me. Code Block --------------------------------------------------------------------------------------- SELECT DATE_TIME AS DATE1 FROM TRANSLOG --returns value of 20071027 02:26:24.06 --------------------------------------------------------------------------------------- SELECT CAST ( DATE_TIME AS SMALLDATETIME ) AS DATE1 FROM TRANSLOG --returns value of 2007-10-27 02:26:00 --------------------------------------------------------------------------------------- SELECT LEFT( CAST ( DATE_TIME AS SMALLDATETIME ), 11 ) AS DATE1 FROM TRANSLOG --returns value of Oct 27 2007 --------------------------------------------------------------------------------------- SELECT CAST ( SUBSTRING ( DATE_TIME , 0 , 9 ) AS SMALLDATETIME ) AS DATE1 FROM TRANSLOG --returns value of 2007-10-27 00:00:00 --------------------------------------------------------------------------------------- SELECT CONVERT ( VARCHAR ( 10 ), DATE_TIME , 103 ) FROM TRANSLOG --although this works with GETDATE(), it does not work with the DATE_TIME field --------------------------------------------------------------------------------------- SELECT CONVERT ( VARCHAR ( 10 ), CAST ( DATE_TIME AS SMALLDATETIME ), 101 ) AS DATE1 FROM TRANSLOG --THIS WORKS!!! Displaying 10/27/2007 Hope this helps somebody someday! -Jody Tag: aggregates displayed in group header.
  - 7
    - SQL login CHECK_POLICY calculations Hi.... I'm querying for SQL -logins whose passwords are about to expire. If Active Directory has a password expiration policy of x days, which is the correct query to use SELECT name, DateAdd(day, x, create_date ) FROM sys.sql_logins WHERE is_expiration_checked = 1 or SELECT name, DateAdd(day, x, modify_date ) FROM sys.sql_logins WHERE is_expiration_checked = 1 Or is this stored elsewhere from sys.sql_logins Thanks. Tag: aggregates displayed in group header.
  - 8
    - update system catelog data Is it ever possible to update system data We want to change the default values of about 400 columns in 20 or 30 different tables and it would be easier to run an update query but so far we are prevented from doing so. Tag: aggregates displayed in group header.
  - 9
    - Null value for Web Service task input I'm attempting to use the Web Service task to call a method provided by a vendor. The inputs are all simple types so that helps a lot, but for one input it's a string array. If I enter a single string value for a given id using the array dialog, the method works fine. However if I try to change the input to use a variable to provide the value it fails. I'm assuming that you can't create a variable to return a string array. Please let me know if this is the case or if I'm missing something obvious ;-) In addition, is there a way to specify a null value for an input Currently there doesn't appear to be a way to do this in SP2. I tried leaving the string empty which didn't work and I tried using a variable with expression "NULL(DT_WSTR, 1252)" but that failed too. Tag: aggregates displayed in group header.
  - 10
    - Can I pass '=' or '>' as parameters? Hi I'm moving SQL in my app to Stored Procedures. My SQL string is currently created within my app, and I have two check boxes and this C# code... if (chkPartTime.Checked&&!chkFullTime.Checked) { sql+= " AND P0_Hours = 0" ; } if (!chkPartTime.Checked&&chkFullTime.Checked) { sql+= " AND P0_Hours > 0" ; } where sql is my query string If both boxes are checked I don't care what value P0_Hours is, but at least one of them will be checked. What I want to know is how I transfer such logic into a Stored Procedure, or whether I will need to creat 2 similar sp's and choose which to call in my app. It will combined with a query (currently 60 lines) comprising of 3 UNIONs TIA Tag: aggregates displayed in group header.
  - 11
    - String Search Hi, Was wondering how you do the equivalent of an Oracle "Instr" function in TSQL, which returns the position of a string pattern in a specified string I've looked through all the functions and can't find the equivalent. Thanks Simon Tag: aggregates displayed in group header.
  - 12
    - Dbbc not logging db name in error log correctly? In the SQL error log it is not showing the actual database that was checked. Below is the entries for user databases. What gives 2007-05-01 18:20:36.28 spid99 DBCC CHECKDB (master) WITH no_infomsgs executed by 2007-05-01 18:20:37.64 spid99 DBCC CHECKDB (mssqlsystemresource) WITH no_infomsgs executed by 2007-05-01 18:20:38.20 spid99 DBCC CHECKDB (master) WITH no_infomsgs executed . 2007-05-01 18:20:39.54 spid99 DBCC CHECKDB (mssqlsystemresource) WITH no_infomsgs executed by 2007-05-01 18:20:40.21 spid99 DBCC CHECKDB (master) WITH no_infomsgs executed by 2007-05-01 18:20:41.56 spid99 DBCC CHECKDB (mssqlsystemresource) WITH no_infomsgs executed by Tag: aggregates displayed in group header.
  - 13
    - What's the best way to approach this situation? Hello everyone, I'm creating a database for a new application and I'm currently facing a design problem, regarding a business requierment for the membership module. The Membership Module of the application has several business requierments, specified by the client. One of them is the ability to add and remove details about their members. So far, I've created a schema, named Person, which will contain a number of tables responsible for everything related with the membership, as an individual. To help you guys understand the design I'm trying to implement, I'll post the fields of two of the tables that belong to the Person schema, as follows: Person.Base Id (uniqueidentifier) UniqueIdTypeId (uniqueidentifier) UniqueId (uniqueidentifier) Password (char(88)) PasswordSalt (char(10)) PasswordRecoveryQuestion (nvarchar(256)) [NULLABLE] PasswordRecoveryAnswer (char(88)) [NULLABLE] CreationDate (datetime) AuthenticationWindowStartDate (datetime) AuthenticationWindowAttemptCount (tinyint) IsActive (bit) IsBanned (bit) IsLocked (bit) Status (bit) Person.Emails PersonId (uniqueidentifier) EmailAddress (nvarchar(256)) CreationDate (datetime) ValidationCode (char(10)) ValidationDate (datetime) [NULLABLE] IsValid (bit) IsPrimary (bit) IsRollbackTarget (bit) Status (bit) So far so good. This design works great to preserve the data integrety. Nonetheless, this is where the problems start. Now, imagin you need to let someone from that company add an item to the user (through the application). Let's say we want to allow the company application manager to add an item to the person called "PreviousEmployer". Such item would then be used for statics, thus would probably need to be indexed. In order to meet this business requierment I would create some addicional tables. Let's get started: Person.CustomFields Id (uniqueidentifier) Name (nvarchar(50)) Description (nvarchar(3000)) [NULLABLE] Status (bit) Person.CustomField_Value FieldId (uniqueidentifier) Value (nvarchar(450)) This could work just fine if both are indexed (that's why the nvarchar size is set to 450). But I'm guessing this is far from the optimal solution for many reasons, one of them being the efficiency of the index if the company decides to go and use this for a flag (true or false [bit]). Another "solution" breaking scenario would be if the company wants to add the CV of the person, situation in which we were unlikely to be able to add a file in this datafield. How would you guys approach this issue The bottom line is that the client needs to be able to add pretty mcuh any type of custom field and perform searches againts it. So, besides being a dynamic solution it needs to be efficient. Best regards and thanks in advance. Tag: aggregates displayed in group header.
  - 14
    - Triggers per row not per statement Hi guys I am wondering if there is any way of setting the trigger to execute once per individual row that is updated as appose to once per statement. Thus a statement like this would trigger twice not just once: Update Order Set Name = 'test' Where OrderId In (1,2) If this is not possible do the Deleted and Inserted tables have the records for all the items that were updated in the statement The reason being that i need to store the before snapshot and after snapshot of the updated data in an audit database along with an event that ties the two audit records together. This event is a business logic event, which is stored in the main database and records which user made the change, what other records the change is related to and impacts, etc, etc. Thus after the above update is complete, I would have 4 audit records, 2 being pre shots and 2 being post shots, along with 2 event records. Where each event record ties one of the pairs of pre and post audit records together. Now if the tables hold all the records, my first thought was to simply do a mass insert. But as the event ties the pairs of pre and post records together I can��t just do a mass inset into the database. Thus when I first thought about doing this row by row triggers is great for me as it keeps the logic fairly simple. But if i only get one bit of the apple (as it were) does anyone have any suggestions as to about I could go about. Is my only option to run through a cursor on the inner join of the pre and the post data and on each loop create my event and then insert the pre and post shots Any help is appreciated. Anthony Tag: aggregates displayed in group header.
  - 15
    - Data Conversion supported on Standard Edition? I created an Integration Services Package that runs fine from my local computer using BIDS. However when I imported into our SQL Server and try to run it from there I get the following error: DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Data Conversion" We are running SQL Server 2005 Standard Edition 64-bit. We have integration services installed on the server. Is data conversion something that is not supported on Standard Edition Also have a similar message for "Send Mail Task." Is there anywhere that outlines what features are supported on each version Tag: aggregates displayed in group header.
  - 16
    - database size issue What can be the reason for a database to have abnormal size. for example: i have a database with size 12 GB which is not in according to the amount of data it has (theoratically it should be around 3 GB). To verify this, i create another db and then import all the tables from first db to second, and as expected the second db size is about 2.5 GB. What can be the reason for additional 9 - 10 GB in first db. Tag: aggregates displayed in group header.
- Next
  - 1
    - The AcquireConnection method call to the connection manager "Server.Northwind" failed with Error code 0xC0202009; Error at Text Inbound Task [SQL Server Destination [9]]: The AcquireConnection method call to the connection manager "Server.Northwind" failed with error code 0xC0202009. Error at Text Inbound Task [DTS.Pipeline]: component "SQL Server Destination" (9) failed validation and returned error code 0xC020801C. Please keep me posted with alternate work around(s) /solution(s). Tag: aggregates displayed in group header.
  - 2
    - Upgrading Access 2003 to Access Project and SQL 2000 backend. Hi, I am upgrading an Access 2003 database to an Access Project with a SQL 2000 backend. I am trying to develope a type of framework to communicate with the backend. I have read some about linked tables, pass through queries ect. My initial instinct would be to use sprocs and ADO from VBA modules like a .NET application. My database has reports, forms that update and insert data, and forms the call data proccessing procedures. Is ADO from VBA modules calling sprocs the best method to manipulate my data. The DB could have up to a million or 2 records in my biggest table, their are only two end users. Any suggestions or links or books would be appreciated. Thanks, Mike Tag: aggregates displayed in group header.
  - 3
    - SQL Server Agent - start up account. Hi all, Please let me know what specific privileges an user account needs to be used as a LOG ON AS account for SQL Server Agent in SQL Server 2005. Does the account needs to me in the domain administrator group Thanks, DBLearner Tag: aggregates displayed in group header.
  - 4
    - Select full rows depending on distinct date Hi Say I have a table with columns 'id, date, title, text' and in order to display a list of 'month year' I need to select rows with distinct month & year of the date component. I can select distinct year & month components by doing this: select distinct convert(varchar(7), date, 111) as date from posts but how do I return the other columns as well Regards, Johan Tag: aggregates displayed in group header.
  - 5
    - Basic steps as how to web usage mine in sql server 2005 Hi there, I am doing a project on web usage mining of my universities server logs and im just wondering how i go about mining them in sql server 2005 Do i mine them in one table do i normalise the web log data what algorithms will i use on them as im trying to get usage patterns from the users and also where most of the users come from. Thanks in advance Gary Tag: aggregates displayed in group header.
  - 6
    - SQL Server sp_add_job procedure missing I have found out that the stored procedures sp_add_job, etc. are missing from msdb. How do I get these procedures Thanks, Mary Tag: aggregates displayed in group header.
  - 7
    - Formatting for Phone? In my report I am combing 2 fields as =Fields!PROPERTY.Value & " - " & Fields!PHONE.Value this results in PropertyName - 5555551212 How would I add in formatting for phone so my resulting display is (555) 555-1212 Tag: aggregates displayed in group header.
  - 8
    - Should I use dynamic SQL and combine 2 procs into 1? For dozens of entities, we have a Select (returns one record with @ID param) and a SelectList (returns all records.. no param passed) stored procedure. E.g... CREATE PROCEDURE dbo.SelectEmployeeList AS SELECT * FROM Employee CREATE PROCEDURE dbo.SelectEmployee @EmployeeID uniqueidentifier AS SELECT * FROM Employee WHERE @EmployeeID = @EmployeeID Given the nearly duplicate syntax, I'm considering handling both via a single proc (using dynamic SQL) like this: CREATE PROCEDURE dbo.SelectEmployee @EmployeeID uniqueidentifier = null AS DECLARE @Sql nvarchar(1000) SELECT @Sql = 'SELECT * FROM Employee' IF @EmployeeID IS NOT NULL SELECT @Sql = @Sql + ' WHERE EmployeeID = ''' + CAST(@EmployeeID as nvarchar(50)) + '''' EXEC( @Sql) Does this idea sound good or bad to you Any drawbacks/reasons I shouldn't do it Thanks, Ron Tag: aggregates displayed in group header.
  - 9
    - ora-12645 Paramater does not exist I get the ora-12645 error when doing an import from oracle to mssql. The error comes-up when setting up the datalink properties of the source database which is oracle. This error happens on a 2003 server machine using the import/export wizard. It works fine when using an xp machine. any ideas Tag: aggregates displayed in group header.
  - 10
    - Error Deleteing Remote File I am trying to delete a remote file as part of an SSIS package. The FTP Task I have to retrieve the file works fine. I use the same remote path variable and connection manager for both tasks. However, when the delete step executes I receive the error: Error: 0xC002918E at FTP Task, FTP Task: Unable to delete remote files using "FTP Connection Manager 1". Tag: aggregates displayed in group header.
  - 11
    - Data Connections: Where the hell are they stored??!! Hello all, Does anybody know where SSIS Data Connections are stored Whenever one creates a Connection Manager, a list of all created Data Connections appears. It's very quick and easy to create a Connection Manager from an existing Data Connection, so really the latter are in essence the Connection Managers and are thus part of the application. It is therefore important to back them up if for example one wants to migrate the application to another computer. I have looked everywhere in Documents and Settings and Program Files and I can't find any folder or file where these Data Connections are stored! It's annoying to have this mysterious black-box behaviour! Does anybody know Thanks in advance, Jerome Smith Tag: aggregates displayed in group header.
  - 12
    - JPGs added to Image column are truncated at 1024 bytes (but only when import executed as a Job) I have a table in a SQL 2005 database that is designed to hold JPG product images for a website. Here is the schema: create table dbo.Eur_RMISWebInterface_Staging_ProductImages( product_code varchar(12) not null, image_order smallint not null, colour_identifier varchar(10) not null, image_data image not null, constraint PK_Eur_RMISWebInterface_Staging_ProductImages primary key clustered ( product_code, image_order ) ) Product images are inserted into the table from a database on a remote SQL 2000 server. Here is the script that does that (uses dynamic SQL): set @SQLCmd = ' set xact_abort on begin transaction delete Eur_RMISWebInterface_Staging_ProductImages insert Eur_RMISWebInterface_Staging_ProductImages ( product_code, image_order, colour_identifier, image_data ) exec "' + @RMISServerName + '".' + @RMISDatabaseName + '.dbo.Eur_RMISWebInterface_GetProductImagesForWeb ' + convert(varchar(3), @PortalID) + ', ' + @Locale_LCID + ' commit transaction' execute (@SQLCmd) About 500 images, each about 20KB, are transferred at a time. Here is the problem - when this script is run manually, all the images are inserted completely. When the script is run as part of a job (that has several other steps), the job step completes successfully and all the images are inserted, but every single one is truncated to the first 1024 bytes of the image. What this ends up looking like on the website is a a narrow strip of image instead of a complete image. Here are some other observations: - When I changed the "Eur_RMISWebInterface_GetProductImagesForWeb" SP to only return 1 product image instead of 500 it still failed - The owner of the job is the same Windows user as the user I have been running the script manually as - I have tried changing the datatype of image_data from image to varbinary(max) but it made no difference What could possibly be going on Tag: aggregates displayed in group header.
  - 13
    - create table by code Hi I developed a program. This program will use a SQL server database. How can I create the database using code. I think I need to use sql scipt like this: create database customers But where should I write the script and How can I make VB code implement the script. thank Tag: aggregates displayed in group header.
  - 14
    - binding textbox text to a database field hello is it possible to to bind a single field from a database table to a textbox. I am trying to open a web form with five textboxes on it. When it loads is it possible to have the textboxes filled with a different field from a row in a database, selected with a sql statment. Thanks in advance NubNub Tag: aggregates displayed in group header.
  - 15
    - Pattern Matching and Full-text search I'm not quite sure that this is possible but, I figured that I would check with you experts out there before trying a new approach. I've done quite a bit of research and have not seen anyone quite figure this out yet. We have a SQL Server 2005 application that stores and indexes documents to the database as an image data type. I'm able to do full-text queries against the documents without any trouble. I begin to run into problems when trying to pattern match social security numbers and drivers licenses stored in a full-text index. I have a user defined function that I call which runs my regular expression that checks for hits of a ssn or license number in the index. I have no problem getting hits when the data sits in a column. I do need to mention that I have no trouble when searching for a ssn with a fixed value and where I know the ssn (ex: 123-45-6789). I am actually trying to find the existence of the pattern of ###-##-#### (ex: ^\d{3}-\d{2}-\d{4}$) anywhere in the index. Any help would be very much appreciated. Tag: aggregates displayed in group header.
  - 16
    - Check remotely if Reporting Services exist is there a way to check the reporting services remotely.. using the reporting services url Tag: aggregates displayed in group header.

galath

I have a report that consists of three nested group levels. Each level can be expanded/collapsed. I wanted to have at each level the summed values:

e.g.

+ Group Header 1 Sum1 Sum2 etc..

+ Group Header 2 Sum1 Sum2 etc..

+ Group Header 3 Sum1 Sum2 etc..

Rather I have had to output the aggregated values like so ..

+ Group Header 1

+ Group Header 2

+ Group Header 3
Total Group Footer Sum1 Sum2 etc..

Total Group Footer Sum1 Sum2 etc..

Total Group Footer Sum1 Sum2 etc..

Is there a way to display the aggregated values at the header level of the grouping. I thought this could be possible if I could hide the Group Footer and directly reference the footer sum total values in the header. Any help would be greatly appreciated.

Theo

Top

Re: aggregates displayed in group header.

Waco_Huber

Aggregate functions should work in either the header or the footer and return the same results, e.g. you do not need to reference the footer in the header to return aggregate values calculated on a group. Try setting the value of a textbox in your group header to the same aggregate function you are using in your footer.'

Ryan

Top