Grouping in Reports - Single Category Header

Seth_Kling · 04-07-2021 11:06 AM

I am missing something small, I can feel it .

I found this on the forum - and it got me to a 90% solution:
Single Category Headers in workflow

My Solution:

<<Start: ORDERBY(FILTER("Next Day Scheduled Trips", ([_ROWNUMBER] = MIN(SELECT(Next Day Scheduled Trips[_ROWNUMBER], ([_THISROW-1].[dvrcallsign] = [dvrcallsign]))))), [dvrcallsign])>>
    <<Start: FILTER("Next Day Scheduled Trips", ([_THISROW-1].[dvrcallsign] = [dvrcallsign]))>>
    <<if:[tripid]=INDEX(orderby(Next Day Scheduled Trips[TRIPID], [dvrcallsign]),1)>>
    <<[dvrcallsign]>>
    <<endif>>
    DATE: <<[DATE]>>
    TIME: <<[TIME]>>
    VEHICLE: <<[VEHICLE]>>
    DVRCALLSIGN: <<[DVRCALLSIGN]>>
    PUTIME: <<[PUTIME]>>
    DOTIME: <<[DOTIME]>>
    PUADDRESS: <<[PUADDRESS]>>
    DOADDRESS: <<[DOADDRESS]>>
     <<End>>
    <<END>>

The result:

What did I miss to make the ‘next’ driver have its own header?

Marc_Dillon

The problem is your template if statement.

I’d suggest something like

<<IF: [_THISROW] = MINROW( table, "_RowNumber" , [callsign]=[callsign]>>

Seth_Kling

That did not give me any errors, just reversed my missing header issue

<<Start: ORDERBY(FILTER("Next Day Scheduled Trips", ([_ROWNUMBER] = MIN(SELECT(Next Day Scheduled Trips[_ROWNUMBER], ([_THISROW-1].[dvrcallsign] = [dvrcallsign]))))), [dvrcallsign])>>

<<Start: FILTER("Next Day Scheduled Trips", ([_THISROW-1].[dvrcallsign] = [dvrcallsign]))>>

<<if:[tripid] = minrow(Next Day Scheduled Trips, “_rownumber”, [dvrcallsign] = [dvrcallsign])>>

<<[dvrcallsign]>>

<<endif>>

DATE: <<[DATE]>> TIME: <<[TIME]>> DVRCALLSIGN: <<[DVRCALLSIGN]>> PUADDRESS: <<[PUADDRESS]>> PUTIME: <<[PUTIME]>> DOADDRESS: <<[DOADDRESS]>> DOTIME: <<[DOTIME]>>

<<End>>

<<END>>

Marc_Dillon

Seth_Kling

You rock for helping me through this…
You rock for not going holier than thou on me

BUT… Now I get the header over every row…

Marc_Dillon

Thought that would have worked. I can’t get into this any deeper right now. But you should notice that there are 7 other threads linked to that thread of mine that you linked, I suggest you do more research. I know @Aleksi had posted somewhere another good method for this.

Seth_Kling

Awesome. I will