PDF Grouping a part of the data [UPDATE]

[Hussein_Osseily]

Hello Everyone,

I know PDF grouping has been discussed a lot, i just couldn’t find something similar to this case.

Below is the template am using to generate a load list of every truck.
This will generate a pdf of every truck reference.

The data in red is unique / same for every truck Ref

The data in green are different as it’s the shipments / cargo details.

What i am trying to acheive here, is to generate one PDF file that will include all the lists that are trucked by the same trucking supplier (column name [Trucking by])
All data are in the same table “Unplanned Shipments”

Updated:

I added an outer Start select expression as below, it works but if the same Truck Reference has several Shipments its creating severals of the same reference .

Any help would be appreciated.

[Suvrutt_Gurjar]

@Hussein_Osseily

I added an outer Start select expression as below, it works but if the same Truck Reference has several Shipments its creating severals of the same reference .

You may want to try below.

Please create a slice called something like “Minrow_Slice” with an expression something like

[ID]=MINROW(“LL”, “_ROWNUMBER”, [Trucking By]=[_THISROW].[Trucking By])

Then your outer START expression can be something like

<<START: Minrow_Slice[ID] >>

[Hussein_Osseily]

Thanks sir, this helped a lot and it works in my case.
Other workaround that i just figured:

Virtual column Grouping:

ORDERBY(SELECT(Unplanned Shipments[ID],AND([Trucking By]=[_THISROW].[Trucking By],[Truck Ref]=[_THISROW].[Truck Ref])),[ULD],TRUE)

Template:

<<Start: SELECT(Unplanned Shipments[ID],AND([ID]=INDEX([GROUP],1),[Trucking By]=[_THISROW].[Trucking By]))>>

<<Start: [GROUP]>>
<<End>>
<<End>>

[Suvrutt_Gurjar]

You are welcome.