How To create Multiple Report Controls

0
Hello, Dears,
Im newbie in JasperReports Server, I have created two Jasper Reports, Report_1 and Report_2, Report_1 has the control named Date between (filter on date) and Report_2 has also the same control (Date between), but when i try to create a Dashboard which contain the two reports, I click on the "Multiple Report Controls" tab under "Special Content" but no futures appears in it !!! The common Control "Date Between" appears successfully under the "Single Report Controls" tab.... So what is the mistake that i have done ? And how to resolve it ??? In other words, how to make the "Date between' control appear under the "Multiplie Report Controls" ?
 
Special Content Folder
 

I googled a lot, but either I used the wrong keywords or there are no simple solutions on the internet. I hope somebody here can help me.

Best regards and thanks in advance.


 

BinaryMan's picture
Joined: Oct 2 2014 - 6:58am
Last seen: 4 years 8 months ago

2 Answers:

0

After a hard work, i got the solution finally, There is two methods to do this:
Method 1: Create two domains and in each domain have the same name to the Date column.

Method 2: Create a join between the two derived tables, then you can add the two derived table to the Ad hoc editor, and finally put the same field (Date) in the row .... but this method is just to appear the Date in the Multiple Reports Controls and it may execute a wrong Query (join between to tables) to give a wrong data and finally to generate an Untrusted report !!! So be careful when you try to do this method !!! I suggest you to use the first method ... 

Thanks @ernestoo for your efforts, I don't understand what you mean ! but i think that is the same idea between us !

BinaryMan's picture
Joined: Oct 2 2014 - 6:58am
Last seen: 4 years 8 months ago
0

You need to define the "Date" control outside of the report- what I mean is that there are two ways: define inside the report unit or outside of it in a folder, for example named "common" where you store the common controls

ernestoo's picture
8474
Joined: Nov 29 2010 - 11:59am
Last seen: 1 year 11 months ago
Feedback