No announcements
Found 1680922 threads
-
2 VotesAdd column totals to a crosstab query
Terry, I could use the crosstab query to add that totals column too.Answered | 5 Replies | 1404 Views | Created by tkosel - Wednesday, January 31, 2018 2:40 PM | Last reply by Terry Xu - MSFT - Monday, February 5, 2018 1:16 AM
-
2 Votes
Crosstab Query
I have decided to use the Column Headings Property because I have not been successful with the dynamic crosstab solution.Answered | 6 Replies | 812 Views | Created by Gordon Swan - Saturday, July 29, 2017 11:49 PM | Last reply by .theDBguy - Thursday, August 3, 2017 5:45 PM -
0 Votes
Crosstab query with 2 Column Headers
I wonder if I can accomplish this with a regular crosstab query and then use some VBA...Answered | 5 Replies | 8580 Views | Created by mbrad - Monday, December 13, 2010 8:19 PM | Last reply by mbrad - Tuesday, December 14, 2010 3:31 PM -
2 Votes
Crosstab Query Drops Row
A crosstab query uses a grouping query to build the row headers, so if you use something like a CustomerID to summarize records from an Orders table, ...Answered | 4 Replies | 3865 Views | Created by John Lane - Saturday, December 4, 2010 3:17 PM | Last reply by Vanderghast - Tuesday, December 7, 2010 11:57 AM -
3 Votes
Display Crosstab Queries in Percentages
Add the query you just made to the qxtbCrossCompare query.Answered | 9 Replies | 15989 Views | Created by KKbondo - Friday, August 20, 2010 6:16 AM | Last reply by KKbondo - Friday, September 3, 2010 9:49 AM -
0 Votes
report with subreport for column headings, dynamic crosstab queries
I'm not familiar with Duane's dynamic crosstab query.Answered | 4 Replies | 7551 Views | Created by javablood - Friday, January 7, 2011 12:11 AM | Last reply by Geoff_G - Saturday, January 8, 2011 9:51 PM -
0 Votes
Crosstab query
In your case since you wanted to add Total columns in between I proposed to use slightly different approach of using CASE expressions and GROUP BY.Answered | 13 Replies | 2512 Views | Created by SnowShine429 - Monday, January 20, 2014 7:12 AM | Last reply by Naomi N - Monday, January 20, 2014 6:41 PM -
0 Votes
problem with crosstab queries
Hi friends, I am developing a crosstab query. here i have two fields say f1 and f2. i need to set field f1 as column header. it is fine.Answered | 1 Replies | 2828 Views | Created by xpbaroda - Wednesday, June 9, 2010 2:34 PM | Last reply by Javier Guillen - Wednesday, June 9, 2010 5:32 PM -
1 Votes
Dynamics Pivot query - exclude a column and add a total
I added the Total name into the query.Answered | 16 Replies | 3916 Views | Created by Peter__R - Wednesday, November 9, 2016 10:18 AM | Last reply by Riaon - Friday, November 11, 2016 6:58 AM -
0 Votes
Generate a report on top of Parameter based Crosstab Query
The columns in a crosstab query are dynamic, but the design of the report is fixed.Answered | 1 Replies | 615 Views | Created by KhurramKZ - Saturday, December 19, 2015 1:17 PM | Last reply by Hans Vogelaar MVP - Saturday, December 19, 2015 2:48 PM -
0 Votes
Crosstab Query Value Expression
in the column headers, and you want to replace it with “X”?Answered | 2 Replies | 735 Views | Created by Demelgry - Thursday, August 20, 2015 6:21 PM | Last reply by Edward8520 - Friday, August 21, 2015 3:13 AM -
0 Votes
Need assistance with a Crosstab Query
Syntax for pivoting requires aggregate columns SELECT <non pivoted column>, [first pivoted column], [second pivoted column], [third pivoted ...Answered | 3 Replies | 7771 Views | Created by Tailor - Wednesday, December 22, 2010 9:37 PM | Last reply by Chirag Shah - Thursday, December 23, 2010 2:06 AM -
0 Votes
Crosstab Query
Art','Student1') INSERT INTO @School(Class, [Subject], Student) VALUES('Class1','Art','Student4') INSERT INTO @School(Class, [Subject], Student) VALUES('Class1','Art','Student6') ...Answered | 4 Replies | 1620 Views | Created by JohnJames55 - Sunday, May 18, 2014 10:07 AM | Last reply by JohnJames55 - Sunday, May 18, 2014 7:52 PM -
1 Votes
Crosstab Query needs to show blank/null weeks
In the query return the InspectionYear, Week, Week Start and Week End columns from Weeks, not from your query.Answered | 12 Replies | 4088 Views | Created by ctomp - Wednesday, July 27, 2011 4:34 PM | Last reply by Ken Sheridan - Thursday, July 28, 2011 3:53 PM -
5 Votes
Crosstab report using dynamic pivot query in crystal report
I'm formatting a crosstab report with dynamic pivot query using crystal report and I find it hard to format my fields.Answered | 3 Replies | 6226 Views | Created by BU Systems - Wednesday, December 5, 2012 9:45 AM | Last reply by Sheng Jiang 蒋晟 - Friday, December 7, 2012 12:32 AM -
2 Votes
MDX Query Add Total Row
[GP Pct] } ON COLUMNS, NON EMPTY ([Divisional Sales Branch].Answered | 3 Replies | 3741 Views | Created by David.Squires - Thursday, December 29, 2016 7:40 PM | Last reply by David.Squires - Tuesday, January 3, 2017 7:32 PM -
0 Votes
Crosstab Query for Remaining Revenue (Count, If, Date Between )
Post example data for 2 projects and what you want that data to look like in crosstab output.Answered | 2 Replies | 658 Views | Created by Gord0oo - Wednesday, January 14, 2015 12:16 PM | Last reply by Starian chen - Thursday, January 15, 2015 7:57 AM -
4 Votes
Add Total for a Column in Data Grid Screen Based on Query
Excuse my relative inexperience but I'm trying to total a field in a search data grid.Answered | 3 Replies | 4994 Views | Created by omar_awwad - Thursday, October 20, 2011 4:55 AM | Last reply by kalebPnz - Wednesday, March 4, 2015 4:57 PM -
0 Votes
Convert ACCESS Crosstab query to SQL Server 2008 Query
Hello: I need help to convert this access crosstab query to SQL Server.Answered | 1 Replies | 4619 Views | Created by aaditya2000 - Tuesday, April 9, 2013 6:35 PM | Last reply by Jingyang Li - Tuesday, April 9, 2013 6:40 PM -
0 Votes
automatically show newly added column headers in crosstab to form/reports
For a form, you could use a subform control and set the SourceObject to the crosstab query instead of another form.Answered | 2 Replies | 405 Views | Created by gilbzcampos - Monday, August 17, 2015 1:44 PM | Last reply by Alphonse G - Monday, August 17, 2015 2:46 PM - Items 1 to 20 of 1680922 Next ›
No announcements
