Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create Parameter based on extracting protion of field

Status
Not open for further replies.
GCL2007

GCL2007

IS-IT--Management
Dec 11, 2007
167
0
0
US
I am trying to create a parameter based on the second and third digits of what is typically a 6 digit text field. How would I extract that to create a Dynamic Parameter in CRXI?
Thanks
 
Sort by date Sort by votes
You would create a command where you added a substring of the text field in the Select statement. Then reference this is in the dynamic parameter setup. The syntax/function depends upon your database and connectivity.

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
184
hilfy
hilfy
CrystalUser90
  • Locked
  • Question
Same field on two tables, merge into one field on report 1
Replies
2
Views
145
CrystalUser90
CrystalUser90
sal21
  • Locked
  • Question
create report without database in vb 6.0 and recordset
Replies
0
Views
173
sal21
sal21
Gary Hnat
  • Locked
  • Question
Crystal SQL Code linking to partial database field entries
Replies
2
Views
153
Gary Hnat
Gary Hnat
lm1340
  • Locked
  • Question
How to only get records that have data in at least one of many tables 1
Replies
2
Views
149
lm1340
lm1340

Part and Inventory Search

Sponsor

Back
Top