Crystal Reports User Parameter To Query

Question

I'm trying to develop a Crystal Report that passes the user executing the report as a parameter to the report query.

I'm using Business Objects Enterprise, executing the reports through InfoView which I would assume uses the Crystal "Special Fields" Current CE User Name, I just can't figure out how to link that to the query.

Am I thinking about this the wrong way or is this not possible in Crystal?

Thanks.

Answer 1

Use the parameter in the record selection formula. Right click in the report, select "Report -> Selection Formula -> Record...". Then enter a formula - something like this:

{my_field_name} = {?my_parameter_name}