Cystal Reports , Group Expert and 'Others' Question 1

[gingerwelshguy]

Morning All -

Need some help on Crystal please;

I have created a report which has 4 Groups in the Group Expert. Groups are in sequence below....

Country (market)
Service Type. (Incident or Request)
Business Categorisation. (In Specified order showing Brand Marketing, Commercial Marketing, Customare Care, Ecommerce, plus another 15 categories that I was asked to list. Everything else has got listed as Others as there is about another 500 business categorises in the database to choose from)
Product Name

The report runs as designed but I want to show just those records labelled now under Group Expert as 'Others' and hide/remove the additional records that I listed originally (eg Brand Marketing, Commercial Marketing, Customare Care, Ecommerce) from the report itself

Is there a way to do this or formula that I can use just to show the 'Others' only?

I have tried the following; In Group 3 I have selected ascending order and then in Select Expect stated that Busienss categorisation should not be one of Brand Marketing, Commercial Marketing, Customare Care, Ecommerce etc but this came back then with different totals between the two reports (when nothing else was altered)

Any help would be appreciated...

Thanks
Martyn

 

[briangriffin]

It sounds like you'd be better off getting rid of the specified order groups and instead create a formula:

if not ({BusinessCategory} in ["Brand Marketing", "Commercial Marketing", "Customer Care", "Ecommerce"]) then "Other" else {BusinessCategory}

Then group on the formula field; that should give you more flexibility in the select expert. I'd probably create a multi value parameter field and hardcode the above values, plus "All" and "Others Only".

 

[gingerwelshguy]

Hi Brian - Thanks for your help and time.

Still having issues, I got rid of the order groups, added your formula in and tried selecting "others" from the Select Expert but when I refresh the total count of tickets is different from the original report.

The report should displays 237 Incidents for the previous month which is correct. Out of these 193 are listed as Others based on Business Categorisation, the remaining 44 are either Brand Marketing, Commercial Marketing, Customare Care etc which is specified in the Group Expert - table itself is HPD_Help_Desk.Product_Categorization_Tier_3

However I have noticed that a lot of the Incidents listed as "Others" does not have a busines category selected in the field in the helpdesk database itself its been left blank) so when I try and just focus and select on the Others (and ingore everything else) based on your formula , it does not show all the records - only 149 get returned as 'Others' rather than 193.

Is there a formula to say that if HPD_Help_Desk.Product_Categorization_Tier_3 has nothing entered in the helpdesk database field to display the record anyhow. Why would the total when Others are grouped together be 237 but when I want to just select Others the total changes? Excuse my lack of knowledge...

Many Thanks
Martyn

 

[briangriffin]

Let's try trapping for the nulls and see if that takes care of it:

if not ({BusinessCategory} in ["Brand Marketing", "Commercial Marketing", "Customer Care", "Ecommerce"])
or isnull({BusinessCategory})

then "Other" else {BusinessCategory}

 

[gingerwelshguy]

Hi Brian -

That formula has worked and returned 193 records (showing as Others only)and discarded everything else.

Thank you very much for your help !!

Martyn