Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 15 Oct 2015 at 6:00am
1. Group by whatever is unique in each row.
2. Suppress the details and group header section.
3. Create two formulas that will look like this:
{@NET}
StringVar net_export;
if OnFirstRecord or {MyTable.GroupField} <> Previous({MyTable.GroupField} then net_export := '';
if {MyTable.EXPORT_NAME} = 'NET' then net_export := {MyTable.EXPORT};
net_export
{@FIRM}
StringVar net_firm;
if OnFirstRecord or {MyTable.GroupField} <> Previous({MyTable.GroupField} then net_firm := '';
if {MyTable.EXPORT_NAME} = 'FIRM' then net_firm := {MyTable.EXPORT};
net_firm
4. Put all of the data in the group footer section and use these formulas to get your two columns.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum