Home› General
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Why I can't link dataviews

rbuserrbuser
edited September 2005 in General
Hi,

I would like to know why I can't link two dataviews created in my report:

There are one dataview, called Contas_A_Pagar and another one called
Enumeracao.

The dataview Enumeracao gerenetes this following sql code:
SELECT S000ENU.CDOENU, S000ENU.DESENU,
S000IEN.CDOENU CDOENU_2, S000IEN.CODITN,
S000IEN.VLRENU
FROM S000ENU S000ENU
INNER JOIN S000IEN S000IEN ON
(S000IEN.CDOENU = S000ENU.CDOENU)
WHERE
( S000ENU.CDOENU = 'LISTASTATUSMOVIMENTOFINANCEIRO' )

From the work environment of the Data tab, when I try to drag a link
between the dataviews Contas_A_Pagar and Enumeracao, RBuilder just
doesn't allow to do it.
I need to link the field "CodItn" from the dataview Enumeracao to the
master dataview "Contas_A_Pagar", but RBuilder can't let me link these
dataviews. Curiously, If I try to drag the field "CdoEnu" from the
dataview "Enumeracao", RBuilder allows me. I just can't drag the field
CodItn.

I don't understand why this happen. Could someone explain it to me?

Thanks a lot.

Comments

  • nardmoseleynardmoseley
    edited September 2005

    1. What is the datatype of the field? Is the field a calculated field? If
    you can link from other fields in the same dataview, then I suspect it might
    be the data type of the field.

    2. If you cannot link from any field in the dataview, then I suspect that
    the dataview query contains calculated fields that prevent it from being
    linkable.

    3. What version of ReportBuilder and Delphi are you using?



    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • rbuserrbuser
    edited September 2005
    Nard Moseley (Digital Metaphors) wrote:
    Hi Nard,

    Thank you for your attention.

    1. This field is not calculated. It was created in the database
    (MSSQLServer 2000), and its data type is varchar(2).

    running in Query Analyzer:
    sp_columns s000ien

    table_qualifi owner table_n column data_ty type_na precisi length
    db_costa teste S000IEN CDOENU 12 varchar 30 30
    db_costa teste S000IEN CODITN 12 varchar 2 2
    db_costa teste S000IEN VLRENU 12 varchar 40 40

    2. There aren't any dataviews with calculated fields.

    3. I'm using RBuilder 9.02 and Delphi 7.

    I'm using DBExpress to connect to the database.

    Bruno.
  • rbuserrbuser
    edited September 2005
    Hi,

    Anyone else had the same problem and fix it?

    Thanks
    Bruno.

This discussion has been closed.