← Back to all blogs

Recent Posts

Introduction to Fixed Page Layout–Part 2

Welcome to the next post in the "What's New in ActiveReports Developer 7?" series!  This time we'll go from taking a 50,000 foot view of Fixed Page Layout (FPL) reports and get into the nitty gritty and create a couple of reports. We'll start off by creating a simple report. We have the items that a customer has purchased and want to print an invoice for it.  We'll be concerned with printing just a single invoice to start with, and later we'll modify this report to be able to work with multiple invoices at once. I'm using the standalone designer that is installed alongside ActiveReports 7, however you can also use Visual Studio to create the reports. To create a new Page report, from the File menu, select New and choose Page Report (in Visual Studio this is called ActiveReports 7 Page Report).  In the Report Explorer, right-click on the Data Sources node and choose Add Data Source.  In the dialog that comes up select Shared Reference and browse to the samples directory included with ActiveReports.  Inside of the samples directory, select the Data\ReelsDataSource.rdsx file.  This file contains all of the connection information to use the Reels sample database.  Click OK to accept our changes and close the dialog. Now in the Report Explorer, right-click on our newly added DataSource1 and choose Add Data Set.  On the left navigate to the Query page, and use the following SQL query. SELECT * FROM CustomerOrders WHERE CustomerID = 1000