Column not found: Blank |
Author |
Message |
Kyle |
|
Group | : Members |
Posts | : 10 |
Joined | : 2006-09-22 |
|
Profile |
|
Posted : 2006-09-26 07:52:13 |
When I execute this query against QuickBooks Online Edition:
I get this error:
What am I doing wrong?
- Kyle - |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-26 10:07:10 |
Try running:
sp_report TimeByJobDetail parameters datefrom={d'2006-01-01'}, dateto={d'2006-12-31'}
instead to see all the columns that are available via the QuickBooks Online Edition. |
|
|
|
Kyle |
|
Group | : Members |
Posts | : 10 |
Joined | : 2006-09-22 |
|
Profile |
|
Posted : 2006-09-26 23:33:33 |
I ran the query and got this error:
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-27 11:17:56 |
Please run:
sp_reports
to see what reports are available in the QuickBooks Online Edition. |
|
|
|
Kyle |
|
Group | : Members |
Posts | : 10 |
Joined | : 2006-09-22 |
|
Profile |
|
Posted : 2006-09-28 02:38:32 |
Here is the result:
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-28 08:15:03 |
|
|
|
Kyle |
|
Group | : Members |
Posts | : 10 |
Joined | : 2006-09-22 |
|
Profile |
|
Posted : 2006-09-28 08:17:14 |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-28 08:33:53 |
|
|
|