I am having trouble running crystal reports off of the Laserfiche SQL Database.  The results will not load when I try to refresh to get new data.  I have waited several hours for the report to populate but it never does.  I am using the following inner join queries to get the data together to run the report.  Can anyone recommend how I can run the report more efficiently?

select  PONumber.str_val as PONumber, InvNumber.str_val as InvoiceNumber, dates.date_val as Date, NumReceivers.num_val as NumReceivers


from toc inner join propval as PONumber on toc.tocid = PONumber.tocid and PONumber.prop_id = 87
inner join propval as InvNumber on toc.tocid = InvNumber.tocid and InvNumber.prop_id = 35
inner join propval as dates on toc.tocid = dates.tocid and dates.prop_id = 41
inner join propval as NumReceivers on toc.tocid = NumReceivers.tocid and NumReceivers.prop_id = 188

select
vendor.str_val as VendorName, dates.date_val as Date, ReceiverNumber.num_val as ReceiverNumber, PONumber.str_val as PONumber, rcvrMatched.str_val as Match

from toc inner join propval as vendor on toc.tocid = vendor.tocid and vendor.prop_id = 13
inner join propval as ReceiverNumber on toc.tocid = ReceiverNumber.tocid and ReceiverNumber.prop_id = 158
inner join propval as dates on toc.tocid = dates.tocid and dates.prop_id = 236 
inner join propval as PONumber on toc.tocid = PONumber.tocid and PONumber.prop_id = 87
inner join propval as rcvrMatched on toc.tocid = rcvrMatched.tocid and rcvrMatched.prop_id = 461