Print Page | Close Window

Group create.

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=47
Printed Date: 01 May 2024 at 3:08am


Topic: Group create.
Posted By: Imre85
Subject: Group create.
Date 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!


Replies:
Posted By: BrianBischof
Date 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.

http://www.crystalreportsbook.com/Crystal_Reports_XI.asp?Page=3_2 - http://www.crystalreportsbook.com/Crystal_Reports_XI.asp?Page=3_2


Posted By: Imre85
Date Posted: 13 Dec 2006 at 1:37am
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:
 
int i;
for (i=6;i=0;i--)
{
string.substring(i);
}
 
How is this in sql?
Thanks!


Print Page | Close Window