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

    ORA-00206: error in writing (block 3, # blocks 1) of controlfile

    Hi I am quite new to Oracle and have recently encountered this intermittent problem. It is now happening about twice a week and the rest of the time functions properly. Errors in file D:\oracle\admin\ernie\bdump\ernieCKPT.TRC: ORA-00206: error in writing (block 3, # blocks 1) of controlfile...
  2. puma51

    SELECT RETURNING MULTIPLE ROWS

    Hi I am trying to do an insert into a table but it is returning multiple rows. The source table contains the following:- Plan_No, Plan_Date, Company_No, User_No 123456, 01/01/2007, 456, 5 543454, 07/02/2007, 456, 4 345654, 21/03/2007, 456, 5 My select is as...
  3. puma51

    Crystal Returning Wrong Results

    Hi Crystal 10 and Oracle 8 I have created a view in oracle which when queried through SQL+ or MS Access returns correct results. When I use Crystal to connect to the view it returns completely different results. The view has a condition that excludes records with a date range of <'01-JUN-05'...
  4. puma51

    Column Layout Problem

    Hi Using Crystal 10 and Oracle 10 I have a report that prints off event attendee names on badges. The Names are in the detail section of the report and I have formatted the section using 'Format with Multiple Columns' to create two colums of names across with five badges down i.e. 10 per page...
  5. puma51

    Complicated calculation

    Hi Using Crystal XI on SQLServer 2000 I have a table of orders with the fields org_name and order_date. I want to identify the organisations that have had an order in a date range based on a parameter date field but who have not had an order in the 12 months prior to the latest date found in...
  6. puma51

    Problems with totalling and rounding

    Hi Using Crystal 10 and Oracle 81. I have a simple report which calculates Gross * VAT @ 17.5%. I have to format the VAT field to 2 decimals places and round up to 2 characters to get the amount to display exactly right. E.g. 65 * 17.5% equates to 11.375 which I round up to 11.38 When I then...
  7. puma51

    Crosstab Export - Crystal 11

    Hi Using Crystal 11 and SQLServer 2000 I see that there are a number of posts for this already but no obvious answers - can anyone help? I have a number of identical reports containing crosstabs which I connect to different customer databases on same SQL server. These need to be exported to...

Part and Inventory Search

Back
Top