Hi,
Iam using Basic Crystal Reports which comes with VS 2008 by default.
Here is my .rpt file design.
User will select a PRODUCT ID from the dropdown to generate the below report.
====================================================
Section 1 - Report Header - Have company logo & other details here.
Section 2 - Page Header - divided this into two sections.
Group Header Section 1
Total available product quantity : XXX
Total outstanding orders for this product : YYY
Group Header Section 2 - Column headings only
Column A Column B Column C Column D
Section 3 Details - Data in all columns - these values are coming the DB.
10 20 30 40
11 21 31 41
12 22 32 42
Section 5 Page Footer - Disclaimer
====================================================
One report can span between multiple pages.
Group Header Section 1 must be displayed only once in the first page of the product report.
Group Header Section 2 (column names) must be repeated in every page of the product report.
If user selects "ALL PRODUCTS" then reports for all products will be displayed one after the other i.e. As soon as the Product A report ends in Page 2, Product B report must start from Page 2 just below the Product A report.
Can anyone help me how to achieve the above requirement ?