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 Mike Lewis 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. VictorAst

    Macola and Using Wisys Agility Design Studio

    I have posted on SQL forum also, but was wondering if any Wisys Agility Design Studio programmers can help I am running a pivot grid to determine sales and am needing to get a percentage difference from two Aliases I created. I have the CASE statement below to determine the Difference, but...
  2. VictorAst

    Determine Percent Difference between two CASE Statements

    So I got a case of the "Staring at the screen too much and cant think" How would I write the sub query using the Aliases of YTD Diff and YTD 2015 Sales to determine the Percentage difference YTD Diff/YTD 2015 Sales = xxx.xx%
  3. VictorAst

    Determine Percent Difference between two CASE Statements

    Borkiv So I can use Aliases in a subquery? 2016 Sales, YTD 2015 Sales are Aliases
  4. VictorAst

    Determine Percent Difference between two CASE Statements

    I am working with Wisys Agility Design Studio and writing SQL statements to determine sales differences from year to year. Case where I determine the 2016 sales data CASE WHEN oehdrhst_wv.inv_dt LIKE '%2016%' THEN ( oelinhst_wv.qty_to_ship - oelinhst_wv.qty_return_to_stk ) *...
  5. VictorAst

    Print Picking Tickets Form Update

    I am currently on Macola 9.6.500 In the Print Picking Tickets form, the criteria is to search by a range of order numbers. We use a User_Def_Fld_1 in our Pick Ticket crystal report that is used for a Production Code. Example 11-13-X. I want to be able to modify the Print Picking Tickets form to...

Part and Inventory Search

Back
Top