SQL to Domain Language - How?

0

I have been able to create numerous complex reports just by trial and error, but I'm now at an impasse. I only have domain access to create reports, so I cannot use basic SQL select statements.

I have a field called Load.TransportModeName and this field only contains 2 values ("LTL" and "TL"). I need an input parameter that asks the user to select one or both of these values.

Basically, what I need to accomplish is the equivalent of this (I think), but I need to do it at the query level:

SELECT * from Load where $X{IN,load.TransportModeName, param_TransitMode}

 

Would very much appreciate any assistance or guidance.

zgadson's picture
14
Joined: Sep 24 2018 - 11:24am
Last seen: 1 month 1 day ago

   

swood_1 - 10 months 3 weeks ago

1 Answer:

0

You can create a query based input control using the "Domain" query language.

See https://community.jaspersoft.com/documentation/tibco-jasperreports-serve...

for the domain query syntax, which is the same as what you have used in your reports.

swood_1's picture
743
Joined: Nov 15 2012 - 10:47am
Last seen: 1 day 8 hours ago
Feedback