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!

Recent content by Johnsf

  1. Johnsf

    Year Start Formula

    Thanks Vidru... It works like a dream!!! [2thumbsup]
  2. Johnsf

    Year Start Formula

    Any one have any idea how to fix this problem? Cheers, JSF
  3. Johnsf

    Year Start Formula

    Oh and {?Run Date} = Today
  4. Johnsf

    Year Start Formula

    Crystal Enterprise: 8.5 OS: Windows XP I need to set the start of the Financial year to the day after the last Friday of November i.e. the start of the financial year this time is 27/Nov/2004 The below formula that sets the start of the year to the day after the last Friday of November worked...
  5. Johnsf

    Strange problem

    Its finally fixed.... changing from Native drivers to the Oracle ODBC drivers fixed it on the e-portfolio server. However it works even with Native drivers on my machine. Oh well as long as its fixed..... :D
  6. Johnsf

    Strange problem

    No Ive got just one datasource. Using an Oracle 9i database. The very same report when opened in Crystal Reports works perfectly using the same datasource. Its weird and I dont know what to do :-(
  7. Johnsf

    Using Third Party s/w for scheduling CR10 reports??

    I have found VisualCUT to be really good.
  8. Johnsf

    Strange problem

    So no one has any idea why Im facing this weird problem in e-Portfolio?
  9. Johnsf

    Strange problem

    Hi, Im running Crystal Enterprise 8.5 and have suddenly started facing a problem with something thats worked fine for ages. When I run the report in Crystal Reports it works fine and displays this: Avd A/c M A/c Name FI 3789/2 216561 XYZ Trust FI 3789/9 321615 JBC & Co FI 3789/12...
  10. Johnsf

    Modifying text file

    Thanks for that guys.... got it working :-) Cheers, John
  11. Johnsf

    Modifying text file

    Hi, Is there a way on Linux where by I can set it up to automatically open a text file every night and add a line of text right at the top of the file? I have a file which contains data and I need to add a header to it each night. Cheers, John
  12. Johnsf

    30 mins to run query

    Hi, The query below takes exceptionally long to run and I reckon its because of the last line in the where clause. Can someone advise on how to speed it up? What would you change the last line to? Cheers, John SELECT DISTINCT MGN.APTYID, MGN.APTYSUBACC, PTY.APTYNAM, MGN.AMKTCDE...
  13. Johnsf

    Scheduling SQL

    I would use at if I knew how to get it to run a query and dump the results to a file.
  14. Johnsf

    Scheduling SQL

    Ive got Oracle9i.... Is it possible to do it with this version? Where can I find instructions on how? Cheers, John
  15. Johnsf

    Scheduling SQL

    Hi, Does anyone know of any tool available for Windows with which I can schedule some SQL to be run every night and the results be exported to a plain text or csv file? Cheers, John
See more

Part and Inventory Search

Back
Top