How do I add parameters to my reports
How do I prevent users from editing & deleting my reports
How do I hide my reports.xml file
How do I my report fonts and color settings
How do I take of the ASP Web Solution Ad from showing up on my reports
How can I handle multiple databases/connection strings
How do I create a hyperlink column with data from another column
How do I set an OLE field as a downloadable link (document)
How do I hide fields that I only want to use in hyperlink columns
How do I add page headers & footers to my reports before I print them

Q. How do I take of the ASP Web Solution Ad?

A. You purchase a license key. This key will turn off the the ads, it will take off all links to AspWebSolution.com and turn off all the time checks. Thus your report wizard will run a lot faster if you have a key. For more information on obtaining a license key, go to then licensing page and select the license that best meets your needs.

When you have obtained your license, you reference it before you initialize the report wizard as shown below :

Q. How can I handle multiple databases/connection strings?

A. The current version of the report wizard supports only 1 database connection string. A future version might support multiple but this greatly depends on if more users require this functionality.
You can however handle programatically handle multiple connection string instances. For more information check our tutorial on Handling Multiple Databases.

Q. How do I create a hyperlink column with data from another column?

A. You can reference another field/column when vreating a hyperlink by use of the field name within double-curly braces. For example, If you wanted to create a hyperlink on the ProductName column of the Products table with the value of the ProductID, simply enter a URL similar to the one below when prompted for the URL.

How do I hide fields that I only want to use in hyperlink columns

A. If you don't want any field to show up in the report but you need the column's data such as for hyperlink parameters, you can hide this field by setting the Text Format to Hidden

How do I set an OLE field as a downloadable link (document)

A. If you want to set a field as a downloadable link, you need to set the Text Format to Document. You will be prompted to enter your file extension. Enter PDF for PDF documents, DOC for word documents and so on. This will then be formatted as a link which a user can click on to download the document.

How do I add page headers & footers to my reports before I print them

A. You can add headers & footers to your reports before printing by use of the PrintHeader & PrintFooter properties of the report wizard.

objWiz.PrintHeader = "<div align='right'><img src='images/logo.gif' vspace='10'></div>"

objWiz.PrintFooter ="<p align='center'>&copy AspWebSolution.com. All rights reserved</p>"