passing a value to a parameter in a subreport

[ifthenelsenull]

I need to pass a value from the main report to a subreport's parameter. The main report pulls in all employees and the sub report is set up to return specific data to that employee using a parameter of their employee number.

The main report field is employee_id and the subreport parameter is @employee_id

When I create the sub report it runs fine but when I go to link it to the main report the parameter in the subreport is not available to be chosen so the main report ends up creating a second parameter in the subreport which then prompts twice instead of passing the data.

How can I pass data from a field in the main report to a parameter in a subreport aka "what am I doing wrong".

 

[lbass]

What is the content of the formula {@employee_id}?

Also, how does this display? How does the field display in the main report? They must match.

-LB

 

[ifthenelsenull]

I don't have a formula do I need one? I just have the field employee.employee_id in the main report and the parameter @employee_id in the sub.

 

[lbass]

But parameters aren't identified by "@". If these are both fields, then please show samples of how each one appears.

-LB

 

[ifthenelsenull]

Sorry in the SP they are defined that way.

In the main report it's just a field. {employee_id}

in the Subreport it's a parameter {?@employee_id}

I need to link [employee_id} in the main to {?@employee_id} in the sub. But when I choose {employee_ID} in the main it's not an option to choose {?@employee_id} instead it creates Pm-employee_id which doesn't pass to the parameters.

In the main report the datatype is INT the sub is a varchar if that matters at all.

 

[ifthenelsenull]

I solved it. It was a datatype mismatch. Once I cast the types to match it worked as expected. Thanks for your help.