Make the currency and quantity cells span across two table rows. Right-click the table and select Insert / Row Below from the context menu.Ĭlick the xrTableCell6 cell’s smart tag and select the Supplier field in the Expression property. This creates an XRTable with each cell bound to a data field. Hold CTRL or SHIFT and click on the fields to select multiple fields and drop them onto the Detail band. Click Finish.Ĭreate the Report Layout Create the Products ListĮxpand the OrderDetailsExtended query in the Field List (Visual Studio Report Designer) and select the ProductName, UnitPrice, Quantity, Discount, and ExtendedPrice fields. Select the OrderID, ProductName, UnitPrice, Quantity, Discount, ExtendedPrice, and Supplier fields. Save the connection string and click Next.Įxpand the Views group and expand the OrderDetailsExtended view. Select SQLite as the Provider and specify the path to the sample Northwind database in the Database field. Select the No, I’d like to specify the connection parameters myself option and click Next. Select Database in the invoked Data Source Wizard and click Next. Expand the DataSource drop-down list and click Add Report Data Source. Bind to Dataīind the report to the sample Northwind database:Ĭlick the report’s smart tag. As an alternative, you can use the Report Wizard to create basic template-based reports.Īdd a new blank report to your application. This approach allows you to construct complex layouts and provides access to advanced table settings. This tutorial describes how to create a table report on the Design Surface.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |