Field Name Question

[confutatis]

Hello to all,

I've been working to convert some personal finance reports from an old NextReports 9.0 report writer using SQLITE to Jaspersoft Studio reports.  I've been noticing that when one of my query's field names is identified using an alias table, such as in the following example (not complete code, just paraphrasing):

     select
          tb_collect.payee
    from
        (select * from payee_master) tb_collect 

The field name will not display when rendered by Jaspersoft Server, but will display in Jaspersoft Studio.  To correct the issue up to this point, I've just been adding as "as" to the field declaration as in "tb_collect.payee as payee".  In a previous post, I mentioned this issue, but I never followed up on a real solution because I found this work around.  Somehow I feel there must be a config setting that might allow JS Server to recognize the field name when declared with a table alias.  Anyone have any idea?  It's not a huge issue, because I simply just add the "as" extension, but it would save me a little time if I didn't have to change all of my queries.

Thanks in advance,

David in OH

[Mehak Rajkumar]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.
 

[jiman]

With subqueries in Jaspersoft Studio Report, the field name in the subquery may not be referenced when running the report on JasperReports Server vs. in Jaspersoft Studio (where it can be referenced). This is due to differences in the way reports are rendered using the Jaspersoft Studio vs. JasperReports Server engines.

There are only two options for the versions available today, either you use the field name aliases as you have been doing or use derived tables or CTEs, which allow you to define field names within your query.