I have a report and bring over a parameter from a list box in .net. this works fine and the parameter prints on the header.
The parameter is {?Mycategory}
I have created a command with the following statement and it works fine
select * from inventory where category = '{?Mycategory}'
what I want to do is to be able to use the report for two purposes.
1) if the user selects a categaory which is working
2) if the user wants a complete list
I assume the command would be the following
if '{?Mycategory}' = "Complete List" then
select * from inventory
else
select * from inventory where category = '{?Mycategory}'
end if
this does not work what am I syntaxing wrong?
clifford sutton
IP Logged
