Skip to Content
0
Former Member
Feb 26, 2009 at 04:00 PM

Issue accepting sub-report parameters using Command queries

19 Views

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