Crystal Report 7 Pro with VB 6.0 SP5

I'm trying to build a report in VB6 using CR7, for this specific report I try to have 3 parameters; for example, Items shipped by ProdutcShipper between 2 dates. I have this formula but it displays a syntax error which I can't find.
.SelectionFormula = "{References.Cname}= '" & frmReports.dbcMedium.Text & "'" & " AND {References.rDate}>= " & DTPicker1.Value & " AND {References.rDate}<= " & DTPicker2.Value & ""
Basically I'm asking to retrieve all Entries to a warehouse by a shipper between some date range.
when I run this, it displays :
Run Time error: 20515
Error in Formula: --- the formula above
It displays the name of the shipper and both dates correctly ---
A Date is required here.
What would be my error?
I really appreciate your help.
Thank you.
1

1 Respuesta

503.375 pts. Un Experto no es quien lo sabe todo, Simplemente tiene...
Pedigree report problem: error 20515, Error in File Pedigree.rpt: Error in formula <Record_Selection>. 'Not {NurseryInventory.Archived}.'
Fix: Corrected code.
http://www.procon.uk.com/greencode/pages/greencodeupdates.htm
http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20357523.html#1

Añade tu respuesta

Haz clic para o

Más respuestas relacionadas