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 MrArmstrong

  1. MrArmstrong

    Table Joins

    This is complete now thanks for the help.
  2. MrArmstrong

    2 Unlike Tables in Details

    I am still trying to learn this SQL stuff, this is the SQL statements from these to reports that are just alike: SELECT "SO_HDR"."CUST_REF3", "SO_HDR"."DOC_NO", "SO_HDR"."DOC_TYPE", "SO_LINE"."PARTNUMBER", "SO_LINE"."QORDER", "PO_LINE"."DOC_NO", "SO_LINE"."STATUS", "SO_LINE"."UNITP"...
  3. MrArmstrong

    Grouping Formula Fields

    Here is my SQL Query: SELECT "PO_HDR"."DOC_NO", "PO_LINE"."PARTNUMBER", "PO_LINE"."ADDED_DTE", "PO_LINE"."UNITP", "PO_LINE"."QORDER", "PO_LINE"."SUBTOTAL", "PO_LINE"."STATUS", "PO_HDR"."CUST_REF3", "PO_HDR"."CUST_REF4", "PO_HDR"."DOC_TYPE", "STOCK"."STK_TYPE", "STOCK"."CATEGORY"...
  4. MrArmstrong

    Grouping Formula Fields

    I am feeling real Crystal DUMB right not, I can't get this one. Everytime I try to type it in it says failed to retrieve data. Maybe this will help. All my data comes from these three tables: PO_HDR PO_LINE STOCK Fields 131A006-11-23 DP 50 SOFTWARE (VDD-09BR) 1 BREAKDOWN Example...
  5. MrArmstrong

    Grouping Formula Fields

    Sorry for the delay but I have been trying for 2 days to figure out what you are telling me to do but I have never used the Command or parameter part of CR XI. I have created a formula of the count that gives me the number of occurences in the group footer.That is better than a summary field...
  6. MrArmstrong

    Update a Column While in Query Mode

    Successful thank you for your help.
  7. MrArmstrong

    Grouping Formula Fields

    Part Number Description qty 114HS122-1 VALVE, LINEAR DIRECT 1 occurences 1 114R3119-3 SPACER 1 114R3119-3 SPACER 1 114R3119-3 SPACER 1 114R3119-3 SPACER 1 occurences 4 114S4909-50 PLATE 1 occurences 1 114SS660-1 MOTOR, HYD. 1 occurences 1 115785-01 CONNECTOR, PLUG ELEC 1...
  8. MrArmstrong

    Grouping Formula Fields

    Hello all , I am running Crystal Reports 11, I have a report that is focusing on counting all of our Purchase Orders. I had to count and see which parts are ordered the most.I was successful in doing a count on the PO.Partnumber field , which gave me a count of how many times each part number...
  9. MrArmstrong

    Update a Column While in Query Mode

    Thanks I'll give it a try.
  10. MrArmstrong

    Update a Column While in Query Mode

    Can I repeat this same command over again for each different number like Max= 2 OPT=1 and so on or will it fail. I want to find the easiest way to knock this out in one shot if possible.
  11. MrArmstrong

    Update a Column While in Query Mode

    Here are a few colums: SELECT *,MAXQTYLEVEL AS Expr1 FROM STOCK WHERE (MAXQTYLEVEL =6) PART NUMBER DESCRIPTION MAXQTYLEVEL OPTQTYLEVEL 000-36689 TELEPHONE 6 0 01-P24481F001 POWER CONTROL...
  12. MrArmstrong

    Update a Column While in Query Mode

    I have a table that I need to update one field based on another field . This is my Stock table for all the parts we stock. I need to go update the table reorder points. So a scenario would be where we have stock.Field 6 I need to change the reorder point.field to 4. Where we stock 100 I need to...
  13. MrArmstrong

    2 Unlike Tables in Details

    Here is an example: Part Number Qty Price Date Customer Type 490445-98 63 87 12/6/2005 Tool Room Company 145E3569-1 1 45 8/7/2006 Bill Johnson Customer 114S5589-7 5 98 9/6/2007 Emily Thomas Customer 4500-963 25 875 11/7/2009 Avionics Shop Company Here is an example of how I want it to look...
  14. MrArmstrong

    2 Unlike Tables in Details

    I am running CR XI, I need to know if there is anyway to show the details of two different tables. They are not tables that should be linked together but they have similar data. Example: Table 1- Customer Orders Customer Orders.Partnumber Customer Orders.Qty Customer Orders.Price Customer...
  15. MrArmstrong

    Will any other Programs open a Crystal Report

    My apologies for going backwards here, but before I suggest this purchase to my management I want to be sure of one thing. The Crystal Reports Developer XI does not have a built in scheduler that updates at given periods without the file being open, Correct? So, I do need an additional...
See more

Part and Inventory Search

Back
Top