andre.erasmus
-
Posts
20 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by andre.erasmus
-
-
works for me
-
works for me
-
I also please need a answer to this can't find a solution anywhere !!!
Simular question here
http://stackoverflow.com/questions/21572104/suppress-all-subreports-when-exporting-to-csv-or-xls-in-jasperserver -
Currently my Jasperserver login page looks like this jasperLoginExample
I am using CAS to Login so the Jasperserver login no longer works
All I need to do is change the jasperserver login so that when it is loaded it will automatically redirect the user to "https://cas.nwu:8443/cas-server-webapp"
NOTE:
I am using jasperserver-pro 5.0.1
-
The short Version:
Im looking for a varuble I can pass along with a hyperling so that the input control screen isn't loaded (something like this ...&loadInputControl=false)The long version:
I have a drill down report (lets say reportONE) with input controles that need to be populated
When report is run the 1st time the input control screen appears and after the user enters and runs the report, the user can then drill down to the drill down report (let say reportTWO)
Once in the drill down report (reportTWO) the user can click a back link wich takes the user back to the 1st report (reportONE)
What is currently happeneing is the 1st report (reportONE) input controle is loaded with the parameters sent from the drill down report (reportTWO)
But what I want is for the report to automaticaly run when it is called from the drill down report (reportTWO) a.k.a skip the input controle screen
EXTRA:
I'm useing iReport 5.0.0
I'm using hyperlinks to drill down/up to the report
If i disable the "Always prompt" option for input controles then the user won't see the input controll screen the 1st time the report is run -
I only have 1 problem. I cant seem to send through a java.util.Collection type (or java.util.List), The parameter is declared on boath reports and is set to same type everywhere It just shows Null
-
Thx Internet was acting up, reloaded page I can see it now
-
What should I use as "_report" Expression ?
The Tree my reports are in is "Root/NWU/CurriculumManagement/APD5/"
-
All I want to do is create a Drill down report from say report "one" to report "two"
I can't find ANY Documentation or examples on how to use Hyperlink Type ReportExecution for Jasperserver
It all seems straight forward but it doesn't work (parameters aren't sent through)
HOW ITS CURRENTLY SETUP:
Target is set to "Self" Type is set to "ReportExecution"
In reference tab I have correct link (it links to drill-down report successfully)
"./flow.html?_flowId=viewReportFlow&reportUnit=%2FNWU%2FStudentInformation%2FCurriculumManagement%2FAPQIBI005drill"
Anchor and page tab is empty (have no Idea what to put here since I cant find any Docs on it)
Link parameters have values in that should work but aren't (double checked everything here many times)
campusAndFaculty | $P{campusAndFaculty}campus | $F{cn_campusname.cn_campusid}
Tooltip Tab is empty
What am I doing wrong ? why aren't the params being sent through ?
NOTE:
Using Jasperserver-pro 5.0.1 & Using iReport 5.0.0I also know of the sample report (/Reports/Samples/Employee List report.),but our server doesn't have any sample reports
-
I want to send a array of ID's of unknown length through a URL (array can contain anything from 1 to 15 ID's)
MORE DETAILS:
Currently I am sending Parameters through like this
...&date=2012/02/02&VEFactorSelection=3&nameType=2
This works fine for Variables that can only have a single value (String, Int, Date etc.)
But I now need to send a array through and be able to read it again
How do I do this?
MORE INFO: The data is being sent from one report to the drill down report (JasperReports Server 5.0.1)
I'm using iReport 5.0.0 for reports creation
-
Is there a applicationContext-cas-security.xml file in Clean (Default) Jasperserver ?
I Can't seem to find it...
-
Don't Know if this will help but check it out
http://blog.seyfi.net/2012/01/how-to-cas-enable-jasperserver-in-5.html?showComment=1373538017138
Also new to Jasperserver and have been stuck with the integration of CAS with Jasperserver.
Let me know if you find any deatailed Guides out there to do this
Hope the link helps -
Ok so When a user creates a Ad-Hoc report, it will bring back data from All languages (Yes I know the user can manually filter by language)
I need to change the jasper code so that the Ad-Hoc view will automatically only show data according to logged in language
So if you are logged in, in English and create a Ad-Hoc view, it will only bring back English data
Note: The database is setup so that I can just use
Where language_id = 3-- 3 = English (this will change depending on logged in language)
and it will show the correct data for that language
So what I am asking is, how can I change the Jasper-server code so that it automatically filters all Ad-Hoc reports by
Where language_id = logedInLanguageID
-
Thx man, This will definitely work, was just looking for a way to do this in the jasper code, as there is about 400 reports this will have to be added to
-
When I export to xls, it works, but not to CSV
I still want the headers there when viewed as PDF, so they should just be hidden when exporting to CSV
(I know this has to be possible because it works like this for my "export to xls")
-
This works for xls & xlsx , but what will the fix for CSV be ?
-
I want to export to CSV with the Header and Footer only showing once
The current output:Name Address HobbyAAA US XXXXXBBB UK XXXXX
(Footer)Name Address HobbyCCC ID XXXXXDDD CC XXXXX(Footer)Name Address HobbyEEE SA XXXXXFFF ZM XXXXX(Footer)The desired output:Name Address HobbyAAA US XXXXXBBB UK XXXXXCCC ID XXXXXDDD CC XXXXX(Footer)EEE SA XXXXXFFF ZM XXXXX
So how do I get the Header and footer to only show once ?
-
have exactly the same problem Have you found a solution ?
-
Ok so here is my Input Control
Note that the Info in the "Course Group" (Single Select Query) is in English
Here is the Query that gets the data in "Course Group"
- select distinct(cog.cog_id) id, concat(cd.cd_shortdescription, ' (', cn.cn_shortname, ' - ', cog.cog_org_be_id, ' - ', cd_code.cd_code, ')') coursegroup
from es_exam_statistics_ft es, cg_classgroup cg, org_organisation org, cn_campusname cn
, cog_coursegroup cog, cd_codedescription cd, cd_code
where es.es_cg_id = cg.cg_id
and es.es_cog_id = cog.cog_id
and cog.cog_coursegroup_cd_id = cd.cd_id
and cd.cd_id = cd_code.cd_id
and org.org_be_id = cog.cog_org_be_id
and org.org_campusid = cn.cn_campusid
and cg.cg_startdate >= $P{startDate}
and cg.cg_enddate = $P{endDate}
and cd.cd_language_id = 3
and cn.cn_language_id = 3
order by coursegroup
The problem comes with the lines i have Highlighted Red
Language Id's
2 = Afrikaans
3 =English
Now as you can see, the Query is hardcoded so that the language is always english, So if a user logs in, in a different language, the data in the input control will always be English
I tried replacing the 3 with "$P{REPORT_LOCALE}.getDisplayLanguage().equals("English") ? new Integer(3): new Integer(2)"
Which works in the XML of a Report, but doesn't work in the input Controls Query
How do I solve this Issue ? - select distinct(cog.cog_id) id, concat(cd.cd_shortdescription, ' (', cn.cn_shortname, ' - ', cog.cog_org_be_id, ' - ', cd_code.cd_code, ')') coursegroup
when testing for a build I get tomcat errors Apache Software Foundation/Tomcat 7.0/lib does not exist.
in Products
Posted
I have this exact issue, and no idea how to fix it...