I need to be able to pass a calculated field from a tabular report datapage to a submit datapage thru a link. The calculated field is 'Age'. it is calculated using the following:
SELECT CAST(DATEDIFF(YEAR,'[@field:Date_Of_Birth]',GETDATE()) AS VARCHAR(10)) + ',' + CAST(DATEDIFF(MONTH,'[@field:Date_Of_Birth]',GETDATE())-(DATEDIFF(YEAR,'[@field:Date_Of_BIrth]',GETDATE())*12) AS VARCHAR(10)) AS Age
I am passing other fields from the report to the submit page, but can't figure out how to pass the calculated field.
Thank you!
Leigh