Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Command "Like" Post Reply Post New Topic
<< Prev  Page  of 2
Author Message
Robotacha
Groupie
Groupie
Avatar

Joined: 11 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 97
Quote Robotacha Replybullet Posted: 14 Jul 2011 at 5:21am
I have tried to find a solution like this myself a while ago for a report.
 
We had no way of identifying HOLD invoices on the system. say a customer didnt want his order delivered next day, and wanted it in a weeks time, our delivery run numbers are not day specific..
1 run number for every day.
 
So my solution was, in the delivery instructions, the person who raises the order, must put "PLEASE RELEASE - dd/mm/yyyy"
 
I then created a daily report to show ALL invoices where this formula was TRUE
 
IF {DELIVERY.INSTRUCT1} = "Please Release - (currentdate)" THEN TRUE ELSE
IF {DELIVERY.INSTRUCT1} = "RELEASE - (Currentdate) THEN TRUE ELSE
 
etc etc
 
This failed as people were not following the format requested, and were typing things like  " REL - Monday 14th " etc.....
 
 
I tried for ages to find a formula using LIKE where it would work, but was unsuccessful.
 
I gave up in the end.!!
 
lol
Regards,

Michael Jones
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 14 Jul 2011 at 6:56am
try this (searching my old reports)
'{?Country}' put the string around it and the % shouldnt be part of the parameter name
'%{?Country}%'
sharona
IP IP Logged
sa-user
Groupie
Groupie


Joined: 29 Jun 2011
Online Status: Offline
Posts: 65
Quote sa-user Replybullet Posted: 14 Jul 2011 at 6:57am
Which one
'{?Country}'
 
or
 
'%{?Country}%'
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 14 Jul 2011 at 9:30am
for select parms, I use '*'+{?Country}+'*'
IP IP Logged
sa-user
Groupie
Groupie


Joined: 29 Jun 2011
Online Status: Offline
Posts: 65
Quote sa-user Replybullet Posted: 14 Jul 2011 at 9:38am
This isnt working.
I also tried '%'+{?Country}+'%'   ... no luck
IP IP Logged
sreenu435
Newbie
Newbie


Joined: 15 Jul 2011
Online Status: Offline
Posts: 10
Quote sreenu435 Replybullet Posted: 15 Jul 2011 at 12:15am

Hi create the parameter with the country if you have the database access write small procedure parameters as country call that procedure in crystal ..i thinks with this your problem might be solved
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 15 Jul 2011 at 5:03am
'%{?Country}%'
why dont you give up on the command parameter and just create one in the report and the record selection.
sharona
IP IP Logged
<< Prev  Page  of 2
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.