I am a new programmer. Someone Please help me. This error really disturb me and my position. When i run a report it gives error
c:\Software\Reports\rptMachineWiseReport.rpt Error in Formula <Record_Selection> {View.MachineWiseReport.SerialNo} = j23345454 AND 1=1 A number, currency, Amount, boolean, Date, Time, date-time or strins is required here.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 20 Jan 2011 at 3:18am
it is telling you that in your record selection, that there is an issue, and it telling you the code that is wrong. Since your SerialNo field is a varchar or char field, it has to equal a string, not a number, your code says that it is a number.
{View.MachineWiseReport.SerialNo} = j23345454 AND 1=1 should be
{View.MachineWiseReport.SerialNo} = "j23345454" AND 1=1
at least that is what i would try given the error.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
