水晶报表 8.5 分组
我使用 fCity 公式进行分组，如下所示 如果 {X.MailingCity} > ““ 然后 {X.MailingCity} 别的 {X.城市} 我认为有两个不同的字段（家乡城市和邮寄城市）
现在，这些字段包含许多农村社区，在我的报告中，我希望将这些较小的农村社区包含在其附近的主要城市中。 我创建了另一个组（指定订单）并创建了主要城市，并试图将农村城市纳入这些组中。 最后，我将许多社区归为“其他”类别。 它仅从 X.MailingCity 字段中选取农村社区，而不是从 X.City 或我的公式 fCity 中选取。
我刚刚让你困惑了吗？ 如果有人理解我在做什么，请回复。
I am grouping using a formula fCity which goes like this
If {X.MailingCity} > "" Then
{X.MailingCity}
Else
{X.City}
I have two different fields in my view (Home City and Mailing City)
Now, these fields contain many rural communities and in my report I want to have these smaller rural communities included with the major city it is located near. I created another group (Specified Order) and created the major cities and was attempting to include the rural cities into these groups. IN the end I ended up with many of the communities in "OTHER" category. It was only picking up rural communities from the X.MailingCity field and not X.City or from my formula fCity.
Have I just confused you. If there is someone who understands what I am doing please respond.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您需要以某种方式将农村城市和主要城市联系起来，然后您可以按主要城市进行分组（或通过公式，将主要城市返回农村城市）。
You need to relate rural cities and major cities somehow, then you can just group by major cities (or by formula, returning major city for rural one).