[is it possible to create a hierarchical dimension on Jasper Report Server for use with the ad-hoc report builder]

I would like to create a hierarchical category (like Country -> State -> Suburb) that a user can use when building reports (using Report Server Ad Hoc report builder).  Is this possible?

I know that the user can manually drag in country then state then suburb but it would be convenient just to have 1 dimension.  This would ideally then deal with drill downs in charts (is this being too optimistic?)

[Possible to set report width/height using visualize.js]

Do not put reports in spans.  Use DIV elements.  This fixed my issue, sorry.

[Possible to set report width/height using visualize.js]

I'm trying to inject reports into divs but the report is totally ignoring all my attempts at forcing width/height.  The Visualize.js API docs have nothing on this either.  Howe can I force a chart to stay within the bounds of its container? Or how do I set the size of a report using reports server ad-hoc report builder?

Tnx

[Cannot set filters (using visualize.js) to a report created using the jasper server web app]

It turns out that creating filters in ad-hoc builder on reports server renames the filter.  So if you add a filter named "age" then it is actually called "age_1".  This was the problem, I was passwing params: {'age':[100]} where it should have been age_1.

 

Tnx

[Cannot set filters (using visualize.js) to a report created using the jasper server web app]

I created an ad-hoc view that has a parameter.  Saved it as a report but when I try to run this report using visualize.js it does not accept my params. It just runs the report with the last set of parameters saved in the ad-hoc view.

Tnx

[Is it possible to integrate ad-hoc reporting capabilities into an external system]

Using any of the integration options? I.e. Rest API, Visualise.js, etc?

I don't even mind using IFrames if we can get around the user having to re-authenticate.

A bit of background; we have a web application that we are adding reporting to.  I would love to give users the ability to:

- Create adhoc reports/charts

- Save them as public or private (this could map to different folders under the jasper covers)

- Have a menu where the user can see all public and their own private ad-hoc report

And ideally all of this without ever leaving the existing web application.

Thanks

Guido Tapia