Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: VDF crashes upon closing CR panel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Baiona - Spain
    Posts
    890

    Default VDF crashes upon closing CR panel

    Hi,

    I have this Crystal RDC report using a CDO. It works fine but when closing the CR panel the application triggers the error shown.

    I may run the report as many times as I wish as long as I don't close any of the CR panels.

    Any idea of what may be happening?


    TIA
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Pantalla_001.jpg 
Views:	173 
Size:	19.3 KB 
ID:	4894  
    Pepe Guimarães
    www.moose-software.com

  2. #2
    Join Date
    Jun 2009
    Location
    Lima, Perú
    Posts
    663

  3. #3
    Join Date
    Jun 2009
    Location
    Lima, Perú
    Posts
    663

    Default Re: VDF crashes upon closing CR panel

    Hi Pepe,
    an addendum:
    I have now several reports working without problems using CDO (without using temp files), but they meet two conditions:
    - don't use relates to dataflex files:
    Normally we use a big CDO file and additional parent files.
    These ones must be converted to CDO also or the data must be integrated to the big one.
    CRW relates CDO tables without problems..
    - And second, it´s necessary set this property inside OnInitializeReport:
    Code:
       Procedure OnInitializeReport Handle hoReport
          Set ComFieldMappingType of hoReport to crEventFieldMapping //to execute OnComFieldMapping
          ....
       End_Procedure
    and add this event:
    Code:
       Procedure OnComFieldMapping for cCrystalReport Variant llreportFieldArray Variant lldatabaseFieldArray Boolean ByRef lluseDefault
          Move True to lluseDefault
       End_Procedure
    this happen because the method AppendCDOData uses Cast to convert Date fields and it transform this in Datetime field. (Cast("01/01/2001",Date)="01/01/2001 00:00:00")
    Then CRW complaint about that ("database has changed").
    OnComFieldMapping with TRUE as answer corrects this.
    Saludos
    Ivan

  4. #4
    Join Date
    Feb 2009
    Location
    Baiona - Spain
    Posts
    890

    Default Re: VDF crashes upon closing CR panel

    Thanks Ivan.

    I had to finishe it yesterday so at the end I converted my dataflex files to CDO and did the report from there. If there was a single dataflex tbale, either related or not related to/from CDO tables the program would crash.

    I will try your advice for date files (I converted them to CDO string types)


    Ther bis just one problem remaining: We have the company's logo at the top of each page. Using Dataflex tables plus a .ini pointing to the folder where the .jpg file is plus the name of field containing the name of jpg file = true works well but not using CDO.

    Have you ever managed to solve this problem using CDOs as holding the .jpg name?

    TIA
    Pepe Guimarães
    www.moose-software.com

  5. #5
    Join Date
    Jun 2009
    Location
    Lima, Perú
    Posts
    663

    Default Re: VDF crashes upon closing CR panel

    Quote Originally Posted by Pepe View Post
    There's just one problem remaining: We have the company's logo at the top of each page.
    To do this, first, insert any jpg at its location in the report.
    Then right mouse click over the image and select "Dar formato al gráfico".
    Here select the tab "Imagen" and click in "Ubicación del gráfico".
    It shows me the "Taller de fórmulas" and select here the name of the field ({CDO_file.field}) where the complete jpg file name resides.
    That´s all

  6. #6
    Join Date
    Feb 2009
    Location
    Baiona - Spain
    Posts
    890

    Default Re: VDF crashes upon closing CR panel

    Thanks Ivan. I just the opportunity to do it now and it works beautifully.

    Regards

    PS: I owe you a beer. Coming to EDUC?
    Pepe Guimarães
    www.moose-software.com

  7. #7
    Join Date
    Jun 2009
    Location
    Lima, Perú
    Posts
    663

    Default Re: VDF crashes upon closing CR panel

    Quote Originally Posted by Pepe View Post
    PS: I owe you a beer. Coming to EDUC?
    very grateful
    I have to consult my "jefa" if I can cross the ocean to Baiona to collect my beer.
    best regards
    Ivan
    PS: the conference is in spanish / english / spanglish ?

  8. #8
    Join Date
    Feb 2009
    Location
    Baiona - Spain
    Posts
    890

    Default Re: VDF crashes upon closing CR panel

    Conferences and trainings are in english. Check the website : http://www.educconference.com/

    Since you are coming from so far I will get you two beers!. And if Kattya comes along I will get you two extra beers.

    By the way you have direct flighst from Rio, São Paulo and Porto Santo to Porto. Check here:
    http://www.ana.pt/portal/page/portal...cboui=84052670

    Anyone from the US? Then direct flights from Boston and New York to Porto, or with Air France to Paris and then to Vigo. Doubts?: contact me
    Pepe Guimarães
    www.moose-software.com

  9. #9
    Join Date
    Jun 2009
    Location
    Lima, Perú
    Posts
    663

    Default Re: VDF crashes upon closing CR panel

    Quote Originally Posted by Pepe View Post
    Conferences and trainings are in english. Check the website : http://www.educconference.com/

    Since you are coming from so far I will get you two beers!. And if Kattya comes along I will get you two extra beers.
    Hi Pepe,

    I know Ivan Kaupa and Kattya Varas from Brazil, very nice people.
    but I come from Perú. It's further away (three beers...?).
    Really my english is very bad, so I'll wait your comments after the conference.

    Un abrazo
    Ivan Schoof

  10. #10
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default Re: VDF crashes upon closing CR panel

    Ivan,

    If you come you will get a beer from me too!

    Maybe time for a I-owe-you-a-beer-webapp ?
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •