In response:
What total are you getting? I am getting a grand total of 6 for Abc total. This should be 7.
What field are you counting? In above example, I am counting the number of unique invoices in Group3 which are in Group 2.
I need to show all of the totals for Group 2 in Group Footer...
Maybe this will aid in helping me solve the issue:
Distinct Count on each Group 2 with Grand Total (must equal sum of all Abc line totals)
Group 3
Group 1 Group 2 Invoice# Invoice Line Running Total for Expect for Abc
Distinct Count Grp 2 Grand Total
Apples Abc 1 1 1
Apples Abc 2...
Please see attached for an example of a problem I am having in reporting the Grand Total when using Distinct Count.
I have 3 groups of which Group 2 has distinct count on group 3 (quote numbers) and Group 1 should be the total of all Group 2 distinct counts.
I am also doing a distinct...
Maybe this will help clarify the outcome wanted:
IT Cust No Customer Name 2013 Sales % of 2013 YTD 2014 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
CAT
5 Feline Equity 141,646 12,964 32,150 47,951 25,457 23,123
2 Mew-Mew...
I am using CR2008 and trying to create one large barcode (DataWorks Bar 39) which should contain 3 fields with TAB between.
Also, each field is to an asterisk before and after, no spacing.
Is it possible? If so, how?
The layout is as such:
*{JobNumber}* *{AssemblySequence}*...
I am using CR2008 and am having problems in conditioning the currency symbol for groups.
Group1 = Sales Category (GH1 - Print this)
Group2 = Ship Date (only print dates with GF3)
Group3 = Order Number (GF3 - Print amount on this line)
I need to print the "$" symbol for the 1st Order...
I am using CR8 and am having problems in conditioning the currency symbol for groups.
Group1 = Sales Category
Group2 = Ship Date
Group3 = Order Number
I need to print the $ symbol for the 1st Order Number of the Sales Category (skipping group 2 here completely). For example:
Category Date...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.