Monday, 18 July 2011

How To Link The Two Reports Together

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