| Author |
Message |
ausmoran
Newbie
Joined: 11 Jan 2007
Location: United States
Online Status: Offline
Posts: 4
|

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 Logged |
|
|
|
BrianBischof
Admin Group
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
|

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 Logged |
|
downzy
Newbie
Joined: 14 Sep 2007
Location: United States
Online Status: Offline
Posts: 3
|

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 Logged |
|
|
|