Passing a field to a sub report

[scotthendoau]

Hey guys I have been trying to pass a field to a sub report but am having troubles. Given the SQL:

 

SELECT extract(year from request_time) as time

 

I want to pass the time field to a sub-report so that i can generate a report just based on that year. Now I have tried using a parameter and setting the parameter to the field using the default value expression but this gives an error.

 

Does anyone know how I can implement this?

 

Thanks in advance, Scott

[scotthendoau]

Thats ok guys, have solved the problem.

 

Rather than setting up the year as a parameter in the main report and then sending that to the sub report, add the year as a parameter by right clicking on the sub report and adding it there.