Recent content by pamplemousse

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