Hi,
I looked thru the message board and did not see a previous answer on this one. I have a report filter that works(as shown below), but would like to logic to have all records selected by v_tooltype if "All" is the selection.
I'm trying to figure out how to do that with a .OR. conditional statement to grab all records instead of just 1 that is currently selected by a dropdown.
filter = "between(date,[varD->begindate],[varD->enddate]) .and. v_tooltype = Invoice_Items->Tool_Type .and. v_issue = Invoice_Items->rec_type"
Thanks for any advice....and here is the entire report
'Date Created: 18-Jul-2002 09:41:43 PM
'Last Updated: 03-Aug-2009 11:10:40 AM
'Created By :
'Updated By : Ryland
if option = 1 then 'print today's transactions
filter = "date = [varD->today]"
else if option = 2 then 'transaction selection criteria
filter = "between(date,[varD->begindate],[varD->enddate]) .and. v_tooltype = Invoice_Items->Tool_Type .and. v_issue = Invoice_Items->rec_type"
end if
'substitute the parameters in the filter expression
filter = replace_parameters(filter,local_variables())
if print_option = "preview" then
report.preview("Tool Transaction Report",filter)
else
report.print("Tool Transaction Report",filter)
end if
Ryland
I looked thru the message board and did not see a previous answer on this one. I have a report filter that works(as shown below), but would like to logic to have all records selected by v_tooltype if "All" is the selection.
I'm trying to figure out how to do that with a .OR. conditional statement to grab all records instead of just 1 that is currently selected by a dropdown.
filter = "between(date,[varD->begindate],[varD->enddate]) .and. v_tooltype = Invoice_Items->Tool_Type .and. v_issue = Invoice_Items->rec_type"
Thanks for any advice....and here is the entire report
'Date Created: 18-Jul-2002 09:41:43 PM
'Last Updated: 03-Aug-2009 11:10:40 AM
'Created By :
'Updated By : Ryland
if option = 1 then 'print today's transactions
filter = "date = [varD->today]"
else if option = 2 then 'transaction selection criteria
filter = "between(date,[varD->begindate],[varD->enddate]) .and. v_tooltype = Invoice_Items->Tool_Type .and. v_issue = Invoice_Items->rec_type"
end if
'substitute the parameters in the filter expression
filter = replace_parameters(filter,local_variables())
if print_option = "preview" then
report.preview("Tool Transaction Report",filter)
else
report.print("Tool Transaction Report",filter)
end if
Ryland
Comment