Blog: Posts from December, 2012

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Posts from December, 2012
Sunday, December 23, 2012PrintSubscribe
“Report (Excel)” Action

The Report (Excel) action will output a report in Microsoft Excel format. The standard Report (Excel) action is presented to the users as an option labeled “Spreadsheet” under Reports action group. The action is highlighted in the picture below.

Report (Excel) action on the action bar is highlighted.

Activating the action will produce a spreadsheet in Microsoft Excel format. The file will open in the default spreadsheet viewer associated with .xls extension.

Default Products report in Excel.

Note that Microsoft Excel is not a typographically precise format – PDF or TIFF formats provide the highest quality and precision of output.

Sunday, December 23, 2012PrintSubscribe
“Report (PDF)” Action

The Report (PDF) action functions exactly like the Report action. It produces a report using Microsoft Report Viewer in PDF format.

This is the standard Report (PDF) action available by default in all data controllers.

Default Report PDF action on the action bar.

The picture below shows a default PDF report created from Products data controller.

Default PDF report using the standard report template.

Sunday, December 23, 2012PrintSubscribe
Multi-Purpose Reports

The Order Report with multi-level grouping no longer requires filtering by OrderID. It will correctly render order details if multiple orders are included in the data set. Let’s add an action to Customers data controller that will print all orders of a specific customer.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab. Right-click on Customers / Actions / ag2 (Form) node, and select New Action.

Creating a new action for Customers controller.

Assign the following values:

Property Value
Command Name Report
Header Text Print All Customer Orders
Data

_controller=OrderDetails
_view=editForm1
_template=OrderDetails_report1.rdlc
_sortExpression=OrderID,ProductProductName
OrderCustomerID=CustomerID

When Key Selected Yes

Press OK to save the action. On the toolbar, press Browse.

Navigate to the Customers page, and select a record. Click on Print All Customer Orders to download the report.

Printing a report of orders filtered by the current customer.

The report will include orders of the selected customer.

PDF report displaying orders of the specific customer.