Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: cdFormatStringRangeArray Post Reply Post New Topic
Author Message
gracia
Newbie
Newbie


Joined: 09 May 2007
Location: Philippines
Online Status: Offline
Posts: 17
Quote gracia Replybullet Topic: cdFormatStringRangeArray
    Posted: 17 May 2007 at 8:37pm

Hi!

Is it possible to apply this formula  cdFormatStringRangeArray instead of count/sum field in cross tab?
 
I have a report that shows the sum of Telephone Numbers per month and per number of tickets logged.
 
Number of Tickets   Jan      Feb       Mar
 13                          2            2          2
 12                          1            1          1
 11                          1            2          1
Total                        4            5          4
 
but then I need another subreport that shows the details referencing the first report. However if there are multiple Telephone Numbers it only displays the first Telephone Numbers.
 
Number of Tickets   Jan                     Feb               Mar
13                           808123456        808987654   808456789
                              808654321        808456789   808987654
------------------------------------------------------------------------------
12                           808567890        808089675   808123456
------------------------------------------------------------------------------
11                           808567098        808234123   808004567
                                                        808921345  
------------------------------------------------------------------------------    
 
 
 
 
Grace Pujalte
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 18 May 2007 at 12:27am
Unfortunately, I don't think this is possible.
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
gracia
Newbie
Newbie


Joined: 09 May 2007
Location: Philippines
Online Status: Offline
Posts: 17
Quote gracia Replybullet Posted: 18 May 2007 at 12:34am
Hi!
 
Just a follow up question regarding the second sub report that I need to display the TN details, aside from cross tab, what else I can use so I would have this report lay out format?
 
Thanks!
Grace Pujalte
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 18 May 2007 at 12:39am
Not sure. One idea would be to have a main report which lists the left most column by itself. Then add a new detail section which has a subreport that lists the ticket numbers. If possible turn on the Underlay Following Section on the first section so that it lines up better with the subreport. However, I haven't tried the Underlay feature with subreports and I'm not sure if that is allowed. But if so then it might work for you.
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.020 seconds.