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!

Register Log in
  • Congratulations strongm 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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}*...
  4. 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...
  5. 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