A user would like a Crystal report that looks at the activity types and the activity subjects. When running the report in SAP Business One, they would like a drop down list of the current activity types, and then to show a drop down list of the subjects that are linking to the activity types.
I tried setting this up. The problem is, when you create one parameter for both the type and subject, it doesn't give you a drop down list in SAP. I have created two separate parameters, using a SELECT statement in the parameter names. This gives the drop down lists in SAP, but it doesn't restrict the list of subjects based on the type chose. Therefore I was wondering if there was a way to link these two parameters after they have been created?
I was told it can be done, but unfortunately I haven't found a solution yet.
Thanks for reading,
Steve