Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: DETAIL SECTION DATA NOT IN SAME ROW Post Reply Post New Topic
Author Message
niha
Newbie
Newbie
Avatar

Joined: 05 Jun 2015
Online Status: Offline
Posts: 28
Quote niha Replybullet Topic: DETAIL SECTION DATA NOT IN SAME ROW
     Posted: 11 Jun 2015 at 7:56pm
My requirment is in detail section i have following data :
->details of packegs,size,rate,cost,no.ofpacakges

1)size,rate,cost,no.of packges comes in same row but 2)details of pacakges comes in diffrent row.
for this what i should do ?


Edited by niha - 23 Jun 2015 at 11:33pm
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 12 Jun 2015 at 4:19am
What I hear you saying is that you need to get the package details and display them on one line even though they may come from multiple data records. Is that correct?

If so, and assuming that the package details are a string data type, here's what you'll need to do:
1. Group by some sort of identifier for the package.
2. Create a formula to initialize a variable. You'll put this in the package group header:

StringVar pkgDetails := '';

3. Create a formula that will add the data to the variable. Put this formula in the Details section:

StringVar pkgDetails;
if pkgDetails = '' then
pkgDetails := {table.pkgDetail Field}
else
pkgDetails := pkgDetails + ' ' + {table.pkgDetail Field};

4. Create a third formula to display the package details. This will go in the package group footer along with the other data that you want to display:

StringVar pkgDetails

5. Suppress the package group header and the details sections. The formulas should still run and you'll get the info you need.

-Dell
IP IP Logged
niha
Newbie
Newbie
Avatar

Joined: 05 Jun 2015
Online Status: Offline
Posts: 28
Quote niha Replybullet Posted: 14 Jun 2015 at 8:56pm
Thank you hilfy

But my problem is pacakge detail data is 7-8 lines and other data like size is one line.

And if i use underlay following section option checked, it work properly.

Edited by niha - 23 Jun 2015 at 11:30pm
IP IP Logged
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