Adding Rows that don't exist

• Jul 9, 2007

• #2

jimster06

Programmer

Jul 15, 2003

53

US

Have you considered McGyver technique?

 

Upvote 0 Downvote

• Jul 11, 2007

• Thread starter
• #3

floydome

Technical User

Feb 27, 2007

9

US

No i have not. will this work with McGuyer?

 

Upvote 0 Downvote

• Jul 18, 2007

• #4

focwizard

Vendor

Apr 18, 2002

258

US

What's the structure of your table(s)? Are we talking multi-segment (parent-child), where tenure is parent of headcount? If so, then you can SET ALL=ON, to get parent instances without children. OTW, how does the report KNOW about tenure 02-03?

 

Upvote 0 Downvote

• Jul 18, 2007

• Thread starter
• #5

floydome

Technical User

Feb 27, 2007

9

US

The table consist of Fields - Tenure , Headcount , Joblevel etc
There are some job levels that have headcount in each tenure while there are some that are missing headcount in some tenures. My goal is to display all tenures. Once i can display all tenures for each joblevel, then i have some furthur calculations. I will try Set all = on. Hopefully it works
Thanks

 

Upvote 0 Downvote

• Aug 13, 2007

• #6

focwizard

Vendor

Apr 18, 2002

258

US

In your report, you can EXPLICITLY specify which rows you want, and in which order, by using the ROWS command. Assuming you have a field which is called something like TENRNG, like this, for each field:

Code:

TENRNG/I2 = IF TENURE FROM 0 TO 1 THEN 1 ELSE
            IF TENURE FROM 1 TO 2 THEN 2 ELSE ...

You can code something like this:

Code:

SUM TENURE FOR TENRNG
1 AS 'Tenure 00-01 Headcount' OVER
2 AS 'Tenure 01-02 Headcount OVER ...

This use the FRL facility of the TABLE command.

 

Upvote 0 Downvote