Search results for query: *

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

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

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

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

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