Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Formating Column Values in row seperated by comma Post Reply Post New Topic
Author Message
mhamidch
Newbie
Newbie


Joined: 27 Jun 2007
Location: Australia
Online Status: Offline
Posts: 2
Quote mhamidch Replybullet Topic: Formating Column Values in row seperated by comma
    Posted: 27 Jun 2007 at 7:22am

Hi all,

I am having trouble in formating my subreport which have only three fields to show.

 1. Date          2. Invoice Number     3. Payment

My Current sub-report prints invoice numbers and date against each payment like as follows: 

Date:               Invoice             Payment
16/02/2007      1245            $2585.00  <--| one payment made
16/02/2007       2154           $2585.00 <--| repeating
18/02/2007        857            100.00 
02/01/2007        449            $124.00 <--| one payment made
02/01/2007        694            $124.00<--| repeating
and so on......... Instead of that format i want to use

 The case is that i want to print Invoice numbers in a row seperated by commas the following way:

 Requirement

 Date:                 Invoices                              Payment

16/02/2007     Invoice Numbers: 1245,2154      $2585.00

18/02/2007           Invoice Numberrs:857          $100.00

02/1/2007            Invoice Numbers: 449,           $124.00

can anybody please help me in this regard.

Hamidch



Edited by mhamidch - 27 Jun 2007 at 7:28am
mhc
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 27 Jun 2007 at 8:51am
The only way to do this is to use a subreport and a shared variable. In the subreport it dynamically builds a list of invoices on each day and concatenates them into an array of strings. Then in the main report you can reference this array and print the string for each day. However, this requires a very in-depth knowledge of writing formulas and working with arrays. If you're familiar with it then you would be okay, otherwise you'll need someone very experienced to help you write it.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
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.047 seconds.