Using Minimum feature in a formula for a cross tab

[Sahubba]

Hello,

I am having an issue with a cross tab using a formula {username} +"-"+ totext(Minimum({date})).
I realize the reason why I am having this issue is because I have Minimum within the formula.

Has anyone encounter this issue before?
Can someone help me with a solution?

I am using 2008

 

[Madawc]

Crosstabs work from detail lines, not values derived from several detail lines.

If you grouped by Username, you could have Minimum Date as a summary total. Show other totals with it, as if it were a crosstab.

This could be a subreport if you have other data to show in your main report.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[Sahubba]

Thanks,
But there is no way to have it in a formula within a crosstab?

 

[Madawc]

Formulas are OK, so long as they are based on just one detail line.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP