3.0: Creating a Web Site using VS.NET 2013
Step 3.1: Start VS.NET2013. Create a new ASP.NET Web Application Project named
Select Web Forms and be sure to set the Authentication to No Authentication.
Step 3.2: In this exercise we will develop some
1.0: Developing Reports Using VS.NET 2013
VS.NET Web Site development environment provides two reporting tools: Crystal Reports and
MS Reports. In our examples, we will use the MS Reports. The MS Reports is also available in
MS SQL Server Business Intelli
7.0: Developing Charts
In this example, we will create develop a graph for annual sales in various countries for selected category of products.
Simply to introduce certain variations, we will use the SQL Server Northwind database for our graph. You may ea
6.0: The Matrix Report Item
The Matrix Report Item can be employed to display aggregate data. In this demonstration we will
develop a report to display the annual sales in various countries. The completed Web Page will
be displayed as shown below.
5.0: Improving the Layout:
If you need to improve the layout, you may need to work on a number of different places
(depending on your objectives and skills). Two such major areas are:
o Manipulate HTML for the Web Page itself: In this case we can apply XH
4.2: Report Layout Design
Highlight the Project node in the Solution Explorer. Right click it to display its context
menu and select Add > New Item.
The system will display the Add New Item screen, select Report in the middle pane.
4.4: Testing the Web Page with the Report
Right-click the web forms name in the solution explorer. You may select View in IE, or
Select Browse With
Select your favorite browser.
After you wait a while, the system will hopefully display the
5.2.4: Grouping Records and Displaying Aggregated Values
A. On the design layout of your rdlc object, highlight the 2 nd row of the table and right click.
Select Add Group > Parent Group.
B. The system will display the Tablix group screen. Select Country
5.2: Polishing the Report Layout:
In this section, we will illustrate the
Working with the Report Header and Footer.
Working with Page Number and Current date fields.
Hiding repetitive duplicate entries
Grouping records and reporting summar
How about a Grand Total?
Highlight the last row, right-click it and select Insert row > Outside Group below.
The system will add a new column and a new row at the bottom. If the system has added
a new column at left, delete it. At this stage, it will appe
2.1: Handling 1:M and M:M Relationships
In this handout, I would try to outline two very simple rules that will be handy when we
develop ER Model and/or map an unpolished ER model to tables in a relational DBMS. I
call these rules Golden Rules (simply to
2.0: The Output of the Work done in
Section 1.0 to 4.0:
In the first part of this handout, we will develop a report and embed it in a Web page.
completed Web page will be displayed in Internet Explorer as shown below:
Notes on Web sites structure:
Lock modes and lock promotion (cont.)
Example: An Intent Shared (IS) lock acquired at the table level
means that the transaction intends to acquire shared locks on
pages or rows within that table. This prevents another transaction
from acquiring an exclu
Mesbah U. Ahmed, IOTM Department
College of Business Administration
In this handout (DrilldownMatrixReportUsingRptWizard.doc), we will develop a drilldown report using the
Report Wizard. We will generate the report using the OurNorthwindV3.accdb.
Introduction to TSQL: Version 2
Table of Contents
1. Introduction to TSQL
Introduction to TSQL
1.0: Transact SQL Local Variables
We may define our own variables with appropriate data types. The variable must have a @ prefix. Once the
4.0: Basic Concepts in Report Development
All report generators follow certain generic principles. Some of the major principles are:
1. We need to specify a data source that will be used to generate the report.
2. We usually provide various the format of
How to handle concurrency problems
In a large system with many users, you should expect
concurrency problems to occur.
In general, you dont need to take any action except to
anticipate the problem. In many cases, if the query is
resubmitted, the problem
How to manage Transactions and Locking
These issues are also available in Chapter 10 of our hardcover textbook
by Coronel, et. al. and in our 2nd textbook by Murach (paperback) in
A Database Transaction is a set of database actions that are
A Rollback Example:
Consider the existing records from the Invoices table for Vendor 34
SELECT * FROM Invoices
A script that performs a test before committing
5.2.5: Exporting the Report to Excel
When we are browsing the page, we can use the Export control to export the report to Excel or
Here is a screen shot of Excel spread sheet we received when we exported our reports data:
Step 8.0: Formatting the Sale Values:
In the design view of the rdlc file, highlight the Sum(Sale) cell and right-click. Select
In the Textbox Properties screen, select Number in the left panel and Currency in the
Step 7.0: Adding Drill-down feature:
Open the NWindSalesReport1.rdlc file in design view. Right-click the City group at the
bottom. Select Group Properties.
In the Group Properties screen, select Visibility in the left panel, and the select Hide radio
A view is a database object that can be considered to be a
A view is usually created by a SELECT statement on base
tables or on other views.
A view has a source SELECT statement.
When we create a view, the source SELECT statement