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
|
|
P & L by Job Report |
Author |
Message |
mike |
|
Group | : Members |
Posts | : 1 |
Joined | : 2007-08-21 |
|
Profile |
|
Posted : 2007-08-21 06:33:30 |
I would to see if someone has done the profit and loss by job report. I cannot find this report in the report builder. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-08-21 09:03:13 |
Sorry, this is the support forum for QODBC, not QReportBuilder. The SQL statement for the Profit and Loss by Job report is:
sp_report ProfitAndLossByJob show Amount_Title, Text, Label, Amount parameters DateMacro = 'LastMonth', SummarizeColumnsBy = 'Customer'
For QReportBuilder support see: QReportBuilder Priority Phone Support - Click to get Help Now! |
|
|
|
|
Posted : 2008-04-01 10:31:21 |
Hello,
I'm running the following: sp_report ProfitAndLossByJob show Amount_Title, Text, Label, Amount parameters DateMacro = 'LastMonth', SummarizeColumnsBy = 'Customer', EntityFilterFullNameWithChildren = 'CustomerNameHere:JobNameHere'
In the resulting "Amount_N_Title" I get truncated text, i.e. there is a line break and the second line with the Job only some of the characters in it. Is there a way to display the entire Job text?
Thanks, Dave |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-04-01 15:56:55 |
QODBC can only really return single line values within reports. What you see is what is coming out of Intuit's qbXML SDK. Try using the:
sp_report ProfitAndLossByJob show Amount_Title, Text, Label, Amount parameters DateMacro = 'LastMonth', SummarizeColumnsBy = 'Customer', EntityFilterFullNameWithChildren = 'CustomerNameHere:JobNameHere', DisplayReport = 'Yes'
parameter to force the report to be displayed in the QuickBooks User Interface to see what's really going on here. |
|
|
|
|