nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Parameter is not filtering data

nihar_2

Hi , I have created a parameterlist to sort gender,,, 
 
But there is no effect even if i select the Male or Female , all genders are getting populated .. 
 
 
I have attached my sample file , please let me know where i went wrong.. ( I am new to BIRT ) 
 
 
Thank You,,,,,,

Find more posts tagged with

Comments

rawesso

Hi,

I edited your data set and your parameter does not seem to be linked to the data set. You have to set this link in order to have the data filtered according to the selected parameter value.

Thanks,

nihar_2

<blockquote class='ipsBlockquote' data-author="'rawesso'" data-cid="112266" data-time="1355136598" data-date="10 December 2012 - 03:49 AM">
Hi, 
 
I edited your data set and your parameter does not seem to be linked to the data set. You have to set this link in order to have the data filtered according to the selected parameter value. 
 
Thanks, </blockquote>
 
 
Can u guide me ur steps please... 
 
 
Thank You

rawesso

Hi,

The following link should help you:

http://download.eclipse.org/birt/downloads/examples/reports/Parameters/Parameters.html

Thanks,

nihar_2

<blockquote class='ipsBlockquote' data-author="'rawesso'" data-cid="112268" data-time="1355137572" data-date="10 December 2012 - 04:06 AM">
Hi, 
 
The following link should help you: 
 
<a class='bbc_url' href='http://download.eclipse.org/birt/downloads/examples/reports/Parameters/Parameters.html'>http://download.eclipse.org/birt/downloads/examples/reports/Parameters/Parameters.html</a> 
 
Thanks, </blockquote>
 
My version of BIRT is different from the video tutorial version.. 
 
Can u send the file which u have edited... 
 
 
Thank You

rawesso

Please, let me know your BIRT version so that I can test in that version and let you know the outcome.

Thanks,

nihar_2

<blockquote class='ipsBlockquote' data-author="'rawesso'" data-cid="112270" data-time="1355139172" data-date="10 December 2012 - 04:32 AM">
Please, let me know your BIRT version so that I can test in that version and let you know the outcome. 
 
Thanks, </blockquote>
 
 
Version : 4.2.1

rawesso

I just added two examples build in your BIRT version. The are using the Classic Models DB so you should be able to run them. Test_param_no_link.rptdesign is what you did and Test_param_linked.rptdesign is what you should do in order to filter data according to the parameter value. Note that the parameter has to be linked in the data set's "parameter" tab and in the Data set's SQL query.

Hope this helps.

Thanks,

nihar_2

'rawesso' wrote on '10:

 
I just added two examples build in your BIRT version. The are using the Classic Models DB so you should be able to run them. Test_param_no_link.rptdesign is what you did and Test_param_linked.rptdesign is what you should do in order to filter data according to the parameter value. Note that the parameter has to be linked in the data set's "parameter" tab and in the Data set's SQL query. 
 
Hope this helps. 
 
I did the following steps 
1) created a dataset 
2) created table and added the required columns 
3) created a parameter 
4) changed the query of the dataset ( where gender = ? ), it throws an error immediately

nihar_2

<blockquote class='ipsBlockquote' data-author="'rawesso'" data-cid="112272" data-time="1355141756" data-date="10 December 2012 - 05:15 AM">
I just added two examples build in your BIRT version. The are using the Classic Models DB so you should be able to run them. Test_param_no_link.rptdesign is what you did and Test_param_linked.rptdesign is what you should do in order to filter data according to the parameter value. Note that the parameter has to be linked in the data set's "parameter" tab and in the Data set's SQL query. 
 
Hope this helps. 
 
Thanks, </blockquote>
 
 
Finally I did every thing ,,, but the parameter (dynamic List) is not picking any value 
 
 
please check the attachment once

rawesso

It looks like you forgot to attach your adapted example. Please, attach it if you want me to look into it.

Thanks,

nihar_2

<blockquote class='ipsBlockquote' data-author="'rawesso'" data-cid="112278" data-time="1355147450" data-date="10 December 2012 - 06:50 AM">
It looks like you forgot to attach your adapted example. Please, attach it if you want me to look into it. 
 
Thanks, </blockquote>
 
 
Yea,, sorry I have'nt seen that.. :mellow: 
 
 
Please check the attachment below 
 
 
(NOTE: The example file (linked) which u sent me before is showing only single Country in the parameter list . Only USA country is populated)

nihar_2

rawesso

Hi,

I checked you report and it looks fine for me. I can't figure out why the list of values is empty. Are you sure the GENDER column has some data in the database? I unfortunately can't run you report as I don't have access to your database.

Thanks,

nihar_2

<blockquote class='ipsBlockquote' data-author="'rawesso'" data-cid="112311" data-time="1355218753" data-date="11 December 2012 - 02:39 AM">
Hi, 
 
I checked you report and it looks fine for me. I can't figure out why the list of values is empty. Are you sure the GENDER column has some data in the database? I unfortunately can't run you report as I don't have access to your database. 
 
Thanks, </blockquote>
 
yes, if I don't apply parameter all data getting populated including gender... 
 
But when I am trying to use parameter its not populating any data..

rawesso

Hi,

I found why the list box was not populated. It has to be created on top of another data set and not the same data set from where you extract the data to be filtered. I hope this helps.

Thanks,

nihar_2

<blockquote class='ipsBlockquote' data-author="'rawesso'" data-cid="112313" data-time="1355222196" data-date="11 December 2012 - 03:36 AM">
Hi, 
 
I found why the list box was not populated. It has to be created on top of another data set and not the same data set from where you extract the data to be filtered. I hope this helps. 
 
Thanks, </blockquote>
 
 
As u see there is only one dataset in the file which i sent u... 
 
i was unable to fig it out.... 
 
 
Is it possible for u to connect to teamviewer at 5:30 pm (GMT +5:30) India 
 
so that i can view the demo .... 
 
my email id : n.nihar@outlook.com 
 
 
Thank You

rawesso

Hi,

Sorry I could not reply sooner. I unfortunately can't help you over teamviewer. I will attach the same example I had sent to you after having added the second data set. You will see that the list box fetches its data from the data set called List Box.

Thanks,

nihar_2

<blockquote class='ipsBlockquote' data-author="'rawesso'" data-cid="112329" data-time="1355246224" data-date="11 December 2012 - 10:17 AM">
Hi, 
 
Sorry I could not reply sooner. I unfortunately can't help you over teamviewer. I will attach the same example I had sent to you after having added the second data set. You will see that the list box fetches its data from the data set called List Box. 
 
Thanks, </blockquote>
 
 
Thank you....