Search results for query: *

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...

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 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 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...

We have several databases in notes wich use @Created date to show the date. The problem is the date seems to be taken off the users PC. Another problem if the user changes the date to a date Greater than the current date notes will use that even if they change it back(Unless they close and...

I have a crystal 8 report wich runs fine in the crystal designer. but when i try to view it in the activex web viewer it gives me an Enacapsulating Page Failed error. <ReportName> On page server <Server Name>. It generates the first page to view fine but not the group tree and the evntually...

I have recently upgraded my crystal server to version 8. since then i have .tmp files apearing in the c:\winnt directory. these are fulling up my c: drive. I have checked crystal Reports web component server and cannot find any mapping to c:\winnt. the cache is set to another directory with a...

I have recently upgraded my crystal server to version 8. since then i have .tmp files apearing in the c:\winnt directory. these are fulling up my c: drive. I have checked crystal Reports web component server and cannot find any mapping to c:\winnt. the cache is set to another directory with a...

I have a visual basic app with several crystal reports (version 7). it connects to a sql server and displays a report. it works fine on a windows 95 machine. i have installed it on a windows 2000 workstaion machine. the program works fine except when you try to print a rport. it looks loike the...

I have some admin procedures wich are scheduled to run. i would like to log the results of each procedure to a text file. Can anyone tell me hoe to do this.

I am trying to write a stored procedure where i select a bacode field from a table then convert the barcode to numeric (from Varchar).if i get an error in converting it is because their was an error when scanned(non nUmeric Characters) or it wasnot sacanned and i want to output the record id to...

We have a site (A) publishing a databse and two sites (B) and (C) subscribing to it. all sites are in different domains. when we setup replication and do an automatic Sync, site B sync's and the owner of the tables on site B is DBO, but when site A sync's the owner of the tables is...

in vb i make an rdo connection i specify to use a server side cursor. this program has been working fo ages. However we have just had our SQL 6.5 servers hardware upgraded and sql re-installed. when i run now with a server side on a query a resultset with two rows never hits eof. therfore it...

i have a result set containing 'printdate'. in the list where clause i want to exclude all the records that were printed on a friday. can anyone tell me what to add to my where Clause.

I have designed a report which i want to print in landscape orientation on any machine that wants to print the report. I have founf that i get varying results on different printers. Crystal solution is that you should have the default printer selected that way it will use the machines default...

i have a few reports in crystal 7 that connect to sql 6.5 to produce a report.thay are called from a vb application. the problem i am having is sometimes when asked to print they print blank reports. the way i resolve it is i open the report in the designer and the resave it, it then will print...

I have a combo box which contains serial numbers. the problem is that the amount of data in it now exceeds the 64k field limit size. can anyone suggest a better way to select the serial numbers (Keywords) when the size of the list is greater than 64k.

When trying to link to paradox 5.0 tables from access using the paradox driver getting an error &quot;External table not the Expected format&quot; if we try to use an odbc get the error &quot;you cannot use odbc to link an external microsoft jet or isam database table to your table.&quot; Can...