BOE - Passing Parameters

[TheGoldMineGuru]

BOE XI

My crystal report uses a stored proc on SQL 2000. Parameters are (as configured within the Stored Proc); UserName, StartDate, EndDate.

I want the UserName to default to CurrentCEUserName so that the filtering take place at that level (within the stored proc), as opposed to using the Select Expert to say "{User} = CurrentCEUserName". Of course, I want to do this because I am assuming that querying a million row table is faster if the Stored Proc can do all the processing versus Crystal Reports filtering the results.

Is there a way to configure CurrentCEUserName as the default parameter within the report properties (in the Process tab)?

Hopefully that makes sense. I appreciate the help!

 

[Turkbear]

Hi,
Since there is no default CurrentCEUserName ,
how would you specify it prior to the report being run?





To Paraphrase:"The Help you get is proportional to the Help you give.."