Crystal Reports Parameter

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Parameter

Post Reply

Post New Topic

Author	Message
Callie57 Newbie Joined: 02 Jul 2012 Location: United Kingdom Online Status: Offline Posts: 13	Topic: Parameter Posted: 05 Oct 2012 at 12:42am
	Wonder if any one can save me a bit of head scratching! Im setting up a report to search on addresses but I need to add a parameter where the searcher can add just one or two words and bring up all addresses in the database that contain those words. Any ideas welcome, Thanks
	IP Logged


Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 05 Oct 2012 at 12:58am
	HI In Record selection formula you need to give a conditon like : {Table.Addressfield} like "{?Parameter}"
	Thanks, Sastry
	IP Logged

Callie57 Newbie Joined: 02 Jul 2012 Location: United Kingdom Online Status: Offline Posts: 13	Posted: 05 Oct 2012 at 2:48am
	{INCIDENT.CREATION_DATE} = {?Dates} and {V_INCIDENT_ADDRESS.ADDRESS} like "{?Address}" I have entered these in the 'select expert' but its not putting in the address parameter - only the date one? thanks for your help so far though
	IP Logged

Callie57 Newbie Joined: 02 Jul 2012 Location: United Kingdom Online Status: Offline Posts: 13	Posted: 05 Oct 2012 at 3:28am
	I have it working now thanks - just have to ensure the searcher puts the word between 2 (*), however it is taking an age to run the report. Maybe it is too much searching for dates and addresses!! Thanks again!
	IP Logged

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