Would anybody know where I could get good information on this, as I need to find out will ViP fit the bill for a project I'm working on.

I've already created a HTML file from a data abject but remember reading somewhere that it was possible to create a banded report!

Any help gratefully received.

Thanks

Tony

DX has the capability of constructing a ViP application that will make HTML banded reports. The Help and documentation for DX should give you additional information.

You can use the DX Utility to create applications that publish one or more HTML files with tables for each band in the report.

To create an application that publishes an HTML banded report:

1.Set application type to HTML Banded Report.

2.Define two or more report band tables.

Each report band table contains the columns that are required for a particular band in your report. A band report table may be a regular DX source table or a temporary join result table.

The first band, for example, could contain regions and total sales per region. The second band could contain districts within the regions and total sales per district, and the third band could contain sales reps in each district and total sales per sales rep. The source tables might be Notes categorized views. They could also be Notes forms or ODBC tables, in which case each band would contain a grouping column (region, district, sales rep) and an aggregate column (total sales per group). If the banded report is to include hyperlinks to Notes documents at the detail level, you must include the $NoteID column in the definition of the lowest-level band table, so that DX can determine the appropriate URLs for these hyperlinks.

3.Click HTML Band, and use the Detail Band dialog to lay out the parent-child relationship between two bands at a time.

2.Define the parent-child relationship between the report band tables.

Double-click the Action Not Defined icon at the bottom of the report band tree, which opens the Detail Bands window. From this window you can select each parent-child pair and open the Detail Band Operation window. Use this window to enter selection criteria for the parent band, to set column labels for the report, and to define a Detail key.

The Detail key specifies how selection criteria are to be generated for each row in the parent table to retrieve the appropriate rows in the child table. If the parent is a Regions table and the child a Districts table, then the key is the Region column in both tables. So when the parent region is Northeast, DX will use the Districts table to retrieve rows for all the districts in the Northeast region.

After you have defined all the parent-child relationships, the Banded Report icon. replaces the Action Not Defined icon for the report band series.

3.Use the HTML Target Table(s) window to customize the HTML output.

If the HTML banded report is to include hyperlinks to Notes documents on a Domino server, include the Domino Host setting (for the Revelation Sofware website, the Domino Host is "www.revelation.com"), which is used to construct the hyperlinks to the documents.

4.Generate the application.

After you generate the application, the DX Utility offers you the option of running the new application and previewing the HTML file(s) that it generates.

Hope this helps,

ViP/DX Tech Support

View this thread on the forum...