Crystal Reports Help me

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Help me

Author	Message
chmsohail Newbie Joined: 19 Jan 2011 Location: Pakistan Online Status: Offline Posts: 2	Topic: Help me Posted: 19 Jan 2011 at 9:17pm
	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. Please help me
	Help the begnners
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	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. HTH
	IP Logged

chmsohail Newbie Joined: 19 Jan 2011 Location: Pakistan Online Status: Offline Posts: 2	Posted: 20 Jan 2011 at 6:03am
	Thanks for your response. Definitely the problem is like this. I will check it in the morning office time and the response you in return.
	Help the begnners
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

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

This page was generated in 0.031 seconds.