Search results for query: *

Horray!!!... Figured it out :) I put the data into the main body of the report, and created a public code function like this: Public Function SumEarlyValue(ByVal headEarly As Double, ByVal headTotalJobs As Double) As Double If headTotalJobs <> 0 Then Return headEarly / headTotalJobs...

Hi All I have a crystal report that I need to port into SQL Reporting Servicves. Unfortunately there is a lot of summing and report item summing going on in the report and I am unsure how to do this in reporting services due to not being able to Sum to 2 ReportItems in the header/footer of the...

Cool... thank you very much for the help. I thought that may have been the case for the TextFieldParser :)... I have used some looping etc and managed to get something sorted... Not sure how efficient the code is, but there should not be too much data in the file so i dont think performance...

Cool... never knew that existed lol So when I read the data out of the datatable i need to read it into a TextFieldParser and then into a new csv file... I'm not exactly sure how to achieve this. I have been able to use the TextFieldParser to get the data from the text file into the datatable...

Ok I have got the inserting into the datatable working and the sort working, I now need to write to sorted data back out to a new csv file. The problem now is that each column data in the dataview now has speackmarks around each item... i.e. initial data looks like this 1235,00001,23...

Awesome thanks guys... I think the datatable is probably going to be the easiest way for me to handle this as I will be able to determine the correct column to sort by and then just sort it. I have a collection of the column set up details the data structure in a kind of config table that i am...

Hi there I have a CSV file that i want to sort by the second column of data... i.e. COLUMN 1,COLUMN 2,COLUMN 3,COLUMN 4 1234,54689,55489,The fox 5554,4568,59823,Brush 0578,XYZ,PQRS,12364 I want to be able to write a function that can sort on any one of these columns depending on the index i...