topic Re: Help needed on a report. in Application Development and Automation Discussions

Help needed on a report.

former_member823006 — Mon, 16 May 2011 12:25:43 GMT

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.

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

Re: Help needed on a report.

Former Member — Mon, 16 May 2011 13:20:40 GMT

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

Re: Help needed on a report.

former_member823006 — Tue, 17 May 2011 04:37:28 GMT

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.