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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- Jack3d
- Thread
- Replies: 0
- Forum: Information Builders, Inc.: WebFOCUS
-
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...- Jack3d
- Thread
- Replies: 0
- Forum: Information Builders, Inc.: WebFOCUS
-
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- Jack3d
- Post #3
- Forum: Information Builders, Inc.: WebFOCUS
-
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 |...- Jack3d
- Thread
- Replies: 2
- Forum: Information Builders, Inc.: WebFOCUS
