Creating a report using the Composite presentation style

StepsTo create a report using the Composite presentation style:

  1. Select File>New>Other from the menu bar of the Web Application Development perspective. The Select a Wizard page opens

  2. Expand Sybase and select DataWindow. Then, click Next. The New DataWindow Object wizard opens.

  3. In the Create DataWindow Object page, enter values for the following fields and click Next.

    Field

    Value

    DataWindow library

    Specify the library in which the DataWindow object is to be saved.

    DataWindow name

    Enter the name of the DataWindow object you want to create.

    Presentation style

    Choose Composite as the presentation style for the DataWindow object.

    The wizard displays all reports (DataWindow objects) that are in the current project's library search path.

  4. In the Database Connection Profile page, select an existing database connection profile or create a new one. To create a new database connection profile, see Step 4 in “To create a new DataWindow library:.”

  5. In the Choose Nested DataWindow for Composite page, click the reports you want to include in the composite report and then click Next.

    The wizard lists your choices. It displays all reports (multiple DataWindow objects from multiple DataWindow libraries) if you have configured a DataWindow library list. To configure a DataWindow library list, see Configuring a DataWindow Library List

  6. In the Ready to Create Composite DataWindow page, click Finish.

    Sybase WorkSpace places boxes for the selected reports in the Design view. In this example, you see three reports:

    The sample shows three boxes in the Detail band of the design view. One at the top is labeled composite product sales. Below it are composite product on the left and composite sales reps on the right, with all text underlined.

  7. Look at the Preview view of the report:

    The preview view displays a Product Sales Summary at top left with five columns of data and a bar graph at top right that plots dollar amounts from the Product Sales Summary on the x axis and product names on the y axis. Below is a Product and Current Inventory report of five columns on the left and a report labeled Sales Representatives and Total Number of Orders with four columns of data on the right.

    Notice that you are in print preview (which is read-only).

    NoteWorking with composite reports Many of the options available for working with reports, such as Rows>Filter, Rows>Import, and Rows>Sort, are disabled for a composite report. If you want to use any of these options, you need to access the nested report(s), where these options are available.

  8. Continue to enhance the composite report (for example, add a date and title).




Copyright © 2007. Sybase Inc. All rights reserved. Placing a nested report in another report