Sue Taylor
asked on
Select Expert Sorting
I have a formula that get's 're-prioritized' after the report refreshes and doens't display what I'm expecting.
My Record Selection Formula looks like this:
{aptp_view_time_cards.JobN umber} = {?JobNumber} and
{@EndDateOnly} = {?DateParam} and
{@StartDateOnly} = {?DateParam} and
If {?EmployeeName} = 'ALL' then
{empMain.firstname} like '*'
else {empMain.firstname} = {?EmployeeName}
And I don't get any errors. However, when I refrsh the report, it displays more results that I anticipated. Then when I go in and look at the formula it has changed to this:
If {?EmployeeName} = 'ALL' then
{empMain.firstname} like '*'
else {empMain.firstname} = {?EmployeeName} and
{aptp_view_time_cards.JobN umber} = {?JobNumber} and
{@EndDateOnly} = {?DateParam} and
{@StartDateOnly} = {?DateParam}
How do I prevent this from happening?
Labor-Report---with-Parameters-N.rpt
My Record Selection Formula looks like this:
{aptp_view_time_cards.JobN
{@EndDateOnly} = {?DateParam} and
{@StartDateOnly} = {?DateParam} and
If {?EmployeeName} = 'ALL' then
{empMain.firstname} like '*'
else {empMain.firstname} = {?EmployeeName}
And I don't get any errors. However, when I refrsh the report, it displays more results that I anticipated. Then when I go in and look at the formula it has changed to this:
If {?EmployeeName} = 'ALL' then
{empMain.firstname} like '*'
else {empMain.firstname} = {?EmployeeName} and
{aptp_view_time_cards.JobN
{@EndDateOnly} = {?DateParam} and
{@StartDateOnly} = {?DateParam}
How do I prevent this from happening?
Labor-Report---with-Parameters-N.rpt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.