need to display shared variable in a cross tab

[andie18]

hello,

I am writing a report (Cr 8.5 developer, GoldMine, SQL (MS2000)That is need to display summaries on a weekly basis. So I put in a group footer (based off of userid) a cross tab that only has 1 column for the date ({conthist.ondate}) and I have it counting history activities such as appts., closed sales, etc... I need to add one more summary to show the sum off all sales, whether pending or completed so this pulls from 2 databases (CAL, CONTHIST) My first thought was a shared variable but you can't display a summarized shared variable in a cross tab. So I am wondering what else can I do such as a numbervar style formula (I'm pulling straws here)

Any ideas?

TIA for the help

 

[andie18]

I should add that the reason why I am doing this in a cross tab is that I need to export it to Excel and it is much easier to format.

I am open to laying around with the layout

 

[chelseatech]

In Cr9 you could use the "DisplayString" format properties to display your shared variable value. Ken Hamady uses this to calculate ratios inside a crosstab.

You have to sort the data carefully, but it might solve your problem.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm