Visual Basic Crystal Reports - Change RecordSelectionFormula and Refresh

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Change RecordSelectionFormula and Refresh

BIta

2005-12-03, 3:58 am

Hello,

I am using CR 9 and VB6. In my VB6 code I have CR viewer. I set
RecordSelectionFormula
when the forms come up for the first time and show the report to the
user. There is a drop-down in this form that user can select form, so
whenever user change the drop-down, I
change the RecordSelectionFormula and RefreshEx(True) the viewer but I
don't know
why sometime the report doesn't refresh correctly and shows the old
data.

I have this code:

dim rp as new CRAXDRT.Report

rp.RecordSelectionFormula = SQLCondition
rp.DiscardSavedData
if CRViewer.Visible = False then
CRViewer.ViewReport
end if

CRViewer.RefreshEx(True)

Please Advise. Thanks
--Bita

Sponsored Links