Selection formula 3

[brendalanigan]

Hello,

There is probably a very obvious solution to this question but I cannot work it out!

I am using Crystal Reports 9 reporting on an Access database. I have a table called Enrolment which contains a column called group.At present I am using a parameter which forces the user to choose which group to report on.
How do I create a selection formula which will make the report run for all the groups that are listed in the Enrolment table?

Many thanks.

 

[Madawc]

I'm not sure I understand. Are you saying you have a table that has one record per group? And another table that has details for these groups, as well as data for groups not in the first table?

If so, you should be able to do it all by links, from the table of groups to the data, normal link rather than left outer.

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

 

[KeertanaCR]

Change the selection formula to
if
{?Parameter}='ALL' then true
else
{Enrollment.group}={?parameter}

*Enter ALL for all groups*

 

[brendalanigan]

That worked, thanks very much for that!

 

[synapsevampire]

You can simplify that:

(
{?Parameter}= "ALL"
or
{Enrollment.group}={?parameter}
)

For advanced reading on the topic check out my FAQ:

faq767-3825

-k