Dynamic expression that simply concatenates a URL with the value of a field in the report. In this example the name of the field is ID.
="http://www.somedomain.com/id="&Fields!ID.Value
This example uses javascript to open a new window.
Notice: The format is different. When using javascript you have to use + instead of & to concatenate.
="javascript:void(window.open('http://ritter.tea.state.tx.us/peims/standards/weds/index.html?"+ Fields!ElementID.Value + "','_blank'))"
This example opens a new window and uses the Right Function on the Field Value
="javascript:void(window.open('http://ritter.tea.state.tx.us/peims/standards/weds/index.html?r"+ Right(Fields!PEIMSRecord.Value,3)+ "','_blank'))"
This example opens a new window and grabs the url from a field within a database table.
="javascript:void(window.open('"+Fields!RefURL.Value+"','_blank'))"
This example uses javascript to open a new window.
Notice: The format is different. When using javascript you have to use + instead of & to concatenate.
="javascript:void(window.open('http://ritter.tea.state.tx.us/peims/standards/weds/index.html?"+ Fields!ElementID.Value + "','_blank'))"
This example opens a new window and uses the Right Function on the Field Value
="javascript:void(window.open('http://ritter.tea.state.tx.us/peims/standards/weds/index.html?r"+ Right(Fields!PEIMSRecord.Value,3)+ "','_blank'))"
This example opens a new window and grabs the url from a field within a database table.
="javascript:void(window.open('"+Fields!RefURL.Value+"','_blank'))"
Contributors: Mark Lansdon, Trey Lawyer
No comments:
Post a Comment