1) I am using a parameter called $P{Term} for the main report query.
My sql expression is:
SELECT
term,
gender_name
FROM
table
WHERE
term = $P{Term}
GROUP BY
term,
gender_name
2) I am using multiple cross tabs and would like to use subdatasets. I need to pass the same parameter($P{Term}) to the subdataset. I am not sure how do I do that ?.
My sql expression for the subdataset is:
SELECT
term,
class_level
FROM
table
WHERE
term = $P{Term} AND
class_level ='X'
GROUP BY
term,
class_level
Note: I tried to add the parameter)$P{Term}) to the cross tab by..a) right clicking on the crosstab
b) cross tab properties
c) under sub dataset properties > parameters tab
d) clicked on add
e) selected $P{Term} as default expression and name 'term'
But it does not recognize the parameter....says unknown parameter 'term'
Please help me on this. Thanks in advance
My sql expression is:
SELECT
term,
gender_name
FROM
table
WHERE
term = $P{Term}
GROUP BY
term,
gender_name
2) I am using multiple cross tabs and would like to use subdatasets. I need to pass the same parameter($P{Term}) to the subdataset. I am not sure how do I do that ?.
My sql expression for the subdataset is:
SELECT
term,
class_level
FROM
table
WHERE
term = $P{Term} AND
class_level ='X'
GROUP BY
term,
class_level
Note: I tried to add the parameter)$P{Term}) to the cross tab by..a) right clicking on the crosstab
b) cross tab properties
c) under sub dataset properties > parameters tab
d) clicked on add
e) selected $P{Term} as default expression and name 'term'
But it does not recognize the parameter....says unknown parameter 'term'
Please help me on this. Thanks in advance
8 Answers:
Posted on August 9, 2007 at 8:12am
In the subdataset that you created, make sure that you have created a parameter with the same name as the one you intend to use in the main report. in your case it will be term. and then, with the procedures that u have already described, you should be able to do it.
Posted on March 18, 2008 at 10:38am
Hi,
Here i am also facng the same problem.
I have created a report using subdatasets.
I am not able to display the subdataset fields in the main report.
If you have done,please give me the solution,or send me one simple and sample example which you have done.
I am attaching my JRXML file.
Please find the attachment.
Thanks in Advance,
Surendra. [file name=SubdatasetsExample.jrxml size=3044]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Sub...
Here i am also facng the same problem.
I have created a report using subdatasets.
I am not able to display the subdataset fields in the main report.
If you have done,please give me the solution,or send me one simple and sample example which you have done.
I am attaching my JRXML file.
Please find the attachment.
Thanks in Advance,
Surendra. [file name=SubdatasetsExample.jrxml size=3044]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Sub...
Posted on April 9, 2008 at 7:14pm
I have a question regarding sub-datasets. I am new to the Jasper reports and working on the integration with myu application. The Fill manager requires either a JRResultSetDataSource or a connection datasource to be passed to it. However this is only for the main report.
My question is how do I pass a JRResultSetDataSource to the subdataset for the chart. The chart that I want to display comes from a different query? Is it possible?
I do not want to put in the query in the jrxml file for it to get the data.
Please help.
Thanks,
Sumeet
My question is how do I pass a JRResultSetDataSource to the subdataset for the chart. The chart that I want to display comes from a different query? Is it possible?
I do not want to put in the query in the jrxml file for it to get the data.
Please help.
Thanks,
Sumeet