Search results for query: *

Yes the report connects via ODBC....but do you have a way of refresh the report automatically when it is called ?? like an extra parameter ...cause i can launch the .rpt via a run command but the report is not in preview mode so I want to make that automatic. Thanx!

CR 8 and VFP 6 have a look at the code : Declare RegOpenKey in ADVAPI32.DLL INTEGER, STRING, INTEGER @ID_Cle &&verify if crystal is installed =RegOpenKey(2147483650,"Software\Seagate",@ID_Cle) if ID_Cle # 0 *! /N start c:\windows\desktop\crystal\requetes\nouveau_rapport_req.rpt...

The table is local and when i call the report with the run command, all I have to do is press Refresh (F5) so the access to the data source is OK. I also tought about sending F5 key to crystal to refresh it...will that work ?? If you want to see the code I use, tell me and I will e-mail or post...

Hi ! I have a report that is already created and of course, a table. The table that holds the data is filled with a .prg and I want to call crystal to preview the report at the end of this .prg. I've tried by creating an OCX but I always get and OLE error (I use a sample code found on the web)...

Ok thanx Malcolm...your help is appreciated....as I tought ... I already knew about the top N but I'm gonna explore the derived table...

What do you mean by derived table and subselect ?? derived table --> Another instance of an already open table? subselect ------> A select within another select : select ??? from ?? where in sleect ??? is that it ??

Do you think that including the same table several times could do it ? that way I could maybe make more than one select...

Yep I tried with .qry --- I noticed that it's possible to base a report on any number of table but ... on only one .qry so it doesn't solve my problem cause I need to have more than one select (cause some selected fields need a different where clause than others because the date restriction...

So how can I make (is it possible??) this report : table request --> fields : -start_date -end_date -status -worked_time -Problem_type -<Other fields I don't...

i want to insert a sql field in a report but even if try with a simple query...I have an error ex: select etat from requetes and i get &quot;sql expression invalid&quot; message what's the problem...? The connection with ODBC is ok : the fields r available in the field tree...

Hi everyone !! I'm new with Crystal but I want to use more of its feature and functions... I want to convert a string to a time value but the string is a sum of time values converted to a string later (ex: sum(thread.time)) so I have totals like --> 45:23 that means 4523 minutes so I did this...

Thanx Ken ...that's exactly what I wanted to hear !! or read !

Hi Ken ...I've looked in the forum but i didn't find what i'm looking for.....i'm kinda new with crystal and i have a question for you.... I have a report that's based on a query . How can I make the report up to date without re-running the query ? I want a one-touch report that makes the...