Knowledge Base

Please check first our knowledge base for solutions to your problem. If you can't find the right answer to your question select another support option on the right side.

February 15th, 2012 12:06 am
Reports, Tips - Sample Reports
0 Comment

Calculate with Scripts

Let’s suppose you have a Report where you have a Gran Total and need a summary percentage by year. 1.We have the following data sources. The first data-source – CUSTOMER PURCHASES TOTAL BY YEAR. Select DatePart(Year, Orders.OrderDate) As Year, Orders.CustomerID, Sum(([Order Details].UnitPrice – [Order Details].Discount) * [Order Details].Quantity) As Total From [Order Details] Inner Join [...]