Topic: Group create. Posted: 12 Dec 2006 at 7:08am
Hi All!
I make a crystal report, and i don't know, how can i make a group. So this is my task: An item contains two parts: 1 source location, 2 item code. The codes for the source location are 1 to 6 digits. Theese codes are fixed in a table with their comments. The items(source location+ item code) fixed in another table. I'd like to get the things group by the comments of the source location. How can i do this? Thanks!
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 12 Dec 2006 at 8:39am
You need to use both tables in your report as your data source. And then link the two tables together by their common field. I presume that this common field is the Item Code. After doing that, you can easily create a new group and specify the Comment field as the grouping field. Check out Chapter three of my XI book online for all the details.
Thank you for the link! I created a c# code, what to solve my problem. But i would like to use in sql. Can you help me in the sql? The code is the next:
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
