Search results for query: *

Thanks Rhys, You are correct my example would not work without the quote. It' a transcription error. In your second reply you ask if it's going to be an infinite number. Yes it is :0( But Maybe you can help me with something. Why is it that when I test a function: CREATE FUNCTION...

Hi all, I need to create a stored procedure that will return a result set based on criterias that are provided by the application we use. So far what we have is a store procedure that generate an sql statement dynamicaly. But I don't like this approche. CREATE PROCEDURE sp_myProc ( inClause1...

Is it possible to launch a .rpt file from a NT command line. I have a large number of reports to run and I wish to do a "batch job". If you have any other idea beside using crystal entreprise. Any ideas are welcome... thanks in advance

can u send me your email adress Pamplemousse56@hotmail.com

Is this what you've done or trying to do: Group Header (suppress) Detail (suppres): your_field Group Footer: Insert_a_running_total

Have you tried suppressing the unnecessary (header,footer,etc) section from format section tab on your Subreport ?

Hi!!! I have CR v7 (7.0.100.15) connecting to Oracle7 DB I installed the sr867_7011b_setup that is supposed to fix a shared variable bug. Since then, all the reports that I created ( and only the one that uses shared variable ) are returning a "virtual call error" at runtime. I...

Duh!!! I just forgot to put no printer in printer set up Vacation time must be near...

I don't understand this one. In distributed reports, I get Could not find printer when I try printing the reports, when ran on a different PC. Am I forgetting a switch some where (I put the .CRF files with read only options to keep window options, but I guess this is not the problem ) Thanks

Hi is there a way to have login prompt at runtime for the subreport. I'm using a main report with subreports. If I create this report pointing to domain "A". Let's say at runtime the user want's to point to domain "B" he gets error. I found out that at runtime I can change...

In File/Options/Fields/Number set your decimal place

Hi all! I'm trying to create a distributed reports and I keep failing. I'm using CR versions 7.0 Fact: I created some report linked to Query witch were created with SQL Designer ( using CR07 ODBC ). When I run them on my PC everything is OK ( query refires and I get the data to the .rpt )...

Thanks Malcolm! I'll be reading that paper... French accent will open a lot of doors... Keep practicing ;O)

I'm using Oracle 7 (Oracle Clinical 3.1.1) I know how SP works but when it comes to use them in CR I,m a bit confused. Here a few question I'm asking my self:Where do I call them? Can I pass any parameters? Do's and Don'ts. MalcolmW did you take some french class ( nice translation :o) ) I...

Hi All! This group took me from being in total darkness regarding CR to an acceptable level (thank's Ken ;-) ). I'm now confortable with regular stuff. But there's a monster that I've been avoiding and he's called Stored Procedures. I've been looking at Seagate site for a while and could not...

Hi Again! I wrote a few report using CR SQL Designer witch are link to CR Designer. When I run them on my computer or any computer witch have CR installed, everything work fine. The problem is that when I want to distribute these report using the Report Distribution Expert I get an error that...

Hi All! I created some report based on querry witch I created with the SQL Designer. They run fine when I run them. But when the users (witch only have CR viewer) try to run them they get an error that tells them « Could not find the database ». If they run report only created trough CR report...

Hi everyone! When I moved my .qry file that I build from SQL designer, It seems like my report lost the location of the file. My_report.rpt tells me that the dictionairy has change. I tried opening it discarding this message to try to set the location thru Report Designer but I cannot switch the...

I would like to know why the querries I create in SQL Querry designer are not refired when I link them to a report. I dont`t whant the users to run the querries and then run the report. I'm using SQL Querry Designer because I have a lot of allready made SQL scripts that I reuse to create my...