Home DADE

ReportBuilder x NexusDB - Error <unnamed TdaChildNxQuery instance>

edited March 2008 in DADE
Hi,

I created a report with a subreport that works fine when print all records.

When I select the print of just a group of records (from subreport
table) I received the following error:

NexusDB:_:_Query execution failed:_
Unexpected exception object raised:_[Exception] Error in statement:_Type
mismatch [$3CA1/15521].

I´m using ReportBuilder 10.07 Enterprise, Delphi RAD 2007 (Win32® R2
Version 11.0.2902.10471), NexusDB 2.0705 and DADE for NexusDB from
ReportBuilder (rbNexusDB10105).

Can you help-me ?

Samuel

Comments

  • edited March 2008
    Hi Samuel,

    Try executing the query directly to your NexusDB database without
    ReportBuilder and see if it runs correctly. Are you able to run the NexusDB
    example located in the \RBuilder\Demos\4. EndUser Databases\NexusDB\...
    directory? If so, take a look at the components and settings there to see
    if they match with yours.

    --
    Regards,

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

    Best Regards,

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

    I tried with EndUser and the problem was another.

    I saved the report in my application (.RTM) and imported in EndUser.
    After this, when I run the report his works fine.

    If I leave the EndUser, load it again and preview the report, appears
    the following error message:

    Project EndUser.exe raised exception class EDesignError withmessage
    'TdaMetaCache.GetFieds: unable to find table XXXX in cache'.

    Always before running the report I need to edit it, uncheck the option
    "Data Dictionary." (only on first run before load EndUser).

    In my system I do not use the ppDataDictionary. I save the report in RTM
    in my Database File (Blob Field). To run I execute this code:

    :
    :
    Buffer:=tMemoryStream.Create;
    tbParametrosRelatorio_01_Modelo.SaveToStream(Buffer); // blob field
    Relatorios_Usuario.Template.LoadFromStream(Buffer);
    Relatorios_Usuario.ShowPrintDialog:=True;
    Relatorios_Usuario.DeviceType:='Screen';
    Relatorios_Usuario.Print;
    :
    :

    The error that I reported () occurs
    only if I tell a range of a sub-report in my Application, but does not
    occurs in EndUser.

    If I selected all records, the report works fine.

    Is it because I am not using ppDataDictionary nor the ppReportExplorer
    in my application?
  • edited March 2008
    Hi Samuel,

    If possible, please send a small examaple demonstrating this issue and I'll
    try to recreate it on my machine. Send the example in .zip format to
    support@digital-metaphors.com.

    --
    Regards,

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

    Best Regards,

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

    Did you receive my email yesterday?

    Samuel
This discussion has been closed.