Search results for query: *

Many thanks Borislav, that works a teat.

Hi We have a financial system based on a SQL Server 2005 database and there is a requirement in this system to round numbers down after 2 decimal places. So for example: 2500.627 - would need to be rounded down to 2500.62 However, At the moment, SQL Server rounds this to 2500.63 which is...

Anyone have any ideas on this? Still not got any further with this. Has anyone come accross the same problem?

Hello I have a problem with reporting services, more specifically the scheduling function within Reporting Services. We have been using this function without a problem for about 2 months now to run reports at specified times and then email the report to the recipients with the report included...

Thanks again Craig , that worked a treat mate. Oh and BTW, I apologise for calling you Graig in my earlier post! Risk

Thanks Graig one more question, if I wanted to add a column to the fileexist table to include the actual file name (that was held in a variable), how could that be included in the insert statement? i.e insert into FileExist (Filename, FileExists, FileIsADirectory, ParentDirectoryExists)...

Hello I am using the xp_fileexist command inside a stored proc to check to see if files that are created each night exist in a directory (hence check to see if they where created properly). Is there any way of outputting the result of the xp_fileexist command to a text file or even to a table...

Thanks very much, that problem seems to be sorted now! Thanks again.

Thanks again. I have tried this, on several occasions infact. I have even created new reports but the problem is always the same. Enterprise does not recognize the Data source of the reports based on a Crystal Query, and therefore does not recognize the logon details supplied. Do you have any...

Thanks Can you possibly give me some details on how you managed to do this? i.e. Did you have to re-develop all the reports again? Also, did you have to put a copy of the .qry files on the Enterprise Server? Thanks

Hi I really need some suggestions on this one. We are in the process of updating our Enterprise system from version 8 to version 9. We are currently in the testing phase. We had a number of reports in version 8 that are based on a Crystal Query that we had no problem running. However, I have...

Thanks for all your suggestions. The report that I am running is not based on a stored procedure but a simple query built in Crystal Reports 9.0. Even so, I did try some of your suggestions again to no avail! I think I might have to contact Crystal decisions with this one!

Thanks again I have already changed the timeouts on the input and output servers to no avail. I had a look in the Events Viewer and when I run the report it is creating Warning entries in the Events Viewer for the Crystal WebComponent Server with the following message: 'The maximum amount of...

Thanks I should have mentioned that I have already modified the 'time before an idle job is closed' to the maximum time available on the PageServer and this made no difference at all, the error still occurs.

Hi I was hoping someone would be able to give me some advice on the following problem I am getting when trying to run a report via crystal enterprise. It is not a very big report but it does take over 5 minutes to run. When I run it, after about 5 minutes I get the following error reported and...

If you are using Oracle SQL then you can simply use the Spool command in your query i.e Spool 'c:\mysql\sql1.txt' Select * from my_table Spool off

Thanks Lauryn But is there anyway of doing this automatically?

I am not very familiar with SQL Server SQL but what I am trying to do is the equivalent of the Spool command in Oracle SQL. I wish to write the results of a SQL query in SQL Server 7 to a text file. Can anyone help me this? Thanks