Jump to content
Changes to the Jaspersoft community edition download ×

passing main parameter to sub-datasets with JasperStudio


cek.i06go
Go to solution Solved by cameron_1,

Recommended Posts

I'm created a report with JasperStudio 5.5 that have many parameter defined in the main and a lot of sub-dataset (defined with tables) that required this parameters.

The situation:

/main/Parameters: myPar

/main/mySubDataSet1/
/main/mySubDataSet2/
...
/main/mySubDataSetN/

The sub-dataset need to use this parameter in her query: select * from Tab t where t.attr = $P!{myPar}

So, my problem is that the sub-dataset can't access at this main paramenter, all the time that i try compiled, the program send me "Parameter not found : myPar".

How i can do for use myPar in the sub-dataset?

p.s.: i read this thread Pass main dataset parameter to subdataset query (based on iReport) but without success...

Link to comment
Share on other sites

  • Replies 19
  • Created
  • Last Reply

Top Posters In This Topic

  • Solution

Parameters are attached to the dataset, if you expand the dataset itself, you'll find a section there for parameters, just like in your main report.

JaspersoftStudioProfessional_2014-01-21_09-03-18.png.9b9a438018d629ec7e6be90b83f56912.png

You'll need to link the parameters together though, using the connection properties where you're actually using the dataset, eg, in a chart or a table. For example, in the table, you go to the dataset tab of the properties pane, and click on the parameters button to map the parameters between your main report and your sub dataset.

JaspersoftStudioProfessional_2014-01-21_09-07-05.png.42a65abd9da488bdecd7ff35a18938db.png

 

JaspersoftStudioProfessional_2014-01-21_09-07-38.png.34556d74b30c632847344bda3913282f.png

Link to comment
Share on other sites

  • 1 month later...
  • 1 month later...
  • 5 months later...
  • 3 months later...
  • 11 months later...
  • 1 month later...
  • 2 weeks later...

For do this with charts, make the follow steps:

 

1) Create new parameter on sub-dataset to receive the value from main dataset of report. Uncheck "Is for prompting" option;

2) On "Chart Wizard" window, click on "Parameters" button to open window to map the parameters: http://community-static.jaspersoft.com/sites/default/files/images/Jaspersoft%20Studio%20Professional_2014-01-21_09-07-38.png

Link to comment
Share on other sites

  • 4 months later...
  • 4 weeks later...
  • 1 month later...
  • 2 months later...
Dude, i think you might miss one detail, i add this part to complement your answer. When we are going to add the parameter in the window "Dataset Parameter" a new window comes, in that window we must select the parameter we want to made the relation with the main parameter of the main report, but we must dont forget below there another option "Parameter Expression", we need to add the parameter here to, is mandatory to make this works, so take this part very carefully, hope this can halp to another person.
Link to comment
Share on other sites

  • 4 weeks later...
  • 1 year later...
  • 3 months later...
Wondering if anyone has a solution to this. I have a parameter for "Academic Year" which is a string value of, for example '2017-2018'. This needs to be passed to subdatasets as a string for use in query WHERE clauses. However, it is being "evaluated" when passed so that it resolves as '-1'. I've tried the $P! convention when referencing both the report parameter and the table dataset parameter to no avail. Any suggestions?
Link to comment
Share on other sites

  • 2 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...