Filtering Data

building reports desktopintelligence
1

You might try creating a variable, let’s call it LastMonth with the
following formula:
If create_date = last month Then 1 Else 0

Then create the following filter:
LastMonth = 1.

Sometimes, I get the same error and the above procedure usually cures it.

Robert
Schmidt Interactive Software, Inc.

Listserv Archives (BOB member since 2002-06-25)

2

Robert,

Thanks - that did the trick. I appreciate your help.

Marian

Listserv Archives (BOB member since 2002-06-25)

3

Hi, let me explain my problem. I have two queries, each to a different Universe. I want to filter data in one query in function of another variable in the other query.

For example:
Query A has the following columns: Id, date, Name. Query B has the following: Desc, ProbId, date

ProbId and Id have the same type of data, what i want to do is to show in Query B only the rows where ProbId = Id.

I’m trying to use complex filters, but it always says that variables are not compatible.

Desired result:
Initialy:
Query A Query B
Id date Name Desc ProbId date
2 yyy bbb ccc 5 rrr
4 yyy vvv sss 4 hhh
6 yyy xxx ttt 4 uuu

Result:

Query A remains the same Query B
Desc ProbId date
sss 4 hhh
ttt 4 uuu

Thanks in advance
Paulo ValÈrio
paulo.valerio@optimus.pt

Listserv Archives (BOB member since 2002-06-25)

4

Depends what you want in your block but basically you need to link the ProbID and the ID and see where you go from there. If the other objects need to be displayed what you will probably have to do is create detail object variables for the other dimensions and use those in the block instead. Then you acn filter where using not isnull().

Ken.

Listserv Archives (BOB member since 2002-06-25)