.NET Crystal's Select Expert for different columns/fields

[Max]

Hi,

Is it possible to have different Select Expert formula for
different column or Fields at once? I can't figure out
how to calculate totals for different fields such as count
and total of sales for different years WHILE excluding
details (rows) having values of 0 for sales.

For example if I want to count and sum each record for
each year while EXCLUDING records having Sales of $0:

Year1 Year2 Year3
Count 5 7 8
Total 100 500 800

This would require a different Select Expert formula for
each year and not one for all the years!

How can I get counts and sums different for each years?

Help would be appreciated.

Regards,

Max.

[Yan-Hong Huang[MSFT]]

Hello Max,

Based on http://support.microsoft.com/?id=317789, Microsoft supports setup
and installation for the Crystal Reports products that are included with
Visual Studio .NET. All other support is provided by Crystal Decisions.

So in addition to posting your question here, also look at
http://www.crystaldecisions.com/. Though it ships with Visual Studio,
Crystal Reports is supported by Crystal Decisions. 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.

Thanks very much for your understanding.

Best regards,
Yanhong Huang
Microsoft Online Partner Support

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

[Wade Coonrod]

Try this...
http://www.crystalreportsbook.com/Chapters.asp

I found this helpful.
"Max" <de*******@woolworths.com.au> wrote in message
news:06****************************@phx.gbl...

Hi,

Is it possible to have different Select Expert formula for
different column or Fields at once? I can't figure out
how to calculate totals for different fields such as count
and total of sales for different years WHILE excluding
details (rows) having values of 0 for sales.

For example if I want to count and sum each record for
each year while EXCLUDING records having Sales of $0:

Year1 Year2 Year3
Count 5 7 8
Total 100 500 800

This would require a different Select Expert formula for
each year and not one for all the years!

How can I get counts and sums different for each years?

Help would be appreciated.

Regards,

Max.