Recent content by chinnijahn

Hi The above solution actually worked however I had table adapter instead of a datatable. so I have used Getdata method of the table adapter to get the data table. The code looks like this Dim colnames() As String = {"Order"} Dim tdistinctRows As DataTable = TestTableAdapter.GetData(JobNo...

I am using vb 2005 and dotnet version 2.0 Hi I have a data table called Details. I have created a binding source called bsr_details Details have field names like plant , options.. i want to get the disticnt values of all options.. if i have to write it in sql then i could have write "select...

I had to stop working on this program as something else came up which we have to give priority so i was unable to cheeck ...I will post if the solution worked or not asap.. thanks a lot guys

I will try this and let you know how it worked out..Thanks a lot LB.

Hi I am using crystal reports XI. I need a formual which would convert the decimal to fraction. like 0.5 it should give 1/2 0.625 it should give 5/8. Thanks in advance.

ok..I am showing results in a tabular format. In details section I get the values from the database table Products. In report section it is a blank comment table format which after taking printout user can write comments on its own..so it is just an empty table format..I am not using any...

PAGE STARTS productname PRdouctCode ProductCost 1 abc 87 2 xcv 99 3 ssx 76 4 swx 90 Date Comments --------------- --------------- --------------- page ends suppose if the proudct table has more...

I apologize for limited information. well here it goes..I dont have the cross tabs. I am using manual tables. I have two tables first table gives the details of all the products from the database and i have it in my details section which is working fine In report footer I have a comments...

I am using crysal report XI and Vb.net. I have a report which consists of two tables I want the second table to extend to the bottom of the page dynamically. HOw can I do that. Thanks in advance