Some times there could be spaces in between and the name for the driver_Name in your source may not be matching. To avoid you can use Ltrim and Rtrim functions...

--Corrections

SELECT h.iKey

,h.iInvoice_Number

,h.iTicket_Date

,h.iDestination_1

,h.iRate

,d.tDriver_FullName

,SUM(d.tBill_QTY) AS TotalUnits

,SUM(d.tBill_Total_Charge) AS Total

FROM tblTicketHeader h

LEFT JOIN tblTicketDetail d

...

--between is a little tricky and you need to know are you including the dates

--Test it with the driver_Name you want by replacing the parameter

--Simplfy your queries for clarity as...

I had similar problem and when I tried it in different machine it worked fine. The size of your database and the memory you have are also factors.

Try in other...

I have exactly the same issue too, let me know if you get the solution for this.

What is the size of the Analysis Services Database? try to query using MDX by limiting the no. of records you want to see