Current filter:
                                You should refresh the page.
                                0
                                David Porter 4 07.04.2012

                                  • 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.

                                Leave a Comment
                                You must  log in  or  register  to leave comments

                                1 Solution

                                0
                                Alex (DevExpress Support) 07.04.2012

                                Hi David,

                                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.

                                Leave a Comment
                                You must  log in  or  register  to leave comments
                                You must  log in  or  register  to leave an answer

                                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.