No Feed URL specified.
Pivot Reporting | Building Custom Reports
Pivot Reporting | Building Custom Reports
This video covers how to build a custom pivot report. The video includes a sql statement which is provided below the video on this page.Dim lights Embed Embed this video on your site
SELECT ProductName,SUM(Quantity),Left(CompletionDate,11)
FROM tblProductOrderDetails
WHERE (ServiceType='Prescription' OR ServiceType='Prescription Tax Exempt' )
AND OrderDate BETWEEN '11/01/2011' and '11/29/2011'
GROUP BY Productname,LEFT(CompletionDate,11)
FROM tblProductOrderDetails
WHERE (ServiceType='Prescription' OR ServiceType='Prescription Tax Exempt' )
AND OrderDate BETWEEN '11/01/2011' and '11/29/2011'
GROUP BY Productname,LEFT(CompletionDate,11)
Live Answers!
Click in the lower window to chat. Available 9-5:30 P.S.T. Weekdays. You can also leave your email with your question and we'll provide a response.
If someone doesn't answer promptly, please be patient or give us a call.
Get your POS Quote
| We beat competitor's quotes with pricing and service. |
Download POS: | |
| Software Download . We will help you install and setup your system before you buy. |
