controlling parameters and groupings

[johnjrd]

Is it possible to control what field you set a parameter for.

i.e
I have a report that needs to run either by grouping by Venue or Venue Group Area

now i can set up parameter which controls the input for a formula and use the formula to set up the groups

i.e. if {?sort choice} = 'Venue' then {venue.venuename} else
if {?sort choice} = 'Venue Group' then{vnugroup.grpname}


any help would be appreciated
therefore i can create the group based on the outcome of the formula and this works fine no problem.

However is it possible to take this further. If the sort choice parameter = 'Venue' is there a way to then display all the venues and pick one so the report can be filtered to a individual venue name and likewise if the sort choice parameter = 'Venue Group'.

 

[kenhamady]

The parameter "pick list" is static in Crytsal, so it can't change. However, there is a third party tool that allows you to generate the picklist within another report, and this might be able to do what you are asking for. See the LINKS page of my web site and take a look at the Data Link Viewer. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com