Weird Sub Section Join

[fguerreroga]

I am designing a report with the following sections:

- A main section based on a view that joins F4801 and F4102

- A subsection based on V3111H and joined to the main section by DOCO and DCTO.

- Another subsection based on V3112A and joined to the main section also by DOCO and DCTO.


The problem I have is that for some work orders, the report jumps from the first subsection to the second and then returns to the first one (without change in the join fields), apparently with no reason.

I don´t know if the fact that I use Supress Section Write sometimes in both sections may be confusing the engine.

I am completely lost, so any help would be appreciated.



One World Xe, SQL Server

 

[JulienW]

Hi,
This is obviously very confusing for the engine.
What you could do is create a custom section, that you would call in the 'before level break' event of your main section. In this event you write a F3112.Select (with BC values), then F3112.FetchNext to get your primary index; then , While Success 'Do Custom Section',
hope this is clear enough,
Julien