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 Rhinorhino 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. SmpTraining

    ORA-04103 errors

    Hi All, I'm quite new to PL/SQL and so may be missing something simple but... I get many errors when running the following PL/SQL code create or replace PACKAGE BODY OCC_POPULATE AS ------------------------------------------------------- procedure occ_main AS BEGIN...
  2. SmpTraining

    Basic SQL Question

    Hi guys, I'm having trouble finding a table/field name so I thought of entering a rogue value using the front-end and searching all the fields for this value. I don't know how to write the SQL for this though. select distinct t.table_name, f.field_name from user_tables t, dict_flds f where...
  3. SmpTraining

    Oracle SQL help - Financial Year

    Hi All, I am trying to get an SQL WHERE clause to select records for the current finacial year only. Therefore it needs to take the 'sysdate' and, depending on the month, create a query against a date of either A) my_date >= 01/04/YYYY and my_date <= 31/03/YYYY+1 OR B) my_date >=...
  4. SmpTraining

    Can you count repetitions in a string?

    I have a VarChar2(366) field that contains a series of letters (such as 'AAAAAXXAAAABXXAAAAA' and so on. Is there anyway I can count all the As, Bs and Cs using SQL or must I use PL/SQL? Many thanks. Steve Steve Phillips, Crystal Trainer/Consultant http://www.smptraining.co.uk
  5. SmpTraining

    How to connect to TAS BOOKS?

    Can I connect to TAS BOOKS and if so how? Cheers Steve Phillips, Crystal Trainer/Consultant http://www.smptraining.co.uk
  6. SmpTraining

    Performance of Crystal and Lotus Notes

    I have a client who uses Crystal to access a Notes database over a relatively slow WAN link (256kbps). They are experiencing performance problems and I need help diagnosing the problem. This is a summary of what I've found out so far. When you design a report in Crystal it connects to the...
  7. SmpTraining

    Adding comments to your record selection criteria

    If you edit your record selection criteria using the Report->Edit Selection Formula->Record menu, you will find you can add comments to your selection. If you subsequently use the select expert to alter the selection criteria, you will often find the comments get removed. So, to keep your...
  8. SmpTraining

    Office XP Pro installing as Standard - Help!

    I have purchased Office XP Pro Special Edition but when I run it, it only offers the Standard upgrade options. That is, it does not want to upgrade Access. In fact, the install screen says 'Office XP Standard' rather than Professional. The CD is genuine, it has all the holograms saying...
  9. SmpTraining

    Can XP show a log of dialled numbers?

    I have an ongoing dispute with my ISP. I have subscribed to a service whereby I pay £15 (GBP) per month and get 40 hours per week free connection. However, my phone bill included £128 of calls to the ISPs chargeable telephone number!! I had only one dial-up connection configured and it was...
  10. SmpTraining

    Does XP log the numbers dialled?

    I have an ongoing dispute with my ISP. I have subscribed to a service whereby I pay £15 (GBP) per month and get 40 hours per week free connection. However, my phone bill included £128 of calls to the ISPs chargeable telephone number!! I had only one dial-up connection configured and it was...
  11. SmpTraining

    Syntax for 'Find and replace' in SQL

    Hi, I need to search for the text 'Org Unit n' or 'Org Unit nn' and replace it with 'n' or 'nn' where n is a number between 1 and 16. The same objective would be achieved by searching for 'Org Unit ' and replacing it with blank. How can I do this using an SQL command? Thanks for your help...
  12. SmpTraining

    Basic SQL question

    Hi all, I need to change the size of a column. I'd normally do this using TOAD (or ask someone else!) but I'm using SQL Plus. Can you tell me the syntax please? I am making some columns bigger and some smaller. I do not need to maintain the data in the columns but I do not want to create...
  13. SmpTraining

    Basic Oracle SQL Query

    I am trying to update a field in one table with a value from another table and don't know the syntax. Table1: PEOPLE Table2: DATA_IMPORT tables link on NI_Number field Want to copy Data_Import.Status field into People.Status field where the NI numbers match. Can anyone help please? Steve...
  14. SmpTraining

    Printing to alternative trays

    I have a multi-page letter that needs to be printed on headed stationery. Crystal does not seem to accomodate this. I am trying to work around this by creating formulas containing the printer escape codes and including these in the report. This does not seem to be working. Any ideas anyone...
  15. SmpTraining

    Mailmerge Error - &quot;Word was unable to open the datasource&quot;

    I'm setting up a mailmerge document which points to an ODBC data source which is a TXT file (tab delimited). There's only ever one record in the file and its being pulled into word to create a letter. I've successfully created one letter out of three. Both of the other two are causing me...
  16. SmpTraining

    Maximum number of loops (For..Next)

    Crystal's web site says that the max number of array elements (in v8) is 1000. I have a bubble sort that tries to sort about 260 array elements and I'm getting the message: &quot;A loop was evaluated more than the maximum number of times allowed&quot; As a bubble sort looks like this: For...
  17. SmpTraining

    Adding an index to a report

    Has anyone tried adding an index to a report. Basically I have a list of schools and their addresses spanning about 60 pages, I want to add an index to the schools such that the page number appears alongside the school name at the front of the report. Any neat ideas? Steve Phillips, Crystal...
  18. SmpTraining

    Want to Calculate 'Age'

    Has anyone got a neat formula to calulate the Age of someone at a given date. My report accepts a parameter field of {?date} and I have a Date of Birth field called {DOB}. DateDiff does not do the job. Subtracting the dates then dividing by 365.25 is the nearest solution I'm using at the...
  19. SmpTraining

    Hierarchical Grouping

    Has anyone used this in anger yet? I've dabbled with the feature but I don't think it will solve my requirements. any suggestions welcome. Requirement: My client wishes to Reporting from PeopleSoft tables using the 'tree' structures PS makes extensive use of. The trees provide a powerful...
  20. SmpTraining

    Error when &quot;Saving As&quot;...

    Hi, I get a strange error message at one of my client sites when saving a Crystal Report using the 'Save As' option. The pop-up error message says: <filename> Cannot find this file Please verify that the correct path and file name are given Clicking on OK takes me back to the report without...

Part and Inventory Search

Back
Top