Crystal Reports User Parameter To Query
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.
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}
精彩评论