BusinessObjects Board

MAJOR!! Filtering Problem

building reports desktopintelligence
#1

Hi,

I have two identical Data Providers, they both retrieve data in a simple format such as;

AAA
BBB
CCC

I wish to section a report based on my first data provider and then only show the values from the second data provider, which are equal to or less than the current section. ie.

AAA AAA

BBB AAA
BBB

CCC AAA
BBB
CCC

Has anyone done this? or know how to do this. I’ve slowly tried everything I know.

Thanks in advance,

Stuart

stuartgmilton :uk: (BOB member since 2003-01-30)

#2

Stuart,

I’ve been playing with this and haven’t figured it out yet. I’m thinking that we may first need to eliminate the display of missing rows from the second data provider. I started with this approach, but haven’t gotten to work. See if you can get it to work, and we’ll go from there.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)