How to handle dynamic fieldsets in a report?

[subha_iwov]

Hi,

We have a requirement where the user should be able to enter any SQL query in the report input form. The report should be generated for that query. So the user can query for vaying fieldsets in each of his SQL queris. I am not sure how to create a Jasper report which can handle dynamic fieldsets.

Does Jasper support such a requirement?

It would be great if anyone can please help me on this? 

Thanks,

Subha

[subha_iwov]

There is one more similar requirement where depending on user input parameter 2 different tables are queried. But the resultset for the tables vary by 2 fields. How can I handle this. Is there a way by which I can disable or hide fields in a report. Please help.

Thanks,

Subha

Post Edited by Subha Epari at 12/09/08 13:52

[swood]

Have a look at using printWhenExpression. If a field does not exist, then you could suppress bands etc.

There is also the Column Selector addin at www.jaspersoft.com/jaspersoft_app18.html

 

Sherman

Jaspersoft

[subha_iwov]

Hi Sherman,

That is great. Thanks for the information.

I want to run reports on the JasperServer Community Edition.

Does this Column Manager library come with JasperServer Community or Professional Editions.

Also please let me know if such reports can be designed with IReport.

Many Thanks,

Subha

 

 

[subha_iwov]

Hi Sherman,

I tried having a boolean expression for PrintWithExpression properties in both field header and field value.

Also Checked the option "Remove line when blank" for both field header and field value.

And also Checked the option "Blank when null" for field value.

Still I get the error:

com.jaspersoft.jasperserver.api.JSExceptionWrapper: Unknown column name : DEP_UUID

...

...

Here DEP_UUID is the column name which is not present in the query resultset.

I want to have this column because I want to show it for a differnt query based on user input.

Could you please give me some help on this and let me know where can I get help on this.

Thanks,

Subha

Post Edited by Subha Epari at 12/15/08 10:37

[swood]

The Column Manager library is an add in that works for either JasperServer Community Edition or Professional.

 

Sherman

Jaspersoft

[swood]

Can all your queries always return a value for that column, even a dummy value like null or empty? Then your expression should work.

 

Sherman

Jaspersoft