Report

[former_member203104]

Hi

Can anyone help on this.

I have different Accounts with different condition types Z1,Z2,Z3,Z4

I want a report with the accounts which doesnt have condition type Z1.

Account1 has Z1,Z2,Z3,Z4

Account2 has Z2,Z3,Z4

Account3 has Z1,Z2,Z3,Z4

Account4 has Z2,Z3,Z4,Z5

report should display

Account2

Account3

Thanks

[anshu_lilhori]

Hi,

Simplest way to achieve the same will be:

Make new selection  say S1 take any keyfigure and restrict with condition type = Z1

So against account3 and 4 it will not display any data.

Now create a condition on that selection S1 = 0

Then it will display only account 3 and 4 .

Hope that helps.

Regards,

AL

[former_member182470]

What is complex in this requirement?

Keep the Condition Type in Filter pane and restrict with (Exclude Z1). This will appear as = symbol in red.

Keep Account in rows pane.

Actually your report should display Account 2 and Account 4

Regards,

Suman

[former_member203104]

Hi Suman,

if i do as you said report wil pick the other condition types from the other accounts and display the result

i dont want it that way

I want to exclude the total Account if it contain Z1 at infoprovider lever.

Hope you understood my requirement

Thanks

Bhanu

[former_member182343]

Hi,

Restrcit KF (RKF1) with Condition type Z1.

Now write condition - (RKF1 is NE 0 * 0) + 1

Now write a condition on RKF and ask to dispaly values GE 1.

Now all the records with Z1 condition will filter out.

WR,

Vijay

[former_member182470]

Hi,

I got an idea.

Keep Account No in rows pane and don't keep anything in Filter pane of the query.

Convert Condition Type Char into KF by using Formula variable.

Create a Condition on Condition Type KF which you created above, like Not Equal to values Z1

Hope this may give you desired results.

Regards,

Suman