Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
using wildcard (*) with Crystal Report and sp_report |
Author |
Message |
rick |
|
Group | : Members |
Posts | : 16 |
Joined | : 2006-04-20 |
|
Profile |
|
Posted : 2006-09-26 13:23:38 |
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??
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-26 14:37:54 |
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. |
|
|
|
rick |
|
Group | : Members |
Posts | : 16 |
Joined | : 2006-04-20 |
|
Profile |
|
Posted : 2006-09-27 03:45:47 |
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 ???? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-27 11:13:03 |
|
|
|
|