Manual crosstab vs automatic crosstab

[kenpo123]

Hi
I am using CR 8.5 and reporting from Lotus 4.6



I have to produce a report on my customer license installed base. The table contains the software name and the version number. I have to report the data not by version but by the fact if it is the current version, previous version or 2 + version back. The version schemes are different from one product to the other. My approach was to do a manual crosstab and use the max function to find out the current version and then compare. My report is working fine but now I need to chart my result. Any idea





Example

software_config version
product A 5.0
product A 6.0
product A 7.0
product B 9.0
product B 10.0
product B 10.0


Crosstab result should give
Current Version Previous Version 2+
Product A 1 1 1
Product B 2 1 0

 

[Madawc]

A chart will work by existing groups in the report. Whether or not you also have a crosstab is not relevant.

If your main report does not have the correct groups, do a subreport with suitable groups and have that produce the chart. Put the subreport in the main report header or footer.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10