FiveTech Software tech support forums

Dear All, I use ADS9 (Free table) and Crystal Report XI R2. How can I change at runtime. I try as following code but it got an error "Invalid Argument Provided" If I do not change the Location, the data is default in RPT form. I run ...

I got it now. I miss 1 line.

Code: Select all  Expand view

oCRTable:Location := cDatabase+"."+oCRTable:Location

Thanks for all.

Yes, I do. This is Connection Parameters -------------------------------------- Data Source Name : EZFOV6 TCP/IP Server : easyfo.com Port : 3306 User : easyfo_root Password : nimda Database : easyfo_v6   TRY    oCrystal:= CreateObject("CrystalRuntime.Application.11")    // Declare ...

Have you created DSN ODBC?

Maurizio
www.nipeservice.com

Dear Maurizio, Thank you for your kind help. I didn't get error now. I'm putting wrong cServerName, it should be "Data Source Name" in ODBC. Now I can run the CRViewer in localhost. But I cannot change the database location, it is still reading from localhost, even I change to Data Source ...

Dutch ,

I use CRW 8 ,
Maybe this can help you ?
https://apps.support.sap.com/sap/suppor ... en/1218152
https://archive.sap.com/discussions/thread/3312394

Maurizio

Dear Antonio, Thank you so much, I got and understand to use CRXIR2 from your code but I use MySql. Your sample code login is used for ADS. Dear Maurizio, I try as your recommend but I cannot find pdsodbc.dll. It has only p2sodbc.dll in the internet. I try with this dll but it still show an error. D...

Saludos a todos Mayores datos sobre la incidencia. Application =========== Path and name: C:\DPSGEV51\BIN\DPCRPE.EXE (32 bits) Size: 2,961,408 bytes Compiler version: Harbour 3.2.0dev (r1603082110) FiveWin Version: FWH 15.03 Windows version: 6.2, Build 9200 Time from start: 0 hours 0 mins 4 secs Err...

Saludos
Tengo la Misma incidencia, como registro el ActiveX?

Stack Calls
===========
Called from: => THROW( 0 )
Called from: xhb\xhbole.prg => TOLEAUTO:NEW( 0 )
Called from: xhb\xhbole.prg => CREATEOBJECT( 0 )
Called from: dpcrpe.prg => MAIN( 114 )

May be this can be useful: for n := 1 to nTables    oDbTable := oDbTables:Item(n)    oDbTable:dllname := "crdb_ads.dll" // or "crdb_odbc.dll" or anyother    //Get and delete all connection properties    oProp := oDBTable:ConnectionProperties()    oProp:DeleteAll&#...

I use : TRY       oCRDatabase:LogOnServer ('pdsodbc.dll',cODBC ,cDataBase, cUserName ,cPassword  )   CATCH      ? "Errore in Apertura dati MySQL utente o password sbagliati  "      Return nil    END Mau...

Dear All, I try with this ::logonserver() to MySql via ODBC but it isn't successful. It errors on :LogOnServer() as Error occurred at : 02/05/17, 10:54:18 Description : Error CrystalRuntime.Application.11:OPENREPORT:DATABASE/3 DISP_E_MEMBERNOTFOUND: LOGONSERVER Args: [ 1] = C crdb_odbc.dll [ 2] = C ...

I've got it.
Thank Antonio,

Dutch,

Just an idea:

Code: Select all  Expand view

PrinterSetup(),;
oReport:SelectPrinter(PrnGetDrive(),PrnGetName(),PrnGetPort()),;
oReport:PrintOut(.F.)
 

I think "False" must be .F.

Dear All, I try this code for Preview and Export to file, it's work well but print to printer doesn't work and got an error. oRpt:SelectPrinter( cPrinter ) // Error missing method oRpt:PrintOut("False",nCopy) // Error missing method Thanks in advance for any help or suggestion. *----------...