Crystal Report Question

[BuddyHome]

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

 

[Tian Min Huang]

Hello,

For issues related to Crystal report, you can get support from crystal
decisions. Please kindly note that Microsoft supports setup and
installation for the Crystal Reports products that are shipped with Visual
Studio .NET. All other support is provided by Crystal Decisions, please
look at http://www.crystaldecisions.com/. They have a self-help section and
they offer phone & e-mail support. Their web sites states that you get two
Crystal incidents with the purchase of Visual Studio .NET.

You could also access their forum at
http://support.crystaldecisions.com/forums.

Please feel free to let me know if you have any concerns.

Have a nice day!

Regards,

HuangTM
Microsoft Online Partner Support
MCSE/MCSD

Get Secure! -- www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.