Group Option in Crosstab Expert - trying to save time

[shaleen7]

In the row of the cross tab expert I selected group options because I want to create 2 specific groups (pets, zoo) from a list of animals. The list for each group is very long. Each group has about 100 animals in it. Is there any way of import a list through the crosstab expert or do I have to input each one manually?

Pets Zoo
dog lion
cat tiger
"" ""

Any suggestions would be greatly appreciated?

Thank You

 

[synapsevampire]

This type of information is typically available in the database, not defined within Crystal. I'd suggest adding a column to a table to define each animal type, otherwise you're in the manual mode.

-k

 

[lbass]

I would start by creating a formula (in the main report or within the crosstab):

if {table.animal} in ["dog", "cat","rabbit"] then "Pet" else "Zoo" //if they are one or the other, you only have to list out one of the alternatives

You could copy the list from elsewhere into the formula, adding the quotes and commas.

Then use the formula as the row in the crosstab.

-LB

 

[synapsevampire]

As you initially intended, you can code this, but I caution against this as you'll have to adjust the report formula for any future changes.

If possible, think long term and resolve the issue in the database.

Even a new resolver table (if you can't modify the current tables) will easily fix this and lend itself to reusability and maintenance.

-k