BinaryMan Posted October 20, 2014 Share Posted October 20, 2014 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" ? 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. Link to comment Share on other sites More sharing options...
ernestoo Posted October 20, 2014 Share Posted October 20, 2014 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 Link to comment Share on other sites More sharing options...
Solution BinaryMan Posted October 20, 2014 Author Solution Share Posted October 20, 2014 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 ! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now