471,318 Members | 1,971 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,318 software developers and data experts.

Crystal rpt result duplicate recordset: Source Access Parameter Qu

I am currently developing a VB.Net App that utilized an MS Access file to
store the data. My Report data source is a Parameter Query in MS Access when
the report loads the parameter is prompted twice? The result set in the
report ends up with duplicate records. How can I overcome this Problem?

Sample Code:

Private Sub frmCryReport_Load(...)...
Dim parPN as New ParameterDiscreteValue
Dim parList as New ParameterFields
Dim parTemp as ParameterField
Dim rpt as crystalReportName

objCryViewer.ReportSource = Nothing

parPN.Value = strPN 'Part Num for parameter

parTemp = New ParameterField
parTemp.ParameterFieldName = "[PNsel]"
parTemp.CurrentValues.Add(parPN)

parList.Add(parTemp)

rpt = New crystalReportName

With objCryViewer
.ParameterFieldInfo = parList
.ReportSource = rpt
End with

End Sub

Any assistance would be greatly appreciated, thanks so much!

Jul 21 '05 #1
0 1014

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Stephan | last post: by
2 posts views Thread by Rana | last post: by
22 posts views Thread by Gerry Abbott | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.