NPrinting skipping levels

[markp201]

I'll try to explain this as accurately as possible because I can't upload the data or templates.

We need to show activity for the current selected date and MTD   We use simple sum,count, etc for the

daily totals but for MTD we use set analysis

DIrector	Manager	Employee	Daily	MTD
A	B	C	10	10
A	B	D	0	5
A	C	E	0	5
A	C	F	0	1
A	D	G	5	5
A	D	H	0	0

When we create the excel report with levels for Director and manager, we get the following

Director	Manager	Employee	Daily	MTD
A
	B
		C	10	10
		D	0	5
	B Total		10	15
	D
		G	5	5
		H	0	0
	D total		5	5
A total			15	20

Manager C is missing

From what we can tell, if there is no daily activity for the manager, the level is skipped even though we have MTD activity

Seems like a bug because when we dump the detail to a sheet everything shows up perfectly.  It's only when we apply levels

that rows are suppressed.   We even added a dummy column (=1) for every row but the suppression continued.

[markp201]

Discovered a bit more about this issue.  When we selected a date there was only activity

for employee C and G so their respective managers are included.

When we built the table (with MTD set analysis), employees E and F are included even though technically they have no activity for that date.

What we don't understand is why the table dump worked but the leveled report didn't.  It would seem nprinting should accept the entire table as input and construct the levels accordingly.

[glacoste]

- Director and manager are fields in your data model?, columns of a table box?, field of a list box?

- The report have filters?

[markp201]

Director and manager are fields.  The example shows the measures when filtered (e.g. date).

What we're looking to do is show activity for the date but show MTD activity as well.  If someone only has MTD activity, they do not show up in the report with levels but if a report without levels will show everything.

I'll try to create a mockup.