I am trying to automate a title to include information from a table into a title. So I am using a macro to define the selection criteria that I am given. %let id=123456   Then in the report I need to call that id# and return 2 specific pieces of information from the table. In an sql statement it would be written as:    select name, filenumber from table1 where id=&id   But I need to take the name and filenumber and put these into the title. Title1 "Report for &name &filenumber" This of course doesn't work but is the closest information I have ben able to find.  ... View more