Crytarl Report with Dabase access

[cerebro]

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 application

[manju_ambare]

As 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.......