Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Running Total Post Reply Post New Topic
<< Prev Page  of 2
Author Message
sp3010
Newbie
Newbie
Avatar

Joined: 24 May 2008
Location: India
Online Status: Offline
Posts: 4
Quote sp3010 Replybullet Posted: 06 Oct 2008 at 11:25pm
Thanks to rptfan & Duward.

I was struggling a lot to achieve this for last so many days. Tried to find out on SE but not found any clear code to perform.

This post has clear code & worked nice for me.


IP IP Logged
Siffan
Newbie
Newbie


Joined: 31 Mar 2009
Location: Sweden
Online Status: Offline
Posts: 2
Quote Siffan Replybullet Posted: 31 Mar 2009 at 5:23am
I'm having a simular issue, i'm retrieving data from several datatables/view bound to an applikation developed in C#. 5 of the tables only contains one row but two of them can contain multiple rows. I have been trying to solve this by adding several detail selections. Most of them are just holdig data that will result in one page is written. And in the other two details i have put a subreport with the following structure

Detail (loop the rows from the datatable and adding them to a shared variable, formula)
page footer (displays the data from the variable) by showing the variable pd from a formula.

I have written the following code to collect the data: 
shared stringvar pd;
If pd = "" then
pd :=  {msvm_ObjectProperties.propertyDescription}
Else
pd :=  pd + ", " + {msvm_ObjectProperties.propertyDescription}

I get the correct data in the first of three report pages. But it seems to keep looping when it should not.

Hiss, Balkong, Seniorboende 55+ the desiered layout  from page1
row1, row2, row3 this data is collected from the three rows.

Hiss, Balkong, Seniorboende 55+, Hiss, Balkong, Seniorboende 55+ the desiered layout  from page2

Hiss, Balkong, Seniorboende 55+, Hiss, Balkong, Seniorboende 55+, Hiss, Balkong, Seniorboende 55+ the desiered layout  from page3

Anyone got a solution?

Siffan
IP IP Logged
<< Prev Page  of 2
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.016 seconds.