Urgent: Condition Reports

  • Thread starter Thread starter Ashish Kanoongo
  • Start date Start date
A

Ashish Kanoongo

I want create a Invoice report in which there will be 3 sub form, and one header. User will enter invoice range (from-to) from another form. The report will be printed as per invoice parameter i.e. at a time one subform and header will print.

Let me guide how do I manage this? Secondly my invoice is having letter size, so If I print multiple invoice, invoice should print correctly,.

On both issue is there any url/turorial/sample on this? So I can eview this and complete my reports.
 
Ashish,

Try this.

Create a report with the header in the Page Header section.

Insert a SubReport control in the Detail Section.

Set the Source Object to one of your invoice forms. Name this Subform
Invoice1.

Set the Force New Page of the Detail Section to After Section to force each
onto a new page.

Test this until it is printing as desired for one type of invoice.

Copy the subform and paste it into the Detail Section. Name the new Subform
Invoice2. Set the Source Object to 2nd invoice form.

Repeat this and produce Subform Invoice3.

Move Subforms until they are all completely overlapping.

In the Detail_OnFormat event add code which sets the Visible property of the
appropriate SubReport to Yes and the others to No.

Hope these suggestions help,

Rod Scoullar
 
Back
Top