Adding new drop down in birt report and changing query parameter based on value from dropdown

mishrasanju76 · March 18, 2015

I need 2 drop down and populate the data as per both drop down selection But 2nd drop down will also populate as per 1st drop down selection. Like if select Ãear' in first drop down then 2nd drop down will display '2010',2011 like and if select 'MONTH' then 2nd drop down display 'JAN', 'FEB' .
When select both drop down and click on OK then will display records as both drop down selection. It will be greate help if provide me any sample code.
 
Thanks.

mishrasanju76 · April 1, 2015

I have to show BAR Chart in BIRT for 2 series(Y series) like Total Student and EmpStudent . I have created 2 DS for , one for Total and other for Emp and created 2 series also. But BAR chart not allowing me to use different DS for different series, Even If I am trying to do filter for 1 series, its works for both series.
 
Please let me know if anyone can help me here.
 
Thanks in Advance

mogwai · April 1, 2015

A chart can only be bound to one data set. You could create a joint data set if your 2 data sets have a common field - then bind your chart to the joint data set.

mishrasanju76 · June 5, 2015

I am getting issue in BIRT Line Chart. I have to show X- Axis in Month and Y-Axis Data for Week as below figure.
I am trying to do same work in BIRT but spaces or not coming between dates while till Data Set it looks like spaces in between Dates. Please let me know if have any solution. Thanks in Advance.

mogwai · June 5, 2015

This sounds like a formatting issue but I can't find any figures attached.
Since this has nothing to do with drop down lists I suggest you open a new topic.

jalebi · February 1, 2016

hello guys ,
 any body can help me to create a report with dropdown box, multiselect and 'al'l fields. i was seen many examples but i am not reached to certain point.

mogwai · February 1, 2016

I've added a Word document explaining how this works. I believe most of the content comes from earlier posts by Michael.

jalebi · February 2, 2016

dear mogwai,
 i feel very happy replying my request, i was developed one report as per documentation but it is showing all values at a time. when i am selecting the individual it shows some error. i am getting struck with to upload by report can you please tell me how to apply.

mogwai · February 2, 2016

Dear Jalebi,
This is a bit cryptic. Can I suggest you try to apply your implementation to the standard BIRT database and upload your report. It will give me a firmer basis to work from.

jalebi · February 3, 2016

dear mogwai,
 please find the below attachment. when i am selecting individual country to display the report it is showing some error. by default it is showing the records as per report parameter

mogwai · February 3, 2016

It doesn't look like the file is attached Jalebi. Use the 'More Reply Options' button at the bottom right, then the 'Choose File' button to select your file. Don't forget to also click on 'Attach This File' after you have selected it.

jalebi · February 3, 2016

find the below attachment.

mogwai · February 3, 2016

I see there is a mistake in my guideline. The code in the beforeOpen event on your dataset should be: if (params["Country"] != "All"){ this.queryText = this.queryText + " WHERE CLASSICMODELS.CUSTOMERS.COUNTRY = '" + params["Country"] + "'"; } 
So replace the 'and' by 'WHERE'.

jalebi · February 3, 2016

i was changed and deployed in server but it is showing - There is no report design object available. 
let me know the what is the problem

mogwai · February 3, 2016

This is a deployment issue. Make sure your line in the HTML code:
window.location = "<a data-ipb='nomediaparse' href='http://192.168.1.145:8040/WebViewerExample/frameset??__report=test_01.rptdesign&Country='>http://192.168.1.145:8040/WebViewerExample/frameset??__report=test_01.rptdesign&Country="</a>+ value; 
points to the right location. Also, replace the double ?? by a single ?

jalebi · February 3, 2016

dear mogwai,
 now it's working very nice thanks for giving guide lines to develop the report. now i will start with my database to develop the same report. if i have any technical query i will touch with you.

mogwai · February 4, 2016

You're welcome Jalebi. Glad to help.

jalebi · February 4, 2016

hai mogwai,
 here i am attaching report and word document please go through.
problem is it is generating the records default value "all" which is given in report parameter, when i am changing the value in report parameter it shows some error message find the word document. then check the query weather it is OK or not (data is completely from my database)

jalebi · February 4, 2016

dear mogwai,
 i was resolved the above problem please skip that

jalebi · February 15, 2016

hello guys,
 i hava a small clarification on dropdown. i want to develop my dropdown list with check boxes and scrolling is possible to do in report.

mogwai · February 15, 2016

Hi Jalebi,
 
The dropdown part is HTML. It is not common to use check boxes in a dropdown, but it can be done with HTML and Java script. You can find an example here:
<a data-ipb='nomediaparse' href='http://stackoverflow.com/questions/17714705/how-to-use-checkbox-inside-select-option'>http://stackoverflow.com/questions/17714705/how-to-use-checkbox-inside-select-option</a>
 
It would be more typical to use a multi-select control or checkboxes without dropdown functionality (for a short list of options). Examples are here:
<a data-ipb='nomediaparse' href='http://www.htmlcodetutorial.com/forms/_SELECT_MULTIPLE.html'>http://www.htmlcodetutorial.com/forms/_SELECT_MULTIPLE.html</a>
 
Note that for multiple option selection you would also have to change the WHERE clause of the SQL of the query to IN instead of =. I believe that is in the Word guideline I provided.
 
Good luck.

jalebi · September 20, 2016

dear mogwai,
 i need how to sum the time values which contains series. here i used cross table for displaying rows into columns,please find the below attachment and screen shot . grand total also used by using column level but it displays only sum of hours in number format. can you please help me how to sum and result should be in time formate.
 
Thanks & Regards
Gopalakrishna.

jalebi · September 29, 2016

dear buddies,
 
 any body can help me , while creating a cross tab i am using parameters with multi select functionality . it is generating reprot but all records is showing shall in know why it happens. we can pass multi select values in cross tab or not please replay me .

mogwai · September 29, 2016

Hi Jalebi,
 
You can use your parameters in the crosstab filter, either when you define the data cube or in the crosstab itself. Without your report design it is impossible to say why it is not working for you. Perhaps you could attach it and briefly explain what you are trying to do.

jalebi · September 30, 2016

hi Mogwai ,
 
 thanks for giving reply. my question is 
1. In cross tab we give functionality like muti select. ?
2. please find the below attachment i was developed with my requirements.
3.i used two parameters with dynamic option, in dataset i given some script to pass multiselect values.
4. when i am running i can able to give multiple options but data retriving is not filtering the as per multi select.
 
here i will attach screen shots and developed report , so i am kindly requesting you please give some solution for that.
 
Thank & Regards,
Gopalakrishna.

mogwai · September 30, 2016

Hi Jalebi,
 
It looks like multiselect2.rptdesign is the report design to look at. You are using 2 multi-select parameters and adding them to your query, but looking at the SQL you have written, they are being added in the wrong place. The javascript you have written adds the filters at the end - in this case after the group by clause. They need to be part of the where clause. To test this, I suggest you remove or comment out your group by clause in the data set query and it should work (without the grouping). I can't test this because I don't have your data source, but it is definitely not going to work the way you have written the sql currently.
 
If it works when you remove the group by clause, you can put back the clause at the end of your script:
 
this.queryText = this.queryText + " group by c.firstname, b.cp_prjct_name, DATE_FORMAT(date(a.totaltime),'%d-%b-%Y %W') "
 
For future reference, it is best if you simulate your problem in a simple report based on the Classic Cars database, so that anyone participating in this forum can run, test and edit your example.
 
Hope this helps.

jalebi · September 30, 2016

Hi Mogwai,
 
 
 i will try with default existing data with my requirements. as soon as possible i will develop the report as per you suggested.
 
Thankyou.

jalebi · October 3, 2016

hi Mogwai,
 
 thank you so much , i was changed the condition as you said . now its working fine as per i need.

mogwai · October 3, 2016

You're welcome. Good luck with your report.

xplorerdev · October 31, 2016

Great post. Gives some really good ideas. Thanks a lot. In somewhat similar lines, I have the following requirement:
 
I want to design crosstab report with two Dropdowns boxes being displayed on the report viewer page for the user to make selections.
 
Dropdown1 item is MIS Period and has values = Year, Quarter, Month
Dropdown2 item is General Dimension and has values: Gender, Country
 
When I select, Dropdown1 = Quarter and Dropdown2 = Gender, the crosstab report page should look like following:
 
Dropdown1: Quarter Dropdown2: Gender
 
 Gender
Quarter Male Female Others
 SUM(Sales)
Q4 2014 4000 2000 4000
Q1 2015 1000 1000 2000
 
Now, I want to change the Dropdown1 value to Year and Dropdown2 value to Country. So, when I set Dropdown1 = Year and Dropdown2 = Country, the crosstab report page should change into the below view:
 
Dropdown1: Year Dropdown2: Country
 
 Country
Year USA India Srilanka
 SUM(Sales)
2014 4000 2000 4000
2015 1000 1000 2000
 
The headers should change and the crosstab should display values as per the new dimension selected.
 
How can I possibly achieve such a design in OpenText?
 
Best Regards

Adding new drop down in birt report and changing query parameter based on value from dropdown

Comments

Categories