Crystal Report to PDF with Selection

[brucevde]

The only reason I can think of as to why this occurs is that the Save Data with Report option was selected. This means when there is no RecordSelection formula, the report does not need to connect to the database but once you add the formula it is trying to refresh the data.

Try this to see if the above is the cause.

Comment out the RecordSelectionFormula
After the OpenReport statement add
Rep.DiscardSavedChanges (not sure if that is the exact name of the method name)

If you get the same error then you need to ensure a login has been set for all databases used by the report.

[mehtarohit]

Thanks for ur reply brucevde

Since my database is password protected, it gives me that error. If I remove the password from the database then RecordSelectionFormula works fine.

Also I am using FormulaFields in the report...

rep.FormulaFields(0)="VillageName='" & village_name & "'"

BUT I am gettig this error...."Subscript out of Range"

Any ideas as to why this error is comming.

I tried writing it as

rep.FormulaFields.Add "{VillageName}",village_name

but of no help. It dose not give me an error, but does not show the output on the report.

pls reply....

[mehtarohit]

Any help.....pls