Grouping on Parameters

[shahdu]

Hi,

I'm not sure if this is possible within CR9 (yes, a very old version, to be replaced sometime later this year). We have some financial reports that need to show the projects under a particular employee regardless of whether there is any data against that project code.

So here is what I'm trying to get to work:

1. Allow user to enter a project parameter. They should be able to enter multiple values

2. Use all values entered in the parameters so that they appear as groups irrespective of whether they have data or not.

I've been playing around and searching everywhere but no joy.

Any ideas?

Shahdu

 

[IanWaterman]

YOu need to add a table holding all your employees, make this the first table in your link expert window and left join all your current data from this table.

Link your selection parameter to employee data from this table in select expert.

Report will now list all employers in selection parameter, regardless of whether there is any data or not.

Ian

 

[shahdu]

Thanks Ian,

We had considered something like this. I'm going to try giving it a go and will let you know how we get on.

Thanks again for the quick reply.