Conversion of Reporting Starter Kit to use Mono/MySQL

StylezHouse

Rate me:

3.69/5 (9 votes)

1 Oct 20053 min read

28.3K

411

A porting of the ASP.NET reporting starter kit to use Mono, MySQL and Apache on a Linux system.

reporting_kit_conversion_demo.zip
- reports
  - bin
    - ASPNETReports.dll
    - ASPNETReports.dll.bak
    - MySql.Data.dll
    - MySql.Data.Tests.dll
    - MySql.Data.xml
  - ChartGenerator.aspx
  - components
    - ASPNETReports.csproj
    - bin
      - Release
        
        ASPNETReports.dll
    - BLL
    - DAL
      - SQLHelper.cs
  - crosstab.aspx
  - default.aspx
  - docs
    - bargraph_cs.htm
    - chart_cs.htm
    - chartdrawing_cs.htm
    - chartgenerator_aspx.htm
    - chartitem_cs.htm
    - charttabreportcollection_cs.htm
    - crosstab.htm
    - crosstab_aspx.htm
    - crosstabreport_cs.htm
    - crosstabreportcollection_cs.htm
    - crosstabspgetsalesbyregion.htm
    - default_aspx.htm
    - drilldown.htm
    - drilldown_aspx.htm
    - drilldownreport_cs.htm
    - drilldownreportcollection_cs.htm
    - drilldownspgetallcustomers.htm
    - drilldownspgetorderdetails.htm
    - drilldownspgetorders.htm
    - global_asax.htm
    - global_cs.htm
    - hierarchical.htm
    - hierarchical_aspx.htm
    - hierarchicalreport_cs.htm
    - hierarchicalreportcollection_cs.htm
    - hierarchicalspgetemployeebyid.htm
    - hierarchicalspgetemployeesalesbyterritory.htm
    - hierarchicalspgetsalesbyterritory.htm
    - images
      - 1x1.gif
      - crosstabnestedcontrols.png
      - crosstabtotals.png
      - customers.gif
      - drilldownnestedcontrols.png
      - employees.gif
      - getorderdetails.gif
      - GetOrders.gif
      - hierarchicalpaging.gif
      - hierarchicalreport.gif
      - hierarchicalschema.gif
      - hierarchicalsorting.gif
      - masterdetaildetails.png
      - masterdetailsummary.png
      - masterdetailtables.png
      - querysample.gif
      - querysample2.gif
      - simpleoverview.png
      - simplesp.png
      - tabcolorcode.png
      - tabdetail.png
      - tabheader.gif
      - tabheader.png
      - tabnestedcontrols.png
      - tabsortshot.png
      - tabularextendedprice.png
      - textshot.gif
      - viscategorysales.gif
      - viscategorysales.png
      - vischartstructure.png
      - xtabsql.png
    - masterdetail.htm
    - masterdetail_aspx.htm
    - masterdetailreport_cs.htm
    - masterdetailreportcollection_cs.htm
    - masterdetailspgetordersanddetails.htm
    - masterdetailspgetordersummary.htm
    - piechart_cs.htm
    - simple.htm
    - simplereport_aspx.htm
    - simplereport_cs.htm
    - simplereportcollection_cs.htm
    - simplespgetcustomercontacts.htm
    - style.css
    - tabular.htm
    - tabular_aspx.htm
    - tabularreport_cs.htm
    - tabularreportcollection_cs.htm
    - tabularspgetcategories.htm
    - tabularspgetproductsbycategory.htm
    - textreport.htm
    - textreport_aspx.htm
    - textreport_cs.htm
    - textreportcollection_cs.htm
    - textspgetemployees.htm
    - visual.htm
    - visual_aspx.htm
    - visualreport_cs.htm
    - visualreportcollection_cs.htm
    - visualspgetcategorysales.htm
  - drilldown.aspx
  - Global.asax
  - hierarchical.aspx
  - images
    - 1x1.gif
    - asp.net-reports.gif
    - background.gif
    - crosstab.gif
    - crosstabnestedcontrols.png
    - crosstabtotals.png
    - customers.gif
    - drilldown.gif
    - drilldownnestedcontrols.png
    - employees.gif
    - getorderdetails.gif
    - GetOrders.gif
    - grid_background.gif
    - hierarchal.gif
    - hierarchical.gif
    - hierarchicalpaging.gif
    - hierarchicalreport.gif
    - hierarchicalschema.gif
    - hierarchicalsorting.gif
    - logo.gif
    - logo-neg.gif
    - masterdetail.gif
    - masterdetaildetails.png
    - masterdetails.gif
    - masterdetailsummary.png
    - masterdetailtables.png
    - matrix.gif
    - querysample.gif
    - querysample2.gif
    - reporting.gif
    - report-table-bg.gif
    - simple.gif
    - simpleoverview.png
    - simplesp.png
    - spacer.gif
    - tabcolorcode.png
    - tabdetail.png
    - tabheader.gif
    - tabheader.png
    - tabnestedcontrols.png
    - tabsortshot.png
    - tabular.gif
    - tabularcolorcode.png
    - tabularextendedprice.png
    - tabularsorting.png
    - text.gif
    - textalternate.gif
    - textreport.gif
    - textshot.gif
    - viscategorysales.gif
    - viscategorysales.png
    - vischartstructure.png
    - visual.gif
    - xtabsql.png
  - masterdetail.aspx
  - scripts.js
  - simplereport.aspx
  - sourceviewer
    - 1x1.gif
    - crosstab.src
    - drilldown.src
    - grid_background.gif
    - hierarchical.src
    - masterdetail.src
    - simple.src
    - srcview.aspx
    - style.css
    - tabular.src
    - tabview.aspx
    - textreport.src
    - visual.src
  - sql
    - SqlSetup.sql
  - styles.css
  - stylesPrint.css
  - tabular.aspx
  - textreport.aspx
  - visual.aspx
  - web.config

<html>
	<head>
		<title>ASP.NET Reporting Documentation</title>
		<link rel="stylesheet" href="style.css">
	</head>
	<body class="NormalIndent">
		<h1>"GetOrderSummary" Stored Procedure</h1>
		<b>Description:</b>
		<P>
			This stored procedure creates a quarterly summary of the orders and sales 
			amount, which is calculated from the unit price, quantity, and discount. It 
			calculates the results for a given year, which it takes in as an input 
			parameter.</P>
		<b>Definition:</b>
		<pre>    
	CREATE PROCEDURE Reports_GetOrderSummary
	(
		@Year int
	)
	AS

	SELECT 
		DATEPART(q, OrderDate) Quarter, 
		COUNT(DISTINCT Reports_Orders.OrderID) OrdersShipped, 
		SUM(UnitPrice * Quantity * (1-Discount)) Sales 
	FROM Reports_Orders 
		INNER JOIN [Reports_Order Details] Details 
			ON Reports_Orders.OrderID = Details.OrderID 
	WHERE YEAR(OrderDate) =  @Year 
	GROUP BY DATEPART(q, OrderDate)		
        </pre>
		<b>SQL Schema: </b>
		<p>
			<img src="./images/1x1.gif" width="25"> <IMG src="./images/MasterDetailTables.png"></p>
		<br>
		<br>
	</body>
</html>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Written By

StylezHouse

Web Developer

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Conversion of Reporting Starter Kit to use Mono/MySQL

License

Comments and Discussions