Creating a Custom Report Template

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
Friday, December 7, 2012PrintSubscribe
Creating a Custom Report Template

When it becomes necessary to customize your reports beyond the scope of the settings available in the Project Designer, you will need to create a custom report template.

The default report for Customers view of “grid1” is displayed below.

Default report for Customers view of 'grid1'.

Let’s change make the following changes to the report:

  1. Highlight the Contact Name column in yellow.
  2. Change the color of Address header to red.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab and double-click on Customers / Views / grid1 node.

View 'grid1' of Customers controller in the Project Explorer.

Change the following:

Property New Value
Create custom report template true

Press OK to save your changes. On the toolbar, press Browse to generate the template. When complete, select Develop option to open the project in Visual Studio.

In the Solution Explorer, double-click on ~\Reports\Customers_grid1.rdlc file.

Custom report template file selected in Visual Studio's Solution Explorer.

In the Design window that was opened, highlight the cell containing the text “[ContactName]”. On the toolbar, press the Background Color icon.

Changing the background color of the 'Contact Name' column.

Change the background color to yellow and press OK to apply.

Next, highlight the cell containing the “Address” header. On the toolbar, select the Foreground Color icon.

Changing the foreground color of 'Address' column header.

Select the color red and press OK. Save the file.

Switch back to the web application open in your browser and refresh the web page. If you closed it, press Browse in the Project Designer window.

Navigate to the Customers page, and activate the Report | PDF Document option on the action bar.

Creating a report from the list of customers.

Open the file that was saved to your hard drive. The report will be created from the template and will display the customizations.

Customers report with yellow highlight on 'Contact Name' column and red text in 'Address' header.