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 strongm 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. JaneKOS

    Report running too slow

    Sorry, what do you mean by nested formulas? Apart from some title formulas that work out the week ending Friday date, these are all the formulas in the report? Thanks, JG
  2. JaneKOS

    Report running too slow

    The only record selection I have is: {PMA_TBL.PMA_PART_ONLY}startswith"19HAN007" and this is the SQL query that shows: SELECT "PMA_TBL"."PMA_PART_ONLY", "API_STK_TBL"."ASTK_REFERENCE_1", "API_STK_TBL"."ASTK_QTY_1", "API_STK_TBL"."ASTK_WHEN_1", "API_STK_TBL"."ASTK_WHEN_2" FROM...
  3. JaneKOS

    Report running too slow

    I'm trying to write a report to show the available capacity of a component over the next 26 weeks. There are 26 columns and in each one I determine the PO demand (Po) in the detail of the report then sum in the footer. There is no grouping in the report and only 2 linked tables. The following...
  4. JaneKOS

    How do I remove Simplify Headers Default on Crystal to Excel Export?

    My Crystal report exports beautifully into Excel if I untick the Simplify Headers box but even if I save, it automatically defaults back to being ticked. I don't want my users to have to remember to do this each time. Is there a way of setting the default to unticked?
  5. JaneKOS

    IF Statement

    Hi BeeBear, Splitting into 2 formula's then testing on the year has worked perfectly, thank you. Jane.[2thumbsup]
  6. JaneKOS

    IF Statement

    I have 2 years worth of forecasts stored in my MSC_TBL. I've written a crystal report to pull through quantities forecast by month, starting with the current month and showing a rolling 12 months. Using the following I'm returning both 2010 & 2011 values. I want to bring back only 2010 if it...

Part and Inventory Search

Back
Top