Code On Time: Tutorials

Blog

Tutorials

Saturday, December 15, 2012Print Subscribe

Let’s add a tablix that will display a list of order details.

Activate the Toolbox window by pressing Ctrl+Alt+X keyboard shortcut. Click on the Pin icon in the top right corner of the window to keep it open.

Drag Table item into the center section of the report to add a tablix element.

Mouse over the cell in the first column, second row, and click on the icon that appears in the top right corner.

Click on ProductProductName data item from the list to add it to the cell.

The data item will be added to the cell, and the header will be automatically labeled. Double-click on the label text and change to “Product Name”.

Add six more fields with the following labels. To add more columns, right-click on a column and press Insert Column | Right.

Field	Label
UnitPrice	Unit Price
Quantity	Quantity
Discount	Discount
ProductCategoryCategoryName	Category
ProductSupplierCompanyName	Company
ExtendedPrice	Extended Price

The tablix must look as shown in this picture:

Click and drag on the dividers in the grey area above the columns to expand the columns. Expand the columns to take up all the space on the page. Make sure to allocate the most horizontal space to ProductProductName, ProductCategoryCategoryName, and ProductSupplierCompanyName.

Note that the report page should not exceed a width of 10”. You can display a ruler by clicking on Report | View | Ruler in the Visual Studio menu.

Click on the first header cell. Hold Shift, and click on the last cell. On the toolbar, click on the Bold icon to make all text bold. Then click on the Foreground Color icon.

Select the color “Midnight Blue”.

Press OK to change the color of the text.

Highlight all cells in both rows. On the toolbar, activate the Border dropdown, and select No Border to turn off the default grey borders.

Then, activate the Border Color immediately to the left and select “Gray”. Press Bottom Border to turn on a single black border on the bottom.

Labels: Reports, Tutorials, Web Application Generator

Saturday, December 15, 2012Print Subscribe

Order Form Sample–Part 32

Let’s create a data controller view that will serve as a foundation for the report.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab. Right-click on OrderDetails / Views node, and press New View.

Assign the following values:

Property	Value
Id	report1
Label	Order Report
Show in View Selector	false
Create custom report template	true

Press OK to create the view.

Expand OrderDetails / Fields node. Click on OrderID field node. Hold Shift,and select the last field, ExtendedPrice. Drop the fields onto OrderDetails / Views / report1 node.

On the toolbar, press Browse to generate the custom report template (.RDLC) file.

Labels: Application Builder, Reports, Tutorials, Web Application Generator

Saturday, December 15, 2012Print Subscribe

Order Form Sample–Part 31

An alternative method for creating the denormalized data set is to create a database view.

Start SQL Server Management Studio. Connect to the database server. Right-click on Databases / Northwind node, and press New Query.

Paste in the following script:

CREATE VIEW [dbo].[OrderFormReport]
AS
SELECT dbo.[Order Details].UnitPrice, dbo.[Order Details].Quantity, 
        dbo.[Order Details].Discount, dbo.Orders.OrderDate, dbo.Orders.RequiredDate, 
        dbo.Orders.ShippedDate, dbo.Orders.Freight, dbo.Orders.ShipName, 
        dbo.Orders.ShipAddress, dbo.Orders.ShipCity, dbo.Orders.ShipRegion, 
        dbo.Orders.ShipPostalCode, dbo.Orders.ShipCountry, 
        dbo.Employees.LastName AS EmployeeLastName, 
        dbo.Employees.FirstName AS EmployeeFirstName, 
        dbo.Shippers.CompanyName AS ShipperCompanyName, 
        dbo.Customers.CompanyName AS CustomerCompanyName
FROM   dbo.[Order Details] INNER JOIN
        dbo.Orders ON dbo.[Order Details].OrderID = dbo.Orders.OrderID INNER JOIN
        dbo.Employees ON dbo.Orders.EmployeeID = dbo.Employees.EmployeeID INNER JOIN
        dbo.Customers ON dbo.Orders.CustomerID = dbo.Customers.CustomerID INNER JOIN
        dbo.Shippers ON dbo.Orders.ShipVia = dbo.Shippers.ShipperID

GO

Execute the script to create the database view.

Switch back to the web application generator. Refresh the project, and include the new view in the configuration.

Click Design and explore the new data controller.

Labels: Application Builder, Tutorials, Web Application Generator