Knowledgebase: Sp_commands & Reports
[QODBC-Desktop] Troubleshooting - How can I use wildcard (*) with Crystal Report and sp_report
Posted by Jack - QODBC Support on 30 March 2016 10:30 AM

Troubleshooting - How can I use wildcard (*) with Crystal Report and sp_report

Problem Description:

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??

Solution:

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 data file (like an append query in MS Access) and report from the data file instead.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).