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

nardmoseley

About

Username
nardmoseley
Joined
Visits
8,059
Last Active
Roles
Administrator

Comments



  • - if you have a form based app that can load an .rtm from file and you have
    a server based app (ReportTemplateVolume) that cannot load the same .rtm
    file, then compare the difference between the two.

    - simplify eac…

  • Glad to hear you resolved the issues.

    I was recommending that you create a simple test application that can test
    loading the .rtm files and generating to preview. (Without having RB Server
    involved).

    In other …

  • - the next test should be to create a simple Delphi form application (i.e.
    non-server) that contains some code behind a button OnClick. The code should
    load the same report template as you tested with the ReportTemplateVolume.

  • Try some incremental tests...

    - test using only the ReportExplorerVolume (remove the ReportTemplateVolume
    datamodule from the project).

    - test using only the ReportTemplateVolume (remove the ReportExplorerVolume

  • If you have reports that are stored in the report explorer database tables
    (rbFolder, rbItem) and are using DOA, then in the end-user report explorer
    project you will have used a TOracleSession component along with some
    Oracl…

  • - for testing, try creating a simple project that can run the report in a
    standard Delphi project (i.e. using TppReport.Print). The report should
    behave the same way on the server.

    - for testing, try adding a Label to th…
  • That is not a capability that is currently supported. but is on the list of
    features to add.

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com


  • I do not have a specific time estimate. This is somthing that we would like
    to improve. The JavaScript Date object is currently be used to parse the
    date string and it does not support date formats. We need to find a new
    appr…

  • - for the ClientReport, see the following article.

    - the WebTier currently does not support alternate formatting because the
    JavaScript validation code is not flexible enough. This is on the list of
    things to improve.

  • RB Server is multi-threaded and will create a separate instance for each
    report that generates. The report must have a thread safe environment in
    which to execute.


    Avoid using global/unit level variables/objects in…

  • Make sure that the report form is thread-safe. Do not use any unit level
    'vars' or global objects. Use only instance variables.

    When testing in the development sever, try some tests in which two clients
    request the same …

  • report server <----> webtier <---------------> web browser clients
    - session cache - web session cache

    If you shut down the report server, the webtier will have no knowledge about
    that. There is…

  • The report server and webtier each manage persistent sessions that implictly
    time out if a client does not make another request in a specified amount of
    time. (the session time out).

    The report server typically runs with…

  • - if you want to restart everything, you need to stop the report server
    /and/ the webtier

    - the webtier maintains a cache of web sessions that corresponds to the
    browser clients. The web cache for a single web session wi…

  • - that explains it. You need to use the SQL script installed to
    RBuilder\Demos\EndUser Databases\SQL Server\CreateEndUserTables.sql. (The
    SQL script does indeed use varchar.)

    - Perhaps I should have emphasized that a bit…

  • Check the configuration of the ADOConnection. Acccess the connection string
    dialog and select the Provider tab. Check that the provider is 'Microsoft
    OLE DB Provider for SQL Server'

    In my testing here with SQL Server and…

  • What database engine are you using?

    ReportBuilder with ADO work great for connecting to MS Access and MS SQL
    Server. This combination is in wide use by thousands of customers.

    I would not use ADO to connect to Oracl…

  • - the first step is to build and test an end-user application that uses the
    explorer database with ADO . Examples of this are installed to
    RBuilder\Demos\EndUser Databases. There are examples for MS Access and MS
    SQL Server. …

  • - Try using the SessionParameters and then OnAutenticateReportAccess event
    to control the database connection string.

    - Make sure that when you save the DataModule in Delphi, the
    ADOConnection.Connected property is set t…

  • -------------------------------------------------------------------------------
    Tech Tip: RB Server - Exception Handling
    -------------------------------------------------------------------------------

    This article applie…

  • Thanks for the feedback. Please email support@digital-metaphors.com with a
    prioritized list of items that you would like to see added.

    At this time I cannot say what will be included in the next major release.

    --
  • - there is not a max time, I do not know why the report is not completing

    - for long reports like this, I would try create a separate application that
    can periodically generate the report to an archive file (.raf) and then you

  • For future reference, please start a new thread.

    - ReportBuilder is thread-safe.To build thread-safe reporting solutions,
    requires that you provide a thread-safe environment in which the report can
    execute. See the RBuil…

  • I'm still hoping someone with direct experience will reply to your question.

    I would try using the WebTier within the IntraWeb app. You could try to
    forward the report related web request to the webtier.

    The other a…

  • I do not know what would cause that.

    - try rebooting the server

    - see my response to the post today about temporary files and try cleaning
    up any temp files that are laying around.

    --
    Nard Moseley

  • Great news - glad to hear it is working :)

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaph…

  • - if you have not done so already, first try running the exact example
    project that I posted. It works in my testing here

    - perhaps in your application you are not using the report explorer
    interface? I think in the exam…

  • Here is an example that shows how to set default autosearch field values
    from the webtier and have them displayed in the autosearch dialog.

    www.digital-metaphors.com/tips/rbWebAutoSearchCustom.zip


  • Try this....

    // change requested content to the search form
    myWebRequest.ContentParameters['content'].Value := 'searchform';

    myWebTier.ProcessWebRequest(myWebRequest);



    --
    Nard Mo…

  • The Custom Parameters Demo shows how to handle autosearch parameters in
    addition to session and report parameters. It does /not/ show how to do
    exactly what you describe, because it shows the user a custom autosearch
    form. H…