Jump to content
We've recently updated our Privacy Statement, available here ×

andre.erasmus

Members
  • 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

  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

  2. 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.0

    I also know of the sample report (/Reports/Samples/Employee List report.),but our server doesn't have any sample reports

     

  3. 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

     

  4. 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

     

  5. I want to export to CSV with the Header and Footer only showing once

    The current output
    :
    Name   Address Hobby
    AAA    US      XXXXX
    BBB    UK      XXXXX
    (Footer)
    Name   Address Hobby
    CCC    ID      XXXXX
    DDD    CC      XXXXX
    (Footer)
    Name   Address Hobby
    EEE    SA      XXXXX
    FFF    ZM      XXXXX
    (Footer)
     
    The desired output:
    Name   Address Hobby
    AAA    US      XXXXX
    BBB    UK      XXXXX
    CCC    ID      XXXXX
    DDD    CC      XXXXX
    EEE    SA      XXXXX
    FFF    ZM      XXXXX
    (Footer)
     
    So how do I get the Header and footer to only show once ?


     
     
  6. Ok so here is my Input Control

    inputcontrole(1).png.d668e2c20b52dbfd31b1e00659053ebf.png

    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 ?

     

×
×
  • Create New...