Parameter: select multi customer for report
1. Create store procedure :
create proc report
@CardCode nvarchar(max)
as
select * from ocrd where CHARINDEX(CardCode, @CardCode) > 0
2. Create blank crystal report
+ Add parameter for cardcode, set multi value as true
+ Change para name to CardCode@Select CardCode, CardName from OCRD
+ Add formular Multicardcode, set formular: join({rpt.CardCode},":")
3. Add Sub report
+ Calling Store Procedure above in this sub report
+ Link fomular Multicardcode From Father report, to @CardCode of Sub Report