Issue on Report using 'Greater than or Equal to' anf 'Less than or Equal to' join BV

I have a BV joining a custom table (F55MAP) with Account Balance Table (F0902).
The logic is as follows:
The table F55MAP having OBJF(Object From), OBJT(Object Thru), a custome category code CAT99, and Desc. One record from the table is as follows:

So for one report, I have to sum and print all objects in between 500000 and 599999 under the category COST.

I have joined the 'Object From' with 'Greater than or Equal To' link to OBJ of F0902.
In the same way, 'Object Thru' with 'Less than or Equal To' link to OBJ of F0902.

Now, when I browsed the view using DATABROWSER and one custom application, I am getting the exact result.



But the records are not coming in report. I think why :-( ?

From the jdedebug.log, I have got the below query !!!

As we see, it is just = join.
It should be >= and <=.



I wonder WHY this happen only in reports ?

I'm confused

(> or =) and (< or =) is everything = isn't it?

You know E1 constructs it's SQL statement for UBEs in 3 steps right?

(VERSION coding) and (BSVW coding) and (internal ER coding)

Hi John.

The report giving no records, but the application gives records in the grid.

My query is, why the BV is working with application and not working in report.

Debug it with a breakpoint on the last line of the Init Section and then another on the 1st line of the End section (seen as it gives you no data)

Make sure you capture the SQL the section is creating. It should look like what I said above. 3 brackets. You must have section filtering on or some code in the Init section?

John,

Again, I came to the same kind of requirement. What should I write in Init Section.