|[SOLVED]crosstab in subreport [message #773427]
||Sun, 01 January 2012 15:15
| Prashant Jha
Registered: September 2011
I need to have crosstab in a sub report like we do for a table in this example http://eclipse.org/birt/phoenix/examples/reports/subreports/ By storing the current group value in a local variable, and binding the parameter to the dataset, it is possible to achieve the same. However, for a crosstab there is no such option.|
What I tried to do:
1. I created the dataset to be used in datacube without any where clause in the sql query(as custId was in the example).
2. Next I stored the group value in a local variable as.. local = dataSetRow["Tables"]in the group row table cell.
3. In the filter of data set in data cube I add the filter condition... basically,
dataSetRow["Tables"] like table.
Now the data gets filtered only for the first value of the local. I get the same cross tab for the all the values of the group.
Is there any feasible way to achieve sub report with cross tab or is just not possible?
[Updated on: Tue, 03 January 2012 20:20]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.12954 seconds