Search results for query: *

Is it possible to define a minimum number of hours per week for an indvidual and display an error message if the total numbers of hours for all tasks is less than that figure when submitting a timesheet via Project Web Access?

Hi, I have a problem where records are duplicating when printing. The records are not duplicating when viewed on screen, but when printed records are appearing on the bottom of one page and the top of the next. I'm using Crystal 8.5

Hi, Select @@max_precision returns the precision level used by decimal and numeric data types as currently set in the server. However I can't find in BOL how you change this from the default 38! It points to configuration options which in turn points back to @@max_precision. I'm going round...

Ro, Many thanks for all your help, finanlly cracked it! Like you I do most of work with MS SQL and hence always have problems when I have to do work for one of Oracle Customers. The function was returning a VARCHAR2 datatype, which basically was screwing things up. In the end I resorted to...

Ro, I'm still having the same problem. I've changed the Oracle ODBC driver to 8.01.07.810, which also has the enable results sets setting. When trying to use the function in a SQL expression field I still get the error, but I can use the function if I type it in in the where clause. Troyboy

Ro, I am using Crystal 8.5 and I have tried native database driver, Oracle ODBC, Microsoft ODBC for Oracle and the CROracle8 v3.6 as you suggest. I haven't tried the advanced tab yet so thats next to try. My only problem is that unless I'm mistaken you can't distribute the CROracle8 v3.6 driver...

I have read all the posts on using an Oracle Function within the SQL Expression editor and still I get an error. I am using Crystal 8.5 and a Oracle 8 database I have tried using both Oracle ODBC and native Oracle drivers (P2SORA7.dll) I am using the following syntax...

I have written a report for SQL Server that is based on a stored procedure. Within the Stored procedure there is a call to another procedure which uses the OpenQuery syntax to read data from an Oracle database. The SP runs fine in query Analyser and also works fine within the Crystal...

Has anybody know how to set up the D-Link504 to support a VPN using Checkpoint Secure Remote? I have spoken to D-Links tech support who got me to upgrade the firmwear, but I can't see where I set VPN passthrough. The product documentation on various sites says that the device supports this but...

We have a customer who is running on an Alpha NT platform. All our reports are written in Crystal and use the RDC to run and display. Does anybody know what versions of Crystal Reports are supported on the Alpha NT Platform?

You can use the same idea, but of course you can not use the parameter as a filter in the main report. WHat you could also do is create the parameters in the main report and use them in the linking of the subreport. When doing this you should scroll down to the parameter name in the subreport...

Bobiman, THe only way I know how to do this is to use shared variables. In the main report create a formula field as: shared stringvar test1:=''; You can use different declarations for different variable types. In the subreport create a formula field as: shared stringvar test1:= value where...

Does anybody know whether it is possible to run Crystal Reports under NT4 installed on a machine based on the Alpha chip?

Sam, I am presuming you are defining a new Formula field with the formula attached. If not that is what I suggest you do and then use the formula field as your group.

Krist, I suggest that you install the relevant HP driver on your system. Then change the report printer to the HP and make sure it looks ok. I had a similar problem with labels and a label printer and this was the only way I could work around it.

Keith, there is a knowledge base article on the Crystal Decisions site entitled Oracle stored procedures and crystal reports. There is a table that suggests that you should use the native oracle driver (p2sora.dll) for the interface to work with Oracle 7.x. I used this method rather than the...

Keith, The attached do work, honest. It took a few days of slog but I needed to do a similar thing. The procedure is not a seperate stored procedure but a procedure within the stored procedure. I don't understand either, I much prefer SQL Server. The only other thing to check is that you are...

Ok, how about putting the insert within a procedure. procedure insert_rec_urg IS begin for i in 1..4 loop insert into .... end loop end insert_rec_urg; Another alternative is to use the following format...

Try doing the insert in a seperate cursor to the one being referenced by Crystal. The stored procedure can contain more than one cursor.

If you are using the RDC to open and run the report. Once you have opened the report you should loop around the parameters in the report and set the values as appropriate. For example: For Each ParameterField In report.ParameterFields ' With ParameterField '...