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