Reports

Labels
AJAX(112) App Studio(9) 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(178) 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(184) 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(3) 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
Reports
Thursday, January 14, 2010PrintSubscribe
Ad Hoc Reporting

Learn to create ad hoc reports in Web Site Factory projects.

We will show how to create an ad hoc report based on a business object layer class generated by Code OnTime Generator. Then we will replace the business object layer object with a ControllerDataSource component.

Watch this video on our YouTube channel at http://www.youtube.com/watch?v=wAeNRB-kdLY.

We will create a dataset with a table adapter based on a free-form SQL query or optional stored procedure. Then we will replace ControllerDataSource component in the AJAX web application created in the first part of the tutorial with an ObjectDataSource hooked to the data table adapter.

Watch this video on our YouTube channel at http://www.youtube.com/watch?v=T_FYskbhYCM.

Wednesday, December 9, 2009PrintSubscribe
Custom RDLC Reports for AJAX Web Apps

Data Aquarium Framework automatically creates RDLC reports in WYSIWYG style at runtime for any data grid views and replicates sort order and filters specified by the end users.

Try it live at http://dev.codeontime.com/demo/websitefactory1/pages/products.aspx.

You can quickly create custom reports that have the same behavioral properties.

Custom RDLC Reports for AJAX Web Apps (Data Aquarium Framework)

Watch this video on our YouTube channel at http://www.youtube.com/user/codeontime#p/u/5/Gli45vikyOU.

The Framework automatically creates in-memory report definitions by applying standard ~/Reports/Template.xslt stylesheet to XML data controllers of your application at runtime when a user requests a report.  Such reports are created in RDLC format. RDLC is the technology available in Microsoft Reporting Services, a component of Microsoft SQL Server.

Learn more about Microsoft Reporting Services:
http://www.amazon.com/gp/search?ie=UTF8&tag=ie8search-20&index=blended&linkCode=qs&camp=1789&creative=9325&keywords=reporting+services+2008.

First, the Framework creates a System.Data.DataTable class instance and populates it with the data displayed in the grid with filters and sort order applied. Next, the instance of Microsoft.Reporting.WebForms.LocalReport class is created and supplied with the report definition, data table, and output format. The instance of this object will render the actual report file.

The code of the report engine that performs these steps is in ~/Report.ashx file in the root of project created by Code OnTime Generator.

The custom report option in the video can be also defined without Code OnTime Designer as shown in the snippet of ~/Controllers/Products.xml data controller.

<actionGroup id="ag7" scope="ActionBar" headerText="Report">
  <action id="a1" commandName="ReportAsPdf" headerText="PDF Document" 
        description="View items as Adobe PDF document.&lt;br/&gt;Requires a compatible reader." />
  <action id="a2" commandName="ReportAsImage" headerText="Multipage Image" 
        description="View items as a multipage TIFF image." />
  <action id="a3" commandName="ReportAsExcel" headerText="Spreadsheet" 
        description="View items in a formatted&lt;br/&gt;Microsoft Excel spreadsheet." />
  <action id="a100" commandName="ReportAsPdf" commandArgument="Products.rdlc" headerText="Custom Products Report" causesValidation="true" 
        description="This is a custom report" />
</actionGroup>

If the command argument does not include path information then the framework makes an assumption that the report is in ~/Reports folder. You can store reports in any other location under the root of your website. Just make sure that the relative path of the report is included along with the report name (for example, ~/MyLocation/MyFolder/MyReport.rdlc).

You can also customize the standard ~/Reports/Template.xslt and create alternative automatic templates. If the XSLT stylesheet name is specified as a command argument of action then Data Aquarium Framework will attempt to create a report definition on the fly using your custom stylesheet and then proceed with rendering of report in the specified output format.

Thursday, November 27, 2008PrintSubscribe
RSS Your Data

It seems that RSS feeds are everywhere. You find them on your computer desktop, in your favorite web browser bookmarks, email readers. Links to RSS feeds are sprinkled all over the web. Your cell phone and TV are likely able to show RSS feeds as well.

RSS feed can free your inbox from being flooded by various email notifications about events of interest that you might have subscribed to. Email notifications are "pushed" to your inbox by servers that host the data. RSS feeds are "pulled" from the servers by RSS reader applications on-demand. You control your RSS subscriptions by configuring the frequency of delivery, the number of items in a feed, and the size of the archive.

Data Aquarium Framework now supports View RSS Feed command option in all data views that have an action bar. Here is how the action group must be defined in a data controller descriptor file.

<actionGroup scope="ActionBar" headerText="Actions">
  <action commandName="ExportCsv" headerText="Export to Spreadsheet" 
        description="Analyze items with spreadsheet&lt;br/&gt; application." />
  <action commandName="ExportRss" headerText="View RSS Feed" 
        description="Syndicate items with an RSS reader." />
  <action />
  <action commandName="Custom" commandArgument="MyCommand" 
        headerText="My Command" description="Execute my custom command" />
</actionGroup>

Navigate to http://dev.codeontime.com/demo/nwblob and select Orders in the drop down in the top left corner of the page. Sort orders in descending order of order date and limit orders to those shipped via Federal Shipping.

Your screen will like the one below.

image

Select Actions|View RSS Feed option on action bar above the grid view.

image

An RSS feed will be displayed. Here is how the RSS feed looks when displayed in Microsoft Internet Explorer 7.0.

image

You can see this feed live at http://dev.codeontime.com/demo/NWBlob/Export.ashx?q=PHEgYz0iT3JkZXJzIiB2PSJncmlkMSIgcz0iT3JkZXJEYXRlIGRlc2MiIGU9IkV4cG9ydFJzcyI%2bPGY%2bU2hpcFZpYUNvbXBhbnlOYW1lOj1GZWRlcmFsIFNoaXBwaW5nPC9mPjwvcT4%3d.

The link looks cryptic for a reason. Parameter q in the URL specifies unique encoded query to retrieve an RSS feed from our hosted demo application and instructs the server to sort orders in descending order by order date and filter ship via field by Federal Shipping.

Click on link Great Lakes Food Market to see the details of the order on a standard details page automatically generated as a part of your ASP.NET application by our code generator, Code OnTime Generator. You can edit order details and return back to the feed by clicking on Close button.

image

Feed viewer capabilities depend on your web browser. Here is how the feed of employees is presented in Apple Safari.

image

Typically you can search the feed content and sort data in various ways. If there is a least on date field in your data view then the item publication date is defaulted to this field.

The real value of RSS will reveal itself when you subscribe to a feed.

For example, subscribe to the orders feed referenced above in Internet Explorer. If you are using Vista as operating system then it is likely displaying a side bar with various gadgets. Add Feed Headlines gadget to the side bar if you don't already have one. Configure the gadget to read the orders feed.

image

A list of order customer names will be displayed in the gadget.

image

If you select a customer name then order details are immediately displayed next to the gadget. If you click on a customer name then details of order will be presented. If you click on Orders|Orders link then a complete live RSS feed is displayed. The gadget will automatically scroll the list.

Add a new order to the database. Next automatic "pull" of RSS feed will show you a new order right on your desktop without any need to sign into a web application or sending an e-mail notification from the server. 

This may work great in various scenarios. Your information workers can create an unlimited number of data feeds by filtering and ordering any application data to their liking and viewing and subscribing to RSS feeds created based on the current data view that they see. New data that falls under the same filtering and sorting conditions will show up when the feeds are updated.

There are numerous RSS feed readers out there. Popular Email applications will also display RSS feeds and tell users when new feed items are available, which can make your business data more tightly integrated in everyday business processes.

Our powerful ASP.NET code generator, Code OnTime Generator, will instantly create robust AJAX applications based on Data Aquarium Framework. See a complete list of features of the framework at http://codeontime.com/productsae.aspx.

Continue to Export to Spreadsheet