Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

Display multiple investment managers in Crystal Report parameter output

  • 1.  Display multiple investment managers in Crystal Report parameter output

    Posted Apr 27, 2015 04:48 PM

    Question here for Crystal Reports developers.

     

    Say we have a SQL command generated Crystal Report that simply lists project information. As parameters in the query I have created and set the following parameters;

     

    AND   (0 IN {?param_investment} OR i.id IN {?param_investment})

    AND   (0 IN {?param_i_manager} OR i.manager_id IN {?param_i_manager}).

     

    Each parameter essentially gets either the investment_id (number) or the investment manager_id value (number), which is joined back to srm_resources table to display the project manager name.

    Each parameter is allowed for multiple values.

     

    In Clarity there are two parameters set, one for investment and one for the project manager, each associated to a browse lookup (joining on the internal id values as number as that is the sql value in the report parameters). No issue running the report for multipe investments or project managers, but I need to output all the parameter values (essentially 1 to n) somewhere on the report for either one selected.

     

    Does anyone have some hints they can share on how to dynamically get the parameters to output on the report?

     

    Many thanks,

    Allen



  • 2.  Re: Display multiple investment managers in Crystal Report parameter output

    Posted May 04, 2015 02:55 PM

    Can anyone help Allen with questions?

     

    Thanks

     

    Display multiple investment managers in Crystal Report parameter output

     

    Question here for Crystal Reports developers.

     

    Say we have a SQL command generated Crystal Report that simply lists project information. As parameters in the query I have created and set the following parameters;

     

    AND   (0 IN {?param_investment} OR i.id IN {?param_investment})

    AND   (0 IN {?param_i_manager} OR i.manager_id IN {?param_i_manager}).

     

    Each parameter essentially gets either the investment_id (number) or the investment manager_id value (number), which is joined back to srm_resources table to display the project manager name.

    Each parameter is allowed for multiple values.

     

    In Clarity there are two parameters set, one for investment and one for the project manager, each associated to a browse lookup (joining on the internal id values as number as that is the sql value in the report parameters). No issue running the report for multipe investments or project managers, but I need to output all the parameter values (essentially 1 to n) somewhere on the report for either one selected.

     

    Does anyone have some hints they can share on how to dynamically get the parameters to output on the report?

     

    Many thanks,

    Allen