INNER JOIN Orders ON Orders.id = Products.idOrder SELECT customers.name, SUM(unitprice*qt) AS total I am using this SQL but it only gets one year: Products -> id | idOrder | unitprice | quantity |. ('StartDate') & '' AND vcEntryDate id | name |. ' (vcEntryDate >= CONVERT(DATETIME, '' & StartDate & '', 102)) AND ' & _ ' Total FROM dbo.PropReportData WHERE cManagementCo = '' & Session('MgmtCo') & '' and ' & _ This query works fine for individual community totals'SELECT TOP 100 PERCENT vcName, COUNT(DISTINCT vcCustId) AS ' & _ The query pulls the total customer quotes for each community in a management company and loads my DataGrid: I need to get the Grand Total of the results of this query. Set_Shot_Dave View 2 Replies View Related Get The Grand Total Of This Query Dec 12, 2003 I want a grand total for the whole report. And only give me a grand total for that page. I've used =sum(reportitems!textbox10.value) but it only works at the page footer. Now I want to SUM up this field and put it at the end of the report. I've group the report by company and did a count this works find. Every company has at least one date report. I've created a report that has a count of dates reports. View 4 Replies View Related Grand Total Oct 18, 2007 I have a new requirement come up to put a Total at the button of the result set of my Query.Д¬ase WHen left(MONTHDate,3)='Jan' Then '01' I have a script that produce a result set that is almost complete. View 3 Replies View Related Transact SQL :: Grand Total At Button Of Result Set Of Query Jul 16, 2015 BUt in grand Total the result showing is for all the diemnsion values.ДЇor example The user restricted to browse only Australia and UK Country, But in grand total its showing the SUM of all the country. In my cube I have defined a role where thet user can only browse certain dimention value. Role Defined Wrong Grand Total Result May 22, 2008 Change Display Of Result Set From Showing As Rows To Column As One Or More.Reporting Services :: Wrong Total Values Are Coming With SUM Function.SQL Server 2008 :: Balance Sheet Query Showing Wrong Amounts On VAT Accounts Only.ROLLUP - Retrieve A List Showing Total Repair Cost Per Year.SQL 2012 :: Log Shipping - Secondary Database Path Showing Wrong Location?.Reporting Services 2005 - Showing Wrong Version.SQL Server 2012 :: Sales Over Years - Retrieve Values In Single Query For Multiple Years And Grand Total?.Analysis :: Show Grand Total When Using SSAS Tabular Role Security Permission.

Reporting Services :: Report Builder 3.0 - Separate Grand Total Section To A New Page?.

Err On Grand Total In Cube Measure Using A Distinct Count Agregation.

Pb With Calculated Measure And Totals (grand Total Or Anysubtotals).

Power Pivot :: Sum Of The Parts Not Equaling Grand Total?.

Adding Grand Total To A Column Group In A Matrix.

Distinct Count With Null Values (grand Total).

Transact SQL :: Add A Grand Total To Pivot Output?.

Analysis :: Custom Grand Total In SSAS?.

Add Grand Total At Bottom Of Pivot Table?.

Transact SQL :: Grand Total At Button Of Result Set Of Query.

I dont know why it is showing 13 instead of 6. When dragging projet name and employee name it is showing data related to 6 employees but grand total showing 13 as the result.

In the ProjEmpBridge table i mapped only 6 employees data to the proj's data. My FactEmployeeTable showing 13 rows of data related to employees, but i used a bridge table for connecting project and employee dimensions. Grand Total Is Showing Wrong Result May 19, 2008

Transtype 3.0.2