Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Convert template from ASCII to Binary

edited June 2008 in General
Hi,

I am in the process of migrating the reports from 7 to 10.

My first step is to compress the data ( I have reports with more than 6MB).
I save the templates in a oracle database using the long field (which now
produces a lot of performance problems).

If I load a report, changing the Template.Format to ftBinary and save it
back to the database the report is now "binary compressed" and I can run it.
But if I try to relead the report in the Designer I got an:

EReadError. Invalid Property. Error on reading ppReport2.NoDataBehaviours.

I have no ppReport2 on my myEURPT.PAS

Can you help me?

Best regards
Sven Heuer

Comments

  • edited June 2008
    ... or: What is the correct way to transform a report from ASCII to Binary?


  • edited June 2008
    Hi Sven,

    Which exact version of ReportBuilder are you using? (10.xx). If you load
    one of your old reports then save the report to file, do you still get the
    same behavior? Are you able to recreate this using the end-user demo
    included with ReportBuilder?

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited June 2008
    I have the old 7.04 (pro) version. My goal is to go to 10.xx; but first I
    have to move a lot of old/wrong stuff. Loading into 10 may work, but does
    not help me. I need the report back in 7.04. But I will try it and send you
    the result.

    I just load the report via Report1.template.loadfile. Change to binary and
    save it with Template.SaveToDatabase. The saved template runs but loading it
    again to the designer produces the problem.

    By the way. Because in the old days of 7.0 the AutoSearchValues -stuff had
    some problems with firing the correct event to the correct time (Starting
    the report, showing my own form for collecting the parameters; putting the
    values to autosearch and so on), so I made my own workaround. This
    workaround does not work anymore since 9.0 (because you fixed the problem
    ;-). No matter, but is there a way that I can convert the rap code to
    somethink like clear ascii, do some changes in the clear text and save this
    back to rap. Otherwise I have to change manually hundreds of report by hand.

    Greetings
    Sven

  • edited June 2008
    Hi Sven,

    When converting your reports to binary are you using a minimal application
    with a new empty report? I took a look at all the old patches we have for
    RB 7.04 and did not see any issues like the one you are experiencing. If
    this is a bug in 7.04 that has been fixed for a later version, you may need
    to wait on converting your templates to binary until you move completely to
    RB 10.x.

    Although it is not possible to view the RAP routines in ascii format in the
    template, you can use the method used in the following example to access the
    routines in code and alter them as you need. Creating a loop to do so with
    all your reports would speed up the process.

    http://www.digital-metaphors.com/tips/RAPModifyPrograms.zip

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited June 2008
    Thx. Nico,

    The RAP example is exactly what I needed. You just saved me tons of hours of
    work :)

    I will wait with moving to binary if I have the reports in 10.x . I suppose
    this will save me time.

    Thx a lot

    Sven


This discussion has been closed.