Tree Report

[cheeka]

Hi,

 

We are trying to generate tree report as shown below. We would like to have HTML and PDF versions of the tree report. In the HTML version we intend to provide expand/ collapse functionality and in the PDF version, we would be generating the report in all expanded format.

 

Our report looks like this

 

Region-Wise Sales Total

 

+ Manager1

+ Manager2

+ Manager3

 

On Clicking '+ Manager1' in the HTML version, it would be

 

- Manager1

...+ Sales Lead1.1

...+ Sales Lead1.2

...+ Sales Lead1.3

+ Manager2

+ Manager3

 

On clicking '+ Sales Lead1.1', it would be

 

- Manager1

...- Sales Lead1.1

......- Agent1.1.1

......- Agent1.1.2

...+ Sales Lead1.2

...+ Sales Lead1.3

+ Manager2

+ Manager3

 

Agent is the leaf of the tree. In each row of the report, we would be displaying additional columns like region-wise total sales like,

 

- Manager1 127 256 350

 

It means 127, 256 and 350 are sales made by all men under 'Manager 1' in east, central and west regions.

 

I am not sure, if we could use jasper to generate this kind of report.

 

If tree kind of report is not possible, is it possible to have every child details has separate report and in the html have some call back function which would generate this child details on the fly. The generated child details can be plugged into the main tree appropriately.

 

I would appreciate any thoughts on this.