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 Chris Miller 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. CanoWermz

    Show SQL Query has 'NULL' as a Parameter in Crystal 9

    Disregard my request. A co-worker fixed it. I still don't know what I did wrong or how he fixed it, but it works.
  2. CanoWermz

    Show SQL Query has 'NULL' as a Parameter in Crystal 9

    Hello again Crystal Gurus! My particulars: Crystal 9 2 tier PeopleSoft 8.49 Financials Oracle 11g This is an existing report that works in production and I am trying to make some changes. When I do verify or anything database related to run the report, I only get to enter the last 2 of the...
  3. CanoWermz

    Subtract two summed detail amounts

    That works great lbass. Thank you very much!
  4. CanoWermz

    Subtract two summed detail amounts

    Two is the limit. Ideally we would have one ledger 1 and one ledger 2 per project, but sometimes we have 0 ledger 1 and a ledger 2 entry for a project. PROJECT A Ledger 1 amount PROJECT A Ledger 2 amount difference (working fine) PROJECT B Ledger 2 amount...
  5. CanoWermz

    Subtract two summed detail amounts

    I say summed, because it is summed in Query Manager prior to getting to Crystal. I guess it doesn't really matter in my case, it is just an amount. I did get it to work using the following. I do not always have 2 Projects though and that messes up my subtraction. Where should I reset the...
  6. CanoWermz

    Subtract two summed detail amounts

    Hi again, We are comparing ledgers. How do I subtract ledger 1 from ledger 2? Both rows are summed amounts in my detail section. A summary would be great, but there is every option BUT subtraction. Willing to change it up if needed. What do the techs say? PROJECT A Ledger 1 amount...

Part and Inventory Search

Back
Top