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 bkrike 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: tsjd
  • Content: Threads
  • Order by date
  1. tsjd

    Numbers not displaying properly in crystal 8.5

    I'm facing a problem with crystal report 8.5 where the fields are unable to display the full range of numbers. The field which I am pulling data out from has 18 digits 221922000000000002 which is an account code. What i'm getting out of crystal when I display is 1.11e+017 which makes me unable...
  2. tsjd

    Formula for displaying monthly data

    I need a formula (using two parameters, month and year) which would display the records of a certain month without using any date formula as the fiscal year of the company is different compared to a calendar date. Basically the fiscal period (month) within the pervasive sql data is of a number...
  3. tsjd

    Summing running totals by group

    I have a table e.g like this Fiscal Period Name Total ------------- ------ ------- 01 xx 5 01 xx 5 02 xx 4 02 xx 3 03 xx 2 How do I create a running total for each one of the periods at the end of each...
  4. tsjd

    Displaying records of a certain period

    I need help on how to set 2 parameters to view a report from a certain period to another period. For e.g - Displaying a record from 01/01/06 - 31/01/06
  5. tsjd

    Surppressing negative values

    I have a table and I wish to suppress certain fields where the amount is a negative one. E.g. Customer Name Total ------------- ----- zxczxczxczxcx 3 adb -4 llalal 5 How do I suppress the whole -4 field as I have to show the total sales? I'm running Crystal 8.5...

Part and Inventory Search

Back
Top