I'm trying to build a pivot grid from your sample page http://demos.devexpress.com/ASPxPivotGridDemos/SampleReports/CustomerReports.aspx
I'm looking at the code page and I see this:
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/nwind.mdb"
DataSourceMode="DataReader" SelectCommand="SELECT * FROM [CustomerReports]" />
I'd like to know what is the [CustomerReports] object? Is this a custom table you have? Perhaps it is a view? To be able to work with these samples, I need to know what the definition of this object is. None of the northwind databases I've downloaded have it. Knowing what [CustomerReports] is, it will help me figure out how to use my own database.
Thank you for contacting us. Please review the CustomerReports view (query) definition below:
SELECT Products.ProductName, Customers.CompanyName, Orders.OrderDate, CCur([Order Details].[UnitPrice]*[Quantity]*(1-[Discount])/100)*100 AS ProductAmount
FROM Products INNER JOIN ((Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID) INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID;
I hope this will be of help.
Is your intention to post an answer to your own question?
- If so, then proceed.
- If you simply wanted to post additional information, ask for further clarification, or to just say "Thanks!", please click Leave a Comment.
- If you wish to edit your original question, please use the Edit button in the Toolbox at the top right corner of that entry.