Search results for query: *

Hello All, I am running a report that takes in 2 date parameters. Start date and End date. However when I run the report for today no data is returned (even though the data exists). When I run the sql directly there is no problem.. I noticed that there was a statement in the criteria parameter...

Hi, I am experiencing a problem where an SQL transaction does not committ when the updates in the procedure times out. BEGIN TRANSACTION UPDATE WHATEVER SELECT WHATEVER UPDATE WHATEVER COMMIT TRANSACTION The knock on effect of this is that locks are held open for table WHATEVER...

Does Anyone know how to automate the export of a Crystal report to an excel file. E.g when the file is run it automatically exports the data to a file Thanks in advance

Problem: I am trying to count up the values in a column in a table. in Word and automatically display the result in another field Desired Process: Enter the hours worked in each row of the hours column. when the hours are entered the total should be displayed a another field underneath. I...

Hi, I am stuck. I have created a stored procedure on SQL Server which accepts one parameter. I have then setup a Crystal report which reports from this Stored Procedure. In Visual basic, i want to Call this Crystal report and pass it the parameter it needs to return data. The following...

All, When i run the setup of my project that was made using the Package and Deployment Wizard i get the Following error. An error occurred while registering the file "MSADO21.TLB" The program then does not work correctly. I use the Data Designer on a SQL database (ADO) Basically...

Hello All, I am having trouble writing to a text file, i have managed to replace all the quotes and commas with "". But i cannot get rid of the Leading and ending quotes. E.g "Line55234123412" )- this is what i get Line55234123412 :- this is what i want thanks in advance...

Hi all,<br><br>I am trying to remove spaces in a text file, using FSO<br><br>Does anyone know how i can do this.<br><br>The following is the logic that i need to use<br><br><br><br>Sub StripSpaces()<br><br>Dim fs As FileSystemObject<br>Dim ans As String<br><br><br>Set fs =...

Below is the code i use. I need to log on to an FTP site(No problem) change directory ( Returns an error - Still executing last request)<br>And download all text files then archive them to a directory.<br><br>It seems as though the program crashes when i try to change directory.<br><br>Am i...

Hi All,<br><br>I need to import a text file into an access database.<br>My problem is i need to parse the file into different fields.<br>can anyone help<br><br>Thanks <br>

Hi All<br><br>What i need to do is find out the difference between two dates in days. One date is a text field and the other is the current date.<br><br>Can this be done in Crystal, and if so can you calculate the difference&nbsp;&nbsp;minus the weekends.<br><br>Thanks in advance<br><br>

Hello All<br><br>I am running a report that queries a text field. the Text field looks like this : 0000000002000 Is there any way i can run a report that will remove the last 3 zero's <br><br>I tried the right(,3) function but to no Avail. <br><br>Thanks for your help&nbsp;&nbsp;<br>