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......
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment