Field Type Mismatch error in dataset or pipeline

rbuser

I am using Delphi XE2, ReportBuilder 14.08, IBObjects 5.5.x and Firebird
database 2.1.

I have an application where I create a report and its related components
programmatically. This has been working well until I upgraded IBObjects
to version 5 from version 4. I don't know if this problem is Report
Builder or IBObjects, but I will start here.

At runtime, after creating the necessary components for the report, the
dataset, datasource, pipeline and so on, when I assign the report's
pipeline property to the earlier created pipeline component I get an
error "Cannot generate report. Pipeline could not open Dataset.Type
mismatch for field x, expecting: string actual: unknown."

This error arises when the for this particular report, the dataset is
empty - the query does not return any values. If the dataset returns at
least one record everything works fine.

Thanks for any help offered.

Regards,
Phil Horst

nicocizik

Hi Phil,

Some changes were necessary to our IBO demo after upgrading to IBO 5.
The issue you are seeing is that either the field definitions or
parameter definitions for you IBO dataset(s) do not have the proper
field/parameter datatype defined. Doing so should resolve any type
mismatch issues.

Moving forward, we hope you will consider upgrading to the latest
version of ReportBuilder.

http://www.digital-metaphors.com/rbWiki/General/What's_New/RB_15