Crystal Reports Appending a alue to a parameter

Report Design

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

Topic: Appending a alue to a parameter

Page of 2 Next >>

Author	Message
SATELE01 Newbie Joined: 13 Aug 2012 Location: United States Online Status: Offline Posts: 24	Topic: Appending a alue to a parameter Posted: 27 Sep 2012 at 5:52am
	I have a field in a table that looks like 10981000 the user is only familiar with the last six digits my formula is {Employee_job_History_SCD.Client_ID} = {?Client ID} How to I get the ability to append the digits 10 to a six character entry of 981000 in the parameter
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Sep 2012 at 6:57am
	1. are the user entering the digits by typing it in or are they selecting from a drop dowm (LOV)? 2. is {Employee_job_History_SCD.Client_ID} numeric or text? 3. is {?Client ID} numeric or text? Edited by DBlank - 27 Sep 2012 at 6:57am
	IP Logged

SATELE01 Newbie Joined: 13 Aug 2012 Location: United States Online Status: Offline Posts: 24	Posted: 27 Sep 2012 at 7:04am
	User would be entering a six digit number field is client_id(PK,Int, not null) Parameter is a number
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Sep 2012 at 7:06am
	(10000000 + {?Client ID}) = {Employee_job_History_SCD.Client_ID}
	IP Logged

SATELE01 Newbie Joined: 13 Aug 2012 Location: United States Online Status: Offline Posts: 24	Posted: 27 Sep 2012 at 7:31am
	Tried (10000000 + {?Client ID}) = {Employee_job_History_SCD.Client_ID} Produces no results Am trying to allow the user to enter 981000 and append this with a 10 to get 10981000 that can be used to look up the value 10981000 in table Not having any success Any furthur thoughts would be appreciated
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Sep 2012 at 7:34am
	where are you placing the formula?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Sep 2012 at 7:48am
	you can do a totext process and convert it back to a number but it seems a waste. I would not assume that the fomrula is the issue and try first to just enter the data straight up to test and make sure that part is working. enter 10981000 intot he run time param and in the select statement use {?Client ID} = {Employee_job_History_SCD.Client_ID} Did you get the record you expected?
	IP Logged

SATELE01 Newbie Joined: 13 Aug 2012 Location: United States Online Status: Offline Posts: 24	Posted: 27 Sep 2012 at 7:49am
	The formula is in the Select Expert Formula Editor
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Sep 2012 at 7:52am
	start the trouble shooting (debugging) in the select expert try {Employee_job_History_SCD.Client_ID} = 10981000 Does that work? if not you have a bigger issue try {?Client ID} = {Employee_job_History_SCD.Client_ID} but enter 10981000 as the param. does that work?
	IP Logged

SATELE01 Newbie Joined: 13 Aug 2012 Location: United States Online Status: Offline Posts: 24	Posted: 27 Sep 2012 at 8:09am
	{Employee_job_History_SCD.Client_ID} = 10981000 This produces the records for 10981000 {?Client ID} = {Employee_job_History_SCD.Client_ID} This produces all the results for 10981000
	IP Logged

Page of 2 Next >>

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