CrystalReports Question

[BuddyWork]

Hello,

I'm trying to display a report that has the following query

SELECT DonorName, Created_Date=MAX(Created_Date),
Amount=SUM(Amount)
FROM Donation WHERE Created_Date > 'Apr 06 2003' AND
Created_Date < 'Apr 05 2004'
GROUP BY DonorName

I then have a report which I want to show all the donor
names grouped and also want to show the last created date
and the amount summed, everytime I perform the report it
shows each individual records, it looks like Crystal is
just ignoring the my dataset that I'm passing into the
SetDataSource object.

How can I archive this?

I'm using Crystal Report that came with Visual Studio 2003

 

[Shannon Geraci]

Do you have any groups set up on the report?

BTW, Crystal Reports also has a newsgroup section for posting questions.
You might get a faster response if you post there, if you haven't already...
http://support.businessobjects.com/forums/default.asp?ref=devzone_main

Shannon

 

[BuddyHome]

Thank you Shannon, I will post my message on to that forum.

Thanks again,