On the sub report query click on the prompts button:
Create a new prompt:
Create the SQL query from the prompt:
begin
if (@__filterwildcard = '')
select distinct Name0 from v_R_System WHERE isnull(Obsolete0,0)<>1 order by Name0
else
select distinct Name0 from v_R_System
WHERE Name0 like @__filterwildcard
and isnull(Obsolete0,0)<>1 order by Name0
end
Create a link on the main report linking it to the sub report.
No comments:
Post a Comment