I don't want to get free. Just want to know the information and the feature supported. Thanks.

Did anyone know a third party grid which supports like crystal report multi column properties? For example, a table has 2 cols (Name, Description) with 45 records. Name Description ---- --- 45 rows per 45 records. _________________________________________________________________ And depending on max rows per col (imagine max rows is 15) The grid shows Name Description Name Description Name Description ---- ----------- ---- ------- ---- ------ show 15 rows for 45 records.

Sorry, My Query is SELECT b.[ID] as 'Parent', a.[ID] as 'Role' FROM Roles a INNER JOIN Roles b ON a.[ParentID] = b.[ID] and a.ParentID=1 Some Sample Data is ID ,Name ,ParentID 1 ,Admin ,0 2 ,Manager ,1 3 ,Front Office User ,1 4 ,Supervisor ,2 5 ,Inventory User ,0 6 ,Human Resource User ,4 The above query can only show the first two child of ID 1 (which are 2,3) and did not show the child of parent 2 and 3...etc. How can I get all children?

SELECT * FROM TableName WHERE DateFieldName BETWEEN '1-JAN-07' AND '31-JAN-07'

I have a table Named 'Roles' which contains 'ID' and 'ParentID' fields. Some Sample Data is ID ,Name ,ParentID 1 ,Admin ,0 2 ,Manager ,1 3 ,Front Office User ,1 4 ,Supervisor ,2 5 ,Inventory User ,0 6 ,Human Resource User ,4 I would like to extract data of Parent and all children. SELECT b.[ID] as 'Parent', a.[ID] as 'Role' FROM Roles a INNER JOIN Roles b ON a.ParentID = b.[ID] and a.ParentID=1 which can return only. ID ,ParentID 1 ,2 1 ,3 My wanted form is ParentID ,ID 1 ,2 1 ,3 2 ,4 4 ,6 Like an organization tree, the top parent level can access all lower level nodes. Sql 2005 support that feature. How can I access them in Sql2000 recursive function or store procedure? Thanks May Thu San.

At run time, In crystal viewer, I can export a report as pdf file easily.But I do not want to do it by user. And do not want to use crystal viewer. I would like to make a conversion of a crystal report file to pdf file behind User interface. When a user want to view report, I only want to display the stored data in pdf file.How could I do it in C#? Hopefully, May Thu San

I would like to make a conversion of a crystal report file to pdf (adobe acrobat reader) file. How could I do it in C#? Hopefully, May Thu San

I would like to increase field length of a bound cell more than 50 when using true DBGrid (Component One). I used datawidth propertie of it. But it could not increase the field size.

How could I open an Acrobat document from C# program? I do not want to read and get data in program. Only want to open it from a link.

:)I would like to open a pdf file such as (Data mining.pdf). But I only know how to create a pdf file and not to read it. So please give me some suggestion how I can read a pdf file. May Thu San