Help needed on a report.

[former_member823006]

Hi Experts,

I am getting stuck into the below code:.

I am working on a report fetching data from 2 tables. But while fetching data it satisfies the where condition but not the 1 where XBLNR in both tables not same.

I mean there is a common field XBLNR in both the tables which is not the primary key. I want to show the data fetching while there is data in the field or not..

It will fetch data whether it contains equal value or blank value in XBLNR.

Please check the below code...it is only showing that data which is same, I also need that data which is not equal to

RSEG-XBLNR ne RBKP-XBLNR.

Thanks,

Deepanshu.

<removed by moderator>

Moderator message: please post only relevant code parts, your posts must contain less than 5000 characters to preserve formatting, also please choose more meaningful titles for your posts.

Edited by: Thomas Zloch on May 16, 2011 3:11 PM

[former_member823006]

Hi Experts,

I am getting stuck into the below code:.

I am working on a report fetching data from 2 tables. But while fetching data it satisfies the where condition but not the 1 where XBLNR in both tables not same.

I mean there is a common field XBLNR in both the tables which is not the primary key. I want to show the data fetching while there is data in the field or not..

It will fetch data whether it contains equal value or blank value in XBLNR.

Please check the below code...it is only showing that data which is same, I also need that data which is not equal to

RSEG-XBLNR ne RBKP-XBLNR.

Thanks,

Deepanshu.

<removed by moderator>

Moderator message: please post only relevant code parts, your posts must contain less than 5000 characters to preserve formatting, also please choose more meaningful titles for your posts.

Edited by: Thomas Zloch on May 16, 2011 3:11 PM

[Former Member]

hi,

according my understand you need all values of XBLNR if it contan's value or not. if is right then why did you write where condition on this field. remove that then you get all XBLNR values

[former_member823006]

If you check i have given the 2 tables which are having same fields..

I want if

<tab1>-xblnr = 1 and <tab2>-xblnr=1.......... Display the corresponding data.

<tab1>-xblnr = 2 and <tab2>-xblnr=3.......... Again display data.

I need to add 1 condition:

if <tab1>-xblnr (not equal to) <tab2>-xblnr

select .........<query>.

Here I am not getting how to code the above condition.