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

ISAPI PDF report

edited November 2001 in General
Hi,

I think I've read most of the posts on this issue.
My application returns a pdf file if the report template is designed on the
ppReport component. However if the template it's loaded from the database
(put there by Report Explorer) it hangs when print is run. I've experienced
problems in a normal app (not web) where it pops up a Oracle Logon Dialog
when print is run. I can not check if this is the case with the web app, but
when I copy the components and the code onto a normal application it works
without a problem (and without showing any visible dialogs).

Using :
Teechart 5.02
Reportbuilder 6.03
DOA
TExtraDevices for PDF export.

I need to try debugging as described by Mike Leftwich, but was hoping that
someone have any ideas?

Best Regards,
Paul

Comments

  • edited November 2001
    Solved the problem easily after setting up a debug environment.

    It was the Oracle logon. It appeared because the TNS-connect name in daDOA
    is case sensitive:
    If you create a report in RB accessing data on the TNS name "MyTNS", and you
    then try activating the report from an application where the OracleSession
    is connected to "mytns" it will fail to recognize these as the same, and as
    a result the logon screen appears.
    Solved it based on the article Updating the DatabaseName of a DADE Query
    from the Tech-tips Newsgroup.
    After loading the template I now set the databasename in the template to the
    one that is active in the OracleSession of the application.

    Best Regards,
    Paul

This discussion has been closed.