Crystal Report - How to pass multi value parameter in crystal report with store procedure

Parameter: select multi customer for report


1. Create store procedure :

create proc report

@CardCode nvarchar(max)


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

1 comment

  • free casino real money casino casino slots casino real money


Leave a comment