Problem with a report - help needed..

Hmm, I think you should re-structure you report a little, so that you have dataItem Sales Header first, I don't thik you should Salesperson as data-item. You could create a variable for that in order to Pickup the Name.

You could fill a temp-table on every change of Salesperson code of Sale Header you fill another Line with the data you need. (or add on existing Line)...

Or wait for more solutions on this form...

Maybe this will work (no temp tables, but more sections). if you have a lot of code behind sections / dataitems this might be a pain.

Dataitems:
-Salesperson/Purchaser
--Sales Header
---Sales Line
-Sales Header //this sales header dataitem has the filter 'Salesperson Code = '')
--Sales Line

You end up having duplicate sections, and you will may have to handle the totalling yourself. I would do it with temporary tables myself.


With temporary tables it would look like this:

temporary variable, tmpSP, salesperson table

1-Salesperson / Purchaser
2-Integer
3--Sales Header
4---Sales Line

Dataitem 1 - (no sections)
Set the DataItemTableView to use the Number key (so the section doesn't show up to the user)

OnAfterGetRecord:
tmpSP = Salesperson / Purchaser;
tmpSP.INSERT;

OnPostDataItem
tmpSP.INIT;
IF tmpSP.INSERT THEN; //in case a blank salesperson exists in the db

Then treat the Integer as your salesperson dataitem.
Dataitem 2
OnPreDataItem
tmpSP.RESET;
SETRANGE(Number,1,tmpSP.COUNT);
bFirst := TRUE; //new boolean global variable

OnAfterGetRecord
IF bFirst THEN BEGIN
bFirst := FALSE;
tmpSP.FINDSET; //or FIND('-'), depending on the version
END ELSE
tmpSP.NEXT;
SalesHeader.SETRANGE("Salesperson Code",tmpSP.Code); //need this to simulate the link between this section and #3

That is it - you will need to do whatever code you have in there now for the totalling, just remember you are dealing with the tmpSP record, not the Salesperson / purchaser dataitem.

-a