I am using the following sql statement:

sp_report JobProfitabilityDetail show AmountActualCost_Title, AmountActualRevenue_Title, AmountDifferenceActual_Title, Text, Label, AmountActualCost, AmountActualRevenue, AmountDifferenceActual parameters DateMacro = 'All', SummarizeColumnsBy = 'TotalOnly' , EntityFilterFullNameWithChildren = '{?customer}'

I then create a customer parameter in the parameter list. The customer name is pretty long so is there a way to search by using wildcard i.e. - *50-126* rather than have to enter:

customer name. location.50-126.projectdescription??

Sorry, you can't use wildcards and you need to use the full name path for a specific job:

sp_report JobProfitabilityDetail parameters DateMacro = 'All', EntityFilterFullNameWithChildren = 'Abercrombie, Kristy:Remodel Bathroom', SummarizeColumnsBy = 'TotalOnly'

If you wanted, for example, to compare all Remodel Bathroom (or 50-126) jobs for all customers you would need to run the Job Profitability detail report off for each customer to a datafile (like a append query in MS Access) and report from the datafile instead.

That is what I figured but thought that I would ask in case I was missing something.

Is there a link on QODBC website that would show me what tables were used to create the sp_reports. I.E. - Job Profitability Details ?

I looked in the forums but could not find anything. This would allow me to link the tables and use wildcards - right ????

In VB Demo, if you hit the tables button you will get a list of tables and what each table contains.

When it comes to Job Profitability there are lots of factors you need to pull together. For example: How can I see the cost of a stock item and compare it to what I invoiced it for? only covers cost.