You must Sign In to post a response.
Category: Visual Studio
#768543
Cross-tab reports provide the support to extract data for decision making. Cross-tab reports are based on cross-tab objects. Here is a query for Cross-tab reports
Reference: http://aspalliance.com/1041_Creating_a_Crosstab_Report_in_Visual_Studio_2005_Using_Crystal_Reports.3
Categories. CategoryName,
Pros.ProName, Sum (CCur ([Order
Details].UnitPrice*[Quantity]*(1-[Discount])/100)*100) AS ProSales,
"Qtr " & DatePart("q",[ShippedDate]) AS ShippedQuarter
FROM (Categories INNER JOIN Pros ON
Categories. CategoryID=Pros.CategoryID) INNER JOIN (Orders INNER JOIN
[Order Details] ON Orders.OrderID=[Order Details].OrderID) ON
Pros.ProID=[Order Details].ProID
WHERE (((Orders.ShippedDate) Between #1/1/2016# And #12/16/2016#))
GROUP BY Categories.CategoryName,
Pros.ProName, "Qtr " &
DatePart("q",[ShippedDate]);
Reference: http://aspalliance.com/1041_Creating_a_Crosstab_Report_in_Visual_Studio_2005_Using_Crystal_Reports.3
Return to Return to Discussion Forum