OK,
I am using a query which accepts a linked parameter to create a sub-report. When I type the linked data straight into the query the data queries correctly. When I pass the same data through the parameter it doesn't pull any data. The query runs in SQL Management Studio so I know the data exists.
The query is:
select * from pmappedu Inner Join prmisccd on pmappedu.pmad_inst_cd = prmisccd.prms_code where pmappedu.pmad_ssn='{?Pm-Command.pmaq_ssn}'
I can display the parameter value in the report and it's correct. All data types seem to match. I am not sure what else to do.
Sam