Thanks Shawn

Sorry for giving wrong info about VS 2010

Client has two environment Acceptance & Production

and i have developd report in in Vosual studio 2008 and SQL 2012

Dose JOIN function in Report will work if yes then how?

I have developed report in Microsoft Visual Studio 2008 only

No I am directly using query

no i am directly using query

Correct

yes correct , Main query is

SELECT

max(drpb.drpb_bsn) as BSN,

atct.atct_global_id as Corp_ID,

replace(ltrim(replace(atct.atct_global_id, '0', ' ')), ' ', '0') as Corp_ID_match,

atct.atct_local_id as Local_ID,

...

Parameter query where am using multivalue

select distinct hr_agreement_contract.atct_contract_status

from hr_agreement_contract

where isnull(hr_agreement_contract.atct_contract_status,'') not in ('A','L','P')

Union

select 'A'

Union

select 'L'

Union

select 'P'

I have attached error in document