Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Need help with formula Post Reply Post New Topic
Author Message
ausmoran
Newbie
Newbie


Joined: 11 Jan 2007
Location: United States
Online Status: Offline
Posts: 4
Quote ausmoran Replybullet Topic: Need help with formula
    Posted: 29 Nov 2007 at 8:02am
I have a simple formula in a CR version 9 report in which I want to arrange the content in sequential order.  Here is the formula:

StringVar LIST;
List:=List+", "+(tblArticles.ArticleNumber);


Note:  The ArticleNumber field is an Text field in which the content is normally something like "Article 1" or "Article 17" etc.  The tblArticles table also has a ArticleID associated with each ArticleNumber.  I would like to be able to sort the articles that are selected in the formula. 

As they show up in the report now, they are in any sort of order (EXAMPLE: Article 17, Article 5, Article 22)  I would like to have them show up in proper order (e.g.: Article 5, Article 17, Article 22).

Here is how the field is used in the report:


...which is a hearing concerning alleged violation of  {@Articles} of the Code of Ethics...

Any help you might offer will be gratefully appreicated.

THANKS,
Austin
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 29 Nov 2007 at 11:25am
A couple ideas. You could use some type of group field and within that group sort by the article number (or article Id if it will still be sequential). Then in the detail section have the formula that you mentioned already. This will build a list of the article numbers. Now, I assume that you don't want a separate row showing up for each article, so suppress the Detail section so it doesn't print. You can put the "...which is a hearing...." with the article list  in the group footer.

Another option is to use Global variables with subreports and use a sorted subreport to bulid the list. Then suppress the subreport but show the article list variable in the main report.
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
downzy
Newbie
Newbie
Avatar

Joined: 14 Sep 2007
Location: United States
Online Status: Offline
Posts: 3
Quote downzy Replybullet Posted: 04 Dec 2007 at 5:21am
Also, you must be careful of your sort because "artical 5" will not sort before "artical 17", is that not true?
Life ain't nuthin but a funny, funny riddle...
J. Denver
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.012 seconds.