ASP.NET—An intranet example II

ASP.NET 2.0 Query Reports + MS SQL

Case Scenario: Purchase Dept. asked if we can generate reports from the database MS-SQL server, based on Vendors' PO items, PO status (sorted by date) and list the PO status based on item category.

The answer is YES! All the data are stored in Microsoft's SQL server 2000 through Microsoft Great Plains software.

These reports are simple, use various query functions, no input necessary.

Result - Real Time Report :
Generate dynamic report linked with inventory database.

Coding Tips:

Set Item Category and use the value as variables in SQL select command: