Jump to content
Changes to the Jaspersoft community edition download ×

Can't join on calculated field in Domain Designer ?


svedec

Recommended Posts

I use JasperReports Server Pro 5.0.1

I want to join 2 tables, of which one field is a calculated field (made in domain designer)
Apparently, this cannot be done, as the join-icons grey out when I select my calculated field.

Why is this ?
I tried to work around it, and make a derived table from my entire table, plus the calculated field, but that completely slows everything down.
I'm under the impression derived tables don't use indexes.

Another workaround would be to physically include the calculated field in my table, but I'm no fan of that.

Any suggestions, or is this just not possible (and why ??).

Thanks on beforehand.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...