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 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: N22S
  • Order by date
  1. N22S

    Can Crystal v11 and/or 2008 evaluate a real-time user ID?

    It took me long enough but thanks all for your help!
  2. N22S

    Can Crystal v11 and/or 2008 evaluate a real-time user ID?

    Can 11 and/or 2008 evaluate a user's data access user ID online, real time? While using either Crystal version to access a SQL based database can the user ID used to access the data be reflected within a report? I'm not looking for IDs that are stored historically within the database. This is...
  3. N22S

    Formula help needed - distinct value needed

    This might work - Create four different variable formulas. The first is to reset the variable and is placed in the patient header whileprintingrecords; datetimevar minstart := CDateTime (2100, 01, 11, 00, 00, 00); datetimevar maxend := CDateTime (1900, 01, 11, 00, 00, 00); The second is to...
  4. N22S

    Formula to remove anything before the space in the field

    The following should also work: right({string.field},((length({string.field})) - (instr({string.field}," ")))) Note that the instr will find the first blank field, not subsequent ones. Also, if the data could possibly be entered with a blank before ACURA, this will be an issue as well.
  5. N22S

    Need to count values shared by multiple fields in Crystal XI

    Have you tried using variables? While they wouldn't work within a crosstab you can get the counts you need easily.
  6. N22S

    Crystal Reports - display null/zero values in a cross tab and/or chart

    Here's my last thought - create 12 different formulas for each month and qualify what appears for the formula based upon the month required. For example, if month({posting date field} = 4 then sum({fields used for posting}) else 0
  7. N22S

    Crystal Reports - display null/zero values in a cross tab and/or chart

    Have you tried converting the null values to zero? For example, if isnull({field or formula}) then 0 else {field or formula}
  8. N22S

    Duplicating values within a variable

    BTW - Using CR 8.5
  9. N22S

    Duplicating values within a variable

    A support person sent me the following message: "I ran the corrected report that against production data on the host and received the same problem. The class on the top of page 4 had a standby count of 0/2 and all the othere ones that followed it contained the same value which was...
  10. N22S

    Report Distribution Expert

    Does anyone know if Crystal Decisions plans on supporting the Report Distribution Expert add-in for release 9?
  11. N22S

    Filtering a Database Query

    In order to improve response time, I want to limit the amount of data queried from an Oracle database. For example, if I'm querying a table to create a financial statement only reflecting data from period 9, I only want to query the database fields containing that period's data instead of all...
  12. N22S

    Where did my budget go??

    Beth, Sorry that I'm late to the conversation. I've written and supported Crystal financial statements using Lawson. It does sound like an issue with joins. Try a left join from GLMASTER to FBDETAIL and a left join from GLMASTER to GLAMOUNTS. Link on the Company, Accounting Unit and...

Part and Inventory Search

Back
Top