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 dencom 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: *

  1. FrequentUser

    Changing Size of Mailing Labels

    I created a report that accurately displays all then desired info for my mailing labels. However, the size of the mailing labels is off. I need to select Aver 5160, it is currently using a different template. Does anyone know how to change this setting or is it only possible in the mailing...
  2. FrequentUser

    Formatting Currency Display

    So I searched through past threads and didn't find an answer to this question. I have several Running Totals which calculate the declared value of work to be performed for building permits, sorted by month. Running Total Name: JulyRes [July Residential] Field to Summarize: {APBLDG.DECLVLTN}...
  3. FrequentUser

    displaying only millions value

    I have several values (numeric) in the millions, that I rounded to the millions. However I want to display only $20 for $20,000,000 $14 for $14,000,000 etc. It's probably an easy solution, but I need it quick. Crystal Reports XI, MSSQL 2000, ODBC
  4. FrequentUser

    Suppressing if Zero

    Just got CRXI last week, and I am having problems suppressing summaries when result = 0 I have tried making formulas in Format Editor. Is there something new with CRXI that prohibits this? Format Editor, Suppress Formula: when . . . Sum ({@JulyRplan_disp}) = 0 No Errors, but does not...
  5. FrequentUser

    Previous Function not allowing grouping - URGENT

    Attempting to use formula: {@Initial v Revisions} if {@Plan #} = previous({@Plan #}) then "Revision" else "Initial" However, it does not allow grouping on this formula. Under the Crystal Reports X Help index it states: "Note: Using this function in a formula forces the formula to be...
  6. FrequentUser

    don't want suppressed data in grand totals.

    I have to sort sets of plans reviewed and I need only the date of the first completed review. I tried: Minimum({APACT.COMPDTTM}) but some of the reviews are completed simultaneously, but I still only need the first to display. I incorporated a Group Sort Exports to suppress when: {@Plan...

Part and Inventory Search

Back
Top