Good day, I have the following formula to hyperlink the Reference Number of a ticket so that a user from the BOE report can open the ticket. However, it opens the ticket in the same window as the BOE report, thus you cannot go back and select the next ticket. You have to re-run the report.
=If IsNull([Request Id])=1 Then "" Else
"<a href=\""+"http://vaww.nsd.va.gov/CAisd/pdmweb.exe?OP=SEARCH+FACTORY=cr+SKIPLIST=1+QBE.EQ.id="+FormatNumber([Request Id] ;"######")+"\">"+[Request Ref Num]+"</a>"
Is there a way to force the hyperlink to open in a NEW window so that the user can go back and forth between the BOE results and the viewing of the selected ticket?