Topic: [SOLVED] Difficulty getting a Group and Subreport section
A plea for some help again please.
I am trying to persuade Fast Reports to output the following.
In a group:
Supplier Name
Information about orders pertaining to that supplier
Person the order is for.
(repeat all orders and tech names for that supplier)
(move on to next supplier)
I have had some success, I can get the Supplier and information to display, I'm having a problem displaying the person the order is for.
I did manage to show just one person, but only for the first entry. I've now managed to lose even that capability.
So, my current problem is:
1. getting the person name to print or show.
2. Prevent printing of Suppliers who have no current orders .
I have used Dmitry's SubReports example as reference and have read the Fast Reports user guide for FR 4.0 but don't seem to be able to achieve the results that I'm looking for.
So just to recap, I'm looking for this result.
Supplier 1
item A_1
item B_1
item C_1
person name 1
item A_2
item B_2
person name 2
etc
Supplier 2
repeat as necessary
Supplier who has no orders - should not appear in the list. In the test case this would be Harbournes Haulage and Gametek.
I've attached a screen shot of what I'm currently achieving which is almost correct.
The code I'm using in FR4.0 is:
procedure MasterData2OnBeforePrint(Sender: TfrxComponent);
begin
MasterData2.Visible := <Technician."id">=<Requests."id_techname">;
// MasterData2.Visible := <Requests."id_techname">=<Technician."id">;
end;
procedure MasterData3OnBeforePrint(Sender: TfrxComponent);
begin
MasterData3.Visible := <Supplier."id">=<Requests."id_Supplier">;
end;