Crystal 2013 add group number to a field

Crystal 2013, this one I'm just drawing blanks on today,

I have a field (customer) it is a number and I need to burst these reports but the software wants to strip out duplicates  because of my grouping.  So if i could add Groupnumber to the customer number that should allow me to burst based on this  generated number..that's my thought.  I tried {customer}+Groupnumber but get a string error so my thought was I've got the syntax wrong or just brain dead today .
Robert BowenIT ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Crystal doesn't strip out duplicates unless you tell it to.  What do you mean it strips out duplicates?

Is the Customer field a number or a string?

If it is a number you don't want to add to it, you would be better off converting it to a string then appending the group number.

Group Number is a number so I suspect the Customer field is really a string.

I don't know why your formula didn't work but try it this way

{CustomerFIeld+ '-'+ CStr(GroupNumber,0,'')

mlmcc
0
Robert BowenIT ManagerAuthor Commented:
Thanks for your reply, actually what I was trying to say was I realize crystal isn't stripping out the dups, however my bursting software does. So I have a formula to pass the customer number for the bursting software to work, in this case I'm using the customer number which normally works fine until this year we have duplicate needs..aka customer has same cust# but two diff locations..so in order to fake the bursting software I was trying to find a way to add a digit to the resulting formula ..just so it keeps the cust# so it can be sorted.

Your formula results in "group specified on a non recurring field".
0
mlmccCommented:
How about this

Put the Customer Number together with the Location ID

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Robert BowenIT ManagerAuthor Commented:
So glad you said what you did...it was right in front of me the whole time, I had forgot when I built the list I added a Key number in the database and was able to use that to create a unique number so it burst just as I needed.   Thanks a lot!   Sometimes just talking to someone about a problem turns the proverbial lights on.
0
mlmccCommented:
Agree.  I can't count the number of times I have sat down to explain the issue to someone and the light comes on as I explain it to them.

glad you got it sorted out

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.