Multiple formulas in single textbox problem????

[ausmoran]

I have a report with multiple sections. Some of the sections contain subreports in which I have included multiple string formulas. For some strange reason if I include only one formula in a subreport it work just fine, but if I include more than one, I either don't get ANY data, or I get incorrect data. Is there anyone who might be able to offer some assistance with this?

Here is an example:

against @respondents, the respondent(s), alleging violation of @Articles of the Code of Ethics of the National Association of REALTORS. The decision was as follows:
(Read the decision of the ethics Hearing Panel of the Professonal Standards Committee [Form E-11].)

Here are the formulas:

(@articles)
StringVar List;
List:=List+{tblArticles.ArticleNumber}+", ";

(@respondents)
IF Not {tblCaseLit.Complainant} THEN
StringVar List:= List + {tbl_Litigants.Fname} + " " +
{tbl_Litigants.Lname} + ", " else List;
List;

Thanks in advacne for your assistance!

Austin

 

[dcm]

ausmoran: Try the following:


(@respondents)
Stringvar List:=List+{tblArticles.ArticleNumber}+", ";

IF Not {tblCaseLit.Complainant}
THEN
List:= List + {tbl_Litigants.Fname} + " " +
{tbl_Litigants.Lname} + ", "
ELSE
List:= List

This should give you a concatenated list of articlenumber and fname but you'll nee to watch to see that you don't exceed the max 254 chars in a string or you'll get nothing returned David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner