Tuesday, February 14, 2012

Crytarl Report with Dabase access

dear all ,

i use crystal report from dot net 2003 (i use dotnet version architect).
with database access.

and i have problem to set parameter for query access in crystal report.

if i use database mssqlserver 2000 in crystal report i just select store procedure and the parameter for store precedure will otomatically add in crystal report.

sampel query store procedure like this

select * from tblcustomer
where CustName = @.custName

the parameter @.CustName otomatically add in crystal report.

how to implament that if i use database access.
so i can send a value for @.Custname from my applicationAs i have worked for VB.net so i'll how i used to send parameter value externally
first u need to define
Dim pv As New CrystalDecisions.Shared.ParameterValues
Dim pdv As New CrystalDecisions.Shared.ParameterDiscreteValue

pdv.Value = EntityCode
pv.Add(pdvScriptCode1)

RptViewer.DataDefinition.ParameterFields("@.Customer").ApplyCurrentValues(pv)

thats it...
Try it out n tell me the result whther its working......

No comments:

Post a Comment