Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Record Selection Formula Post Reply Post New Topic
<< Prev Page  of 2
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Dec 2009 at 12:49pm
Yes that would be an issue.
Just change your paramter to allow for multiple values and drop the use of the comma.
Will be easier for your end users that way too.
IP IP Logged
theotherdodge
Groupie
Groupie


Joined: 17 Nov 2008
Online Status: Offline
Posts: 40
Quote theotherdodge Replybullet Posted: 03 Dec 2009 at 12:50pm
Just a note...  I placed the parameter field on my report to see what it was seeing from the user input.  If I put in "2,3" the parameter field shows 23 on the report.....
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Dec 2009 at 1:01pm
I think that is because it is a numeric parameter and it will ignore an incorrectly placed comma so 2,3 is really 23.
Again, the easiest and IMO best solution is to NOT use a comma seperated input process but rather edit the parameter to allow for multiple values.
 
Select Edit on the param and in the Options box at the bottom of the screen there is a "Allow multiple values". Change that to TRUE.
 
That is how Crystal is designed to to accept multiple values in a parameter so use its features whenever you can.


Edited by DBlank - 03 Dec 2009 at 1:03pm
IP IP Logged
theotherdodge
Groupie
Groupie


Joined: 17 Nov 2008
Online Status: Offline
Posts: 40
Quote theotherdodge Replybullet Posted: 03 Dec 2009 at 1:08pm
Ya I changed that and it seems to work...
 
But......Now, how can I figure out a formula field to display the customer in the heading.
 
Here is what I have:
 
(if {?Company} = 999 then 'All Companies' else
if {?Company} = {z_CustomerRankings.JCCo} then ToText({HQCO.HQCo},0,'')+' - '+{HQCO.Name})
 
That works fine except it multiple companies are selected.  I have no idea how to reference that!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Dec 2009 at 1:22pm
Hmmm, not sure abou that.
Usually a Join() would work but I think it has to be a string and not numeric.
Try a new post on this (specifically state you have an numeric array that can have multiple values with the 999 caveat and how you want it dispalyed in your header) and see if someone can help you with it. I think it needs to be an array which I do not do.
IP IP Logged
theotherdodge
Groupie
Groupie


Joined: 17 Nov 2008
Online Status: Offline
Posts: 40
Quote theotherdodge Replybullet Posted: 03 Dec 2009 at 1:30pm
Thanks for all of your help!  Thumbs%20Up
IP IP Logged
<< Prev Page  of 2
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.016 seconds.