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

  1. Smirre007

    Sum list of transactions with a variable date on Crystal reporting 11

    Thanks, the above seems to take care of point 2 above "Not seeing Ins if there are no Outs, although still show blank gaps in the report. Not sure if there are any way of getting rid of the blank spaces. The formulae seems hise all the data but leaves blank gaps on the report. Point 1 is still...
  2. Smirre007

    Sum list of transactions with a variable date on Crystal reporting 11

    On the first point I am happy with the result; it shows the ins and outs as required, although if for example there are two ins on the same day then I get the same result twice on the report. On the 2nd point I get the In line with the 0%, although was hoping not to see Ins if there are no Outs.
  3. Smirre007

    Sum list of transactions with a variable date on Crystal reporting 11

    Thank you very much for the above and the result is almost what I need. It comes down to the 80% and yes you are correct in that I do have additional "in" values during the 5-day period. The result I am getting at the moment is working fine the only thing I can't get rid of is the duplicates...
  4. Smirre007

    Sum list of transactions with a variable date on Crystal reporting 11

    Ibass, Thanks for the response, You are correct in that I will have different client codes and different cash account number. I have added the client code and Account numbers in the mock data. I distinguish between "Ins" as positive amounts and "Outs" as negative amounts. I have attempted to...
  5. Smirre007

    Sum list of transactions with a variable date on Crystal reporting 11

    Hi I am new to Crystal reporting and hoping somebody can help with a query. I am writing a report to report rapid "in and outs" in cash accounts, but am having problems in getting my rapid outs of the account as I need to identify cash that have gone out of the account within five days of the...

Part and Inventory Search

Back
Top