Invoice Issues 1

[cheyenne2002]

I'm trying to create a report that will be an invoice.

I am creating invoices for pledges (donations). My donors may have given us a pledge of 5,000 but they might wish to pay in increments. So I created a record for each date that they are planing on paying.

I need to be able to have all the unpaid pledges show up on the invoice and then a total due. I think I have accomplished that.

My problem is that I get a separate invoice for each record and they all show all the pledges for that donor.

I can't figure out what I have done wrong. Any ideas.

Thanks in advance.
Sharon

 

[Remou]

Have you set the Sorting and Grouping options for the subreport?

 

[cheyenne2002]

I think I have, but to make sure I'm looking in the right place where exactly are you referring to.

Sharon

 

[Remou]

Click on the report within the subreport control and choose Sorting and Grouping from the View menu.

 

[cheyenne2002]

My first field is [CampaignName] sorted in Ascending and it has a header

The second is [ExpectedDate] and it is sorted Descending.

But it does not seem to be working right.

Sharon

 

[Remou]

That may be the problem. Sort by ExpectedDate only and sort ascending.

 

[cheyenne2002]

Thank you so much, I finally got it.

Sharon