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!

  • 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. Jack3d

    time period drop down

    We have a lot of report requiring a date range for users to enter, but we also need a way for users to quick select a time period (last week, last month, last quarter, year to date, etc...) and that auto populates the correct dates for report to run. We currently have this code in a SQL stored...
  2. Jack3d

    Side By Side Report

    How can I get this example to be side by side on one page in a fex? So the left side of page would have ENGLAND cars and right sode would have FRANCE cars. For the report I am creating there also needs to be a header and footer for report name, run time, etc. -* File side_by_side.fex...
  3. Jack3d

    rows into column grouped by same ID

    I need them all in single column and I got what I needed with this: DEFINE FILE xxxx PRODUCTS/A100V = IF DEPID EQ LAST DEPID THEN PRODUCTS || ', ' | PROCODE ELSE PROCODE ELSE CLUSTER_PRODUCT_INFO.TBLPRODUCT.CODE; END TABLE FILE xxxx SUM PRODUCTS BY DEPID END
  4. Jack3d

    rows into column grouped by same ID

    Im new to WebFocus and need a way to get multiple rows with same ID into a column separated by commas grouped by the ID. --Before DepId | ProId | ProCode 1 | 1 | PM 1 | 2 | IM 1 | 3 | SSO 1 | 4 | ECM 2 | 1 | PM 2 | 2 | IM 2 | 3 | SSO 3 | 2 | IM 3 | 3 | SSO 3 | 4 | ECM --After DepId |...

Part and Inventory Search

Back
Top