Crystal Reports question

Hi all,

My question is how do you concatenate a repeating field from a Details section into one field in a Group Footer section?

Detail Section: this is what I have

Lots
------
5
32
53
75
88


Group Footer: This is what I want to add

All Lots
--------
5 32 53 75 88


Thanks for any help,

Magoo
LVL 1
magoo2Asked:
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.

yjtCommented:
Hi!

First, you create a formula, eg named: ConCat
which contains the following code:


WhilePrintingRecords;
StringVar A;

A := A + " " + Totext({tblProd.Prod_InsPeriod});
if OnLastRecord then
  A;


where tblProd.Prod_InsPeriod refers to the Lots field in your case.

Place the formula in the group footer.


It worked fine in my case. And I would appreciate if more points could be given as I spend quite some time on your question :-)
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
magoo2Author Commented:
yjt

 Thanks lots! One change so it would print for every group and it works perfect. Excellent!

Magoo
0
magoo2Author Commented:
yjt

I increased the points to 150, but cant tell if it gave them to you or not. Let me know if it didnt, and I will post another for you to get them.

Thanks again :)
Magoo
0
yjtCommented:
Thanks in advance magoo2, one question


The grade point for A is multiply the question's point by 4 isn't it? coz I've only received 200 points and I think I didn't get your adjusted points... TQ
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
Visual Basic Classic

From novice to tech pro — start learning today.