Recent content by gdkz

Thanks again for the responses. I had considered the an array. I am going to have to find a way to mark the first instance in the record set, so as I can use that field to suppress the subsequent fields. Thanks for the help!!! PS: Looking forward to upgrading. Thanks, Greg

Yes, 8.5, thanks for the reply. I am not using an ODBC data source, but an Active Data defintion file (ttx). My record source is an XML file. Thanks, Greg

I have a report that groups records first by room number, then by student name and must stay in this order. A student may appear in multiple rooms and I would like to show each student only once in the entire report regardless of how many rooms they appear in. Example: Room 1 Student 1...

Thanks, resolved the issue. Works great, just like you suggested! Thanks, Greg

Thanks, I see what you are saying. However, no matter what I seem to do, it is generating 'the summary / running total field could not be created." error. I am using ttx files to read xml data from the print engine. The field is a date/time field and I have experimented with datevar and...

(Crystal 8.5)On the first and last record of a group, I want to set a variable equal to a value within that record. I need to do this for every grouping. So I initialize the variable in the report header whileprintingrecords ; shared datetimevar start_date:= cdatetime("01/01/2006 10:10:00...

I am trying to create a short cut to a batch file from within a batch file. I have experimented with the following code, but been unable to link to the batch file. del "c:\link.url" echo [DEFAULT] >> "c:\link.url" echo BASEURL= >> "c:\link.url" echo [InternetShortcut] >> "c:\link.url" echo...

We have a symbol ls2208 hand held barcode reader connected to our PC via a Synapse wedge. The scanner will scan correctly for numerous times, then receive 4 beeps. The documentation says this is due to a communication error and needs to be programmed. We have checked all the options, and this...

You might try http://www.boingo.com/hso/hsiab/ Thanks, Greg

Yes thanks, conn object was cut during pasting. We are using SQL 7 and no linked server. Thanks, Greg

I am using an ASP page to read records from a text file and make multiple entries into a SQL database. I wish this to be an all or nothing entry, if one fails then all the entries will rollback. This seems to work with under 10 records, but fails after that point with the following error...

Thanks, solved. Was reading from a text file into the data set. Did not take into consideration that the first row should contain headers and I was not supplying this. Thanks again for the tips. Thanks, Greg

Thanks, solved. Was reading from a text file into the data set. Did not take into consideration that the first row should contain headers and I was not supplying this. Thanks again for the tips. Thanks, Greg

Thanks for the help on the connection. I have tried looping through dataset, but I am still dropping the very first record. When I display the dataset in a datagrid it shows all records. myDataTable.Rows.Count results is minus the first record when I check this value. I dont understand why I...

My problem is I am dropping the first record in my Dataset when writing to the DB. Dim MyDataSet As New DataSet MyDataAdaptor.Fill(MyDataSet) Dim MyDataRow As DataRow Dim strSQL As String = "" Dim sqlConnection As SqlClient.SqlConnection Dim sqlCommand As SqlClient.SqlCommand Dim sqlCommand2 As...