ReportBuilder x NexusDB - Error <unnamed TdaChildNxQuery instance>

rbuser

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

nicocizik

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

rbuser

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?

nicocizik

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

rbuser

Hi Nico,

Did you receive my email yesterday?

Samuel