Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rmg1
  • Order by date
  1. rmg1

    Distinct Count - Multiple Groups - Grand Total is off if duplicate in column's value

    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...
  2. rmg1

    Distinct Count - Multiple Groups - Grand Total is off if duplicate in column's value

    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...
  3. rmg1

    Distinct Count - Multiple Groups - Grand Total is off if duplicate in column's value

    I understand that. How do I get the correct grand totals to not count duplicates in other groups?
  4. rmg1

    Distinct Count - Multiple Groups - Grand Total is off if duplicate in column's value

    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...
  5. rmg1

    Need to group by groupcode then, within each group, sort by descending YTD fld for each custid

    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...
  6. rmg1

    Need to group by groupcode then, within each group, sort by descending YTD fld for each custid

    I need to do the following: CustID / YTD Total / Jan Price / Feb Price / Mar Price / Apr Price / May Price CustGroup A 10 / 141,646 / 12,964 / 32,150 / 47,951 / 25,457 / 23,123 1 / 67,542 / 10,333 / 13,151 / 26,326 / 7,826 / 9,906 4 / 3,070 / 1,320 / 1,386 / 0 / 181 / 181...
  7. rmg1

    Need 1 large barcode comprised of text field + TAB + numeric field + TAB + numeric field.

    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}*...
  8. rmg1

    Problem with Conditional Format of Currency Symbol in Group

    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...
  9. rmg1

    Conditional Format of $CurrencySymbol in Groups and at top of page

    One more thing...I am printing GF1 (Sales Category) with a heading for the order number information (GF3)
  10. rmg1

    Conditional Format of $CurrencySymbol in Groups and at top of page

    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...

Part and Inventory Search

Back
Top