Create VB String Variable... Could be a single String variable or String concatenation like this:
Now use that VB Variable in Report Properties like this - note the filename in Report Properties appears to be blank it must contain a character like " " or "_"
Code: Select all
MyName = InputBox("what is your name?", "Enter Name") MyLot = InputBox("Lot Number?", "Enter Lot Number") FileName = MyName + "_" + MyLot
Also note you can control File Path by adding "\" character(s) to VB String Variable.
The Vb Script above results in 2 InputBox(), when populated as shown the result is report file here - C:\Users\Public\ Nathan_42.rpt