Report Books - If Statement
Hi There,
I am trying to create a book with a loop on our UD4 (project). I have it working but I want to add an IF statement to filter out tabs that contain no data. Referencing a previous post, I ...
Forum Discussion
Cube view Filter:
FullFilter:FilterMembers(RemoveZeros(Cb#Project:E#PRJ_Top:C#USD:S#PRJ_Planning:T#2026:V#Periodic:F#PRJ_100_None:O#Top:I#Top:A#PRJ_TeamFTE:U1#None:U2#PRJ_Top:U3#PRJ_Top:U4#PRJ_Top:U6#PRJ_Top:U7#None:U8#None), [U5#PRJ_Top.Base.Where(Text5 = 4010)])
Data Buffer Size: 32
Book Filter:
FullFilter:FilterMembers(RemoveZeros(Cb#Project:E#PRJ_Top:C#USD:S#PRJ_Planning:T#2026:V#Periodic:F#PRJ_100_None:O#Top:I#Top:A#PRJ_TeamFTE:U1#None:U2#PRJ_Top:U3#PRJ_Top:U4#PRJ_Top:U6#PRJ_Top:U7#None:U8#None), [U5#PRJ_Top.Base.Where(Text5 = 4010)])
Data Buffer Size: 0
Somehow the filters are the same but returning differing Buffer Sizes.
Book Setup:
Does it work with a basic MemberExpansion of Base? The only thing I can think is that the .Base.Where(Text5 = 4010) might need quotes. Meaning: .Base.Where(Text5 = '4010').
I've tried just about everything, Base without Text5 doesn't work, I manually hardcoded the MemberList that doesn't work either, must be a bug in a book, It's very strange and I think its related to the data buffer returning nothing when running a book, I run the cube view and it works just fine. I'm going to try to switch to an XFBR and see if a common separated list works. But I'm not confident that will work either since the issue seems to be with the data buffer actually returning anything when running a book. If you have time to look at this further I'd be happy to set up a call to discuss, I'm really at a loss of ideas.