Dynamically Generate Data Reports Based on User-Selected Conditions

Category:

Database

Type:

Modules

Difficulty:

Intermediate

Author:

Mrugendra Bhure

Version Compatibility: Visual Basic 6

More information:

The attached sample demonstrates how to create conditional SQL queries and assign them to the Report at runtime to display conditional reports. This program also demonstrates the use of SHAPE sql command for creation of Hierarchical Recordsets using the MSDataShape Provider. Also demonstrated: Multilevel Reports and a demo of Microsoft Hierarchical Flex Grid Control.

An Informative readme File is included.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download condreport.zip