How to select a database column as a title of the report?

[Aparna_MU]

Hi

I'm using Jaspersoft studio 6.1.0 community version.

I have a report which calls a stored procedure. Now, I want to populate its title dynamically by selecting report_name from a database table by passing parameter as report_id. How to achieve this?

Thanks,

Aparna

[hozawa]

I'm may not be understanding your question correctly but what's the problem with just putting the field with the title in the title band?

[Aparna_MU]

I know to add a field. But the field should be showing a value selected from a column in the database table. E.g. When i run my report with Report parameter id as 'REP001' it calls a specific main procedure which call another procedure for REP001. It processes data and inserts it into a table from where I pick up data and display in my report. Thus, if REP001 is employee records by location, REP002 will show employee records by gender etc as an example. 

Now the title of the report should be 'Employee data by location' for REP001 and 'Employee data by gender' for REP002 depending on which rep id I'm passing as a parameter value. I thought of creating a table with structure report_id, report_name, report_title...and so on and of picking up title from this table and displaying it in the report.

As I'm calling my stored procedure in 'Dataset and Query dialog', I don't know where to put my SELECT statement for selection of title from database table.

 

Can you help?