Same column returns different data type..

[theregister]

I have the same column in a database, that when I select all the columns it returns a long, but when I run a stored procedure in another data source that is supposed to return the same column, it returns but as an int.

So when I try to make a relation between them I get the next error:

The key types of the relation does not correspond 'columnname-columnname' column types which were specified as keys for the 'relation' relation does not correspond! Such a relation cannot be created when report rendering!

Why does this happen?

[Alex K.]

Hello,

Can you please send us a test data which reproduce the issue for analysis.

Thank you.

[ChrDressler]

I have the same issue. You can reproduce it:
Given:
- Two DataTables, each one with a column CustomerId (int).
- Relation between both tables with columns CustomerId.
- Table one with some rows, table two must be empty, no rows!

In this case, the rendering engine can't determine relation's "right side" and the error appears.
I think, you can superess the error, if the "right" table has no rows, because there's nothing to render.

-Christoph

[HighAley]

Hello, Christoph.

Could you send us a sample report template with data for analysis?

Happy New Year and Thank you for using our product.