FAQs - ApexSQL Report

In this case you will get a server error. Please refer to our Troubleshooting guide for more information.

You can search for the existence of such problem reports by running the Report Diagnostics tool included in the "Report Maintenance" tab.

Drop-down source procedures don't require parameters. ApexSQL Report only supports procedures without parameters as picklist sources.

You can customize the appearance of ApexSQL Report by creating a custom style sheet. Once created the style sheet should be added to the "\UI\Includes" directory under your install directory. When the style sheet is placed there it can be applied to reports on a per user basis. If you need an example to refer to while creating your custom style sheet you can use the "apexsql.css" file located in the "UI\Includes" directory under the ApexSQL Report install directory.

Yes, anytime you see "View Procedure Text" icon it can be clicked to view procedure text.

No but ApexSQL Report needs to be configured with ASP.Net 1.1.4322. This can be done by updating ASP.Net version property of virtual directory in IIS.

ApexSQL Installer doesn't automatically upgrade any previous version database. Upgrade SQL script must be run manually to perform this action.

Note: "ApexSQLReportUpgrade6.sql" script file can be found in install location for upgrading 6.x version database to ApexSQL Report 2005.01 database.

There has been a change in the licensing scheme. Please send your original order details and old Activation key / License code to us at service@apexsql.com and we will send you your new Activation key.

To upgrade from 6.0 and 6.1 to 2005.02, please execute the script "ApexSQLReportUpgrade6.sql", delivered under the install directory of ApexSQLReport. To upgrade to 2005.01, no database upgrade script is required.

The default file is login.aspx, so if your version of ApexSQL Report is installed to http://xyz.com/ApexSQLReport/ then default page for the website directory should be set to http://xyz.com/ApexSQLReport/login.aspx. The ApexSQL Report installer will automatically configure IIS to use this file as the default when first so navigating to http://xyz.com/ApexSQLReport/ will yield the same results.

The default admin account information is:
User: Admin
Password: 123

Later, you can change the Admin account settings using Admin Console. After you log in as the administrator you can use the Users section in the Admin Console in order to add new users.

Click the "Activate this copy of ApexSQL Report" link in the home page of ApexSQL Report. Your Hardware ID key is shown in the next page.

You can activate the software by clicking the "Activate this copy of ApexSQL Report" link in the home page of ApexSQL Report and following the instructions provided in the next step. Click Here for more information.

"Report Diagnostics" helps to determine different problems in stored procedures. Syntax errors, accidental deletion of some procedures or tables used in current reports, etc. ApexSQL Report tries to run each stored procedure and catch errors (if any). It will run each report with NULL parameters and analyze return code to see if there was an error. If so it will be reported. The self diagnostic will also analyze each report to see that it's constituent stored procedure does, in fact, exist and is not missing. After that all error messages are gathered and shown in a HTML table format in order to help the user solve any problems.

The "Report Filter" is used to search for & save a specific subset of reports from a large number of reports by entering search criteria. If you are satisfied with the set of report returned, the search can be saved by clicking Save Filter. The tree view will be refreshed showing only those reports in the filter.

Aggregate functions are supported using the following datatypes: Integer, Numeric, Decimal, TinyInt, BigInt, Double, Currency, Single, SmallInt, UnsignedTinyInt, UnsignedSmallInt, UnsignedInt, VarNumeric, UnsignedBigInt.

Yes, the first time you have log in it must be as the administrator. Once logged in as the administrator you can create users in the Add/Edit Users module.

An administrator has access to the Admin Console allowing him/her to create/edit/delete users. An admin also has full access to all reports in the system.

Users with all privileges (create/edit/delete all reports) have similar rights to an admin but don't have access to the admin console so they can't make changes to other users.

Users can be deleted by administrators by going to the "Administration" tab and selecting Add/Edit Users. Click the icon to the left of a user's name to delete him or her.

Groups can be deleted by administrators by going to the "Administration" tab and selecting Add/Edit Groups. Click the icon to the left of the group's name to delete it.

Reports can be deleted by anyone with delete permissions by going to the "Report Maintenance" tab and select Edit Reports. After selecting the report you wish to delete click the first icon in the group of icons in the top right corner.