Report Definition


The Definition screen is where you define the details of the columns to be used on the Report.

Definition Settings:

Report Title. Give your report a Header name that will appear at top, center of the report.

Special Where Clause. Enter a SQL where clause to filter the returned data.

Maximum rows to report on. Set the maximum number of rows to be returned for the report. This gives you the ability to limit network traffic by not allowing reports based on queries that are too large. The default is 500.

Choose columns by which to order your report. Here you choose the columns to order the report results and totaling. For example, if your are reporting on a sales table, you might order by the columns Division, Sales_Rep and Monthly_Sales, in that order. You would probably elect to subtotal and grand total the Monthly_Sales column.

To do this type of ordering, double-click the columns in the left-hand list in the proper sequence and they will appear in the panel on the right, the group by list. You may also select a column name and press one of the Arrow buttons, ">", or "<", to move the column to and from the ordering list.

For each column you may also choose to have it subtotaled and grand totaled by choosing Yes or No from the corresponding pull downs. Subtotals will appear at the end of each unique grouping, such as the end of each sales rep’s monthly listing.

When you have selected the ordering columns, press Accept.

Definition Action Summary:

  1. Enter the title of the report. If necessary, you may add a special SQL Where clause to control all of the data returned in the report.
  2. In Maximum result rows, choose the maximum number of rows to be returned in the result list. The default is 500. BulletProof recommends 500 or less to minimize network load and maximize query speed.
  3. Add any number of columns from the left-hand list to the right-hand, or group by, list.
  4. Choose whether or not you want to subtotal or total for each ordering column.
  5. Once you have setup all your result parameters, press Accept.