Question

Locked

vb and mysql reporting using cristal report

By roha1184 ·
i have a problem here..

i have run my system but t shows error 20515 when i want to preview it..

i'm using this code


With rpt_report
.Connect = "DSN=" + ODBCName + "; UID=" + ODBCUser + ";PWD=" + ODBCPass
.ReportFileName = App.Path & "\Report\reorderinv.rpt"
.SelectionFormula = "{PURCHASE.ORDERNO} =( & Text8.text & ) "
.Destination = 0
.Action = 1
End With
Exit Sub
'errRpt:

help me please

rgds,
vya

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Reporting

by kevin ngobola In reply to vb and mysql reporting us ...

Check on th elink below for a good Flash demo.http://www.fast-report.com/en/products/frnet-flash-demo.html. It can give you a hint as to how to go about it, or check on the crystal reports main web site to find out more.

Collapse -

Um quotes are all messed up

by Tony Hopkinson In reply to vb and mysql reporting us ...

SelectionFormula = "{PURCHASE.ORDERNO} =( & Text8.text & ) "

& is + for strings and strings are expected to be inside single quotes so above should be

SelectionFormula = "{PURCHASE.ORDERNO} =('" & Text8.text & "') "

Can't confirm because I don't use it, oh and I'd be thinking sql injection attack...

Collapse -

Reponse To Answer

by Tony Hopkinson In reply to Um quotes are all messed ...

Well crap. 2007 ?

Sheesh..

Back to Windows Forum
4 total posts (Page 1 of 1)  

Operating Systems Forums