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!

Recent content by mildoo

  1. mildoo

    Creating parameter fields

    Crystal reports 10 Oracle9i database I have created a parameter for a number field but the drop down displays eg. 17.00 I want to remove the .00 and display just the 17 any ideas,
  2. mildoo

    values not in table

    Yes I can create a view in the Oracle Db.
  3. mildoo

    values not in table

    I can do some SQL in Crystal 10 Yes the LHS and RHS fields are in the same table. Yes, I want all the numbers from the submission table that do not appear in the LHS or RHS fields.
  4. mildoo

    making a list from two colums in the same table

    Crystal reports 10 Oracle9i database What I want to do is create a list from two fields(number) in the same table listing all entries in the first field followed by all entries in the seond field eg. Field 1 Field 2 1 4 2 5 3 6 Result 1 2 3 4 5 6
  5. mildoo

    making a list from two colums in the same table

    Crystal Reports: I am trying to make a list from two fields in the same table. Ant ideas?
  6. mildoo

    values not in table

    Thanks katy44. This is all new to me. I am using crystal reports 10 and an Oracle db. The two tables I am using are called submission and match. The submission table holds all application numbers which have been sent to our system. The match table holds all the application numbers which have...
  7. mildoo

    values not in table

    I have a table (table1) with one of the fields storing numbers this is joined to another table (table2) which also has a field storing numbers. What I want to do is display the numbers from table1 which are not matched with the numbers in table2. Any suggestions?
See more

Part and Inventory Search

Back
Top