Need help to write a report with Crystal Report
Quote:
>We try to create a report with information from multiple tables in a single
>page. When a primary record shows on the top, all the information related
>to that record should display under the following several categories.
>Because the unique sophisticated layout of the Crystal Report 5.0, we don't
>what we should do to put all data on the single page with a fixed format.
>Thank you for your help!
Have you looked into subreports? A subreport is basically a report object
embedded in another report object. You can link them together if you need to
do a master-detail type of report, or they can be unrelated.
Let's say you wanted to print a report that listed all of your products. Then
beneath it you wanted to have a section that listed all of the clients who
bought the product and another section that listed, say, the remaining
inventory in each of your stores. You could create three reports. The main
report would use a query that gathered the relevant product data from, say,
the products table. A second report would query sales by product from the
orders table. A third query would get inventory by product from the inventory
table. The linking field for each report would be the product ID. (Internally,
Crystal would handle this as a parameter for the two subreport queries--the
current product in the main report would be passed to each subquery as the
product ID parameter.)
I think it might be easier than my explanation made it sound <g>.
Hope this helps,
Bob
