Recent content by MikeTom

I have a crystal report external ot in a dsr (tried both methods) with subreports launched from VB6. I can get the report to launch fine from the server it has been setup on. But when i programtically change the server to use it will not run. The database tables,views,stored procedure for the...

Hi iam Looking at a book wich on crystal 9. Now most books seem to cover reports design, but i am looking for a complete reference that looks at Setup and Maintaining Crystal Enterprise as well. Any of you read any good books that you could recommend. I t would be great if you could post isbn as...

We do have a physical policy, but their are alot of casual staff as well who use these machines.So hence we want to display a message saying that they are being monitored. this will act as a detterant, as managment really dont want to discipline staff only if they have to.

I want to put a disclaimer telling users basically that misuse of the internet may result in disciplinary action before they enter the explorer. Any suggestions on how to do this?

I have an import DTS routine in visual basic that imports data from andn excel file to sql. How can i check if the file exists in the directory before i run the routine. Thanks in advance.

I have read these articles and have a copy of CR9 Advanced to evaluate. The reason i posted this question is because i have spoken to crystal sales and support staff and have got conflicting information, and i would like to know how people who are actually using CR9 are coping. Whith crystal...

I have been using crystal reports since version 6. Since ver 7 all our reports have mainly been web based, wich is now seems to be quite costly with ver 8.5 as we can only have 5 users and have to pay a ridiculous amount of money for more liscenses. Also a lot of users have complained about the...

I think as handy as it is tryting to change the timeout lock trying to set it for 5 users or additional if you buy more liscenses does not make a robust reporting system for the money you pay for crystal. I really think their License locking mechanism is poor and costs a lot to buy additional...

I have the same problem and have been looking at solutions. What i have found out so far is that 8.5 has a technical lock of 5 users (more can be purchased at a crazy price), the lock occurs when the user requests a report and remains for 20 minuets. This bascally means in a space of 20 minuets...

I have been using crystal reports since version 6. Since ver 7 all our reports have mainly been web based, wich is now seems to be quite costly with ver 8.5 as we can only have 5 users and have to pay a ridiculous amount of money for more liscenses. Also a lot of users have complained about the...

The @Created date on all new forms that are created are picked up from the date and time Setting on the PC they were created. My Question is, Is it Possible to get the @Created date, on all new forms, from the Notes server rather than the local PC? The Reason i want to do this is some users keep...

The views that show the documents definetly use the @Createddate. Their is no formula for @created date it is part of each form. the problem we having is if the user changes his pc date to a date greater than the current notes will use that date for @created date even if the date is then put...

if IsNull({tblPrimDls.PDLine}) then "NA" else TOText({tblPrimDls.PDLine})

it works okay.

If you use a SQL stored procedure, try creating a temporary table isnsert all current Years into the table and then update last years figure i.e Create table #Results(c.no int, Customer varchar(50), Current y. int, Last y. int...