Jump to content

display visible section of input control on header


Recommended Posts

I have a report where i have configured input control using Single Select Query .

select code,description

from code_lookup

where table_name ='folder_type'

In this query, I have set up code as Value name and description as visible column

Here is the sample data -

code .        description

DMV .      Domestic Violense

HATE .    hate crme

If the user selects Domestic Violence, then I want to display in report header and not DMV.

How can I achieve this?  I have seen multiple solutions on this but none work.


Link to comment
Share on other sites

  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

That's what we do:

We will write a stored procedure to translate the codes, for example:

SELECT name FROM table WHERE code = 'DMV'

Then we will create a new Dataset in Studio, sourcing data from that stored procedure.

In the title part, retrieve data from the newly created Dataset. There you can get the whole description of that code.

Link to comment
Share on other sites

Thats what I do. Its doable If i have one query to refer to. But I have reports where there are 12 parameters. In page header, I can't call the values from subdatasets. That's the part  I dont like about Jaspersoft. 

There has to be some way to achieve this. 

Link to comment
Share on other sites

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...