I've created a QuickBooks-Excel Integration app for QB Desktop Enterprise Ed. 22.0+. I've been making some modifications to add extra functionality, but I've run into an old hangup that may not have any simple solution via QBFC's API.

The goal is to retrieve a list of customer:job names from QB using a Time by Job Summary report for a specific date range, then create a second Time by Job Summary report for ALL dates using the list of customer:job names from the 1st TbJS report. In every combination of syntax I've attempted, this fails. Here is how I currently have the relevant part of my code setup:

ElseIf lRunNo = 1 Then
 
        Set timeRQ = requestSet.AppendTimeReportQueryRq
        
        With timeRQ
            .TimeReportType.SetValue ENTimeReportType.trtTimeByJobSummary
            .SummarizeColumnsBy.SetValue ENSummarizeColumnsBy.scbTotalOnly
            .ORReportPeriod.ReportPeriod.FromReportDate.SetValue dateFrom
            .ORReportPeriod.ReportPeriod.ToReportDate.SetValue dateTo
        End With
        
        wksTJS.Range("ClearArea").ClearContents
        
        With wksTJS.Range("Company")
            .Cells(1, 1).Value = sCompany
            .Cells(2, 1).Value = "Time by Job Summary"
            .Cells(3, 1).Value = dateFrom & " through " & dateTo
            .Cells(1, 2).Value = CStr(timeNow)
            .Cells(2, 2).Value = CDate(Now)
        End With
 
    ElseIf lRunNo = 2 And bList Then
        
        Set timeRQ = requestSet.AppendTimeReportQueryRq
        
        With timeRQ
            .TimeReportType.SetValue ENTimeReportType.trtTimeByJobSummary
            .SummarizeColumnsBy.SetValue ENSummarizeColumnsBy.scbTotalOnly
            .ORReportPeriod.ReportDateMacro.SetValue rdmAll
 
            For i = LBound(sCustomers) To UBound(sCustomers) - 1
                If sCustomers(i) <> "" Then
                    .ReportEntityFilter.ORReportEntityFilter.FullNameList.Add CStr(sCustomers(i))
                End If
            Next i
            
            .DisplayReport.SetValue True
        End With

Result:

If I look at Customize Report > Filters I see this:

You'll notice that the right-hand Filters table shows Name || Multiple names..., which is the incorrect filter for this task. However, there does not seem to be any obvious way to set the filter to Customer:Job. I have tried adding in the following line of code:

ReportEntityFilter.ORReportEntityFilter.EntityTypeFilter.SetValue etfCustomer

This results in:

The simple reason I cannot use the Names filter is that it doesn't reflect the Customer:Job Names that I intend to use from the 1st TbJS report. If I use QB's UI to switch the filter to Customer:Job & manually select the multiple applicable entities, it comes out exactly as I want it. I just don't see the lever to switch these filters & the Intuit Dev forums are beyond useless.