Crosstab percentage to show all values but display on parameter

[AnnetteB1305]

I have a report I need to do to show a crosstab of a count of calls of hardware type by country. So I have set up the crosstab with @country as the column and @hardwaretype as the row and a distinct count of callref plus a further summarised field showing distinctcount of callref but as a percentage. Now the report is required to display the hardware type of a category that the user selects which I have used a parameter for the user to select from. The issue is I only want to display hardware types of this category on my crosstab but I need the percentage to be worked out on the total across all hardware types. This is where I am stuck. I did originally have the formula in my selection criteria {?Hardware Type} in {pcdesc1.info} as the percentage showing all hardware types is a new requirement.

Any help would be greatly appreciated

Thanks,

Annette

 

[Madawc]

I don't think you can. You can get the same result using a Mock-Crosstab, which issomething that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then. Crystal should have included an example along with the Crosstabs.

You can save a little time by doing a paste to a dummy report, changing the name and then pasting back. In Crystal 11.5 or Crystal 2008, you can also duplicate formula fields using the Field Explorer.

It always helps to give your Crystal version - 8, 8.5, 9, 10, 11 2008 or whatever. Methods sometimes change between versions, and higher versions have extra options.


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