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

manshack_one

Members
  • Posts

    177
  • Joined

  • Last visited

Community Answers

  1. manshack_one's post in How to pass string into $X{IN} using URL? was marked as the answer   
    I switched to using $P!{} and passed in a literal "(1,2,3)" in my URL and used a string input control on Server and changed my report query to something like "where r.attendee IN $P!{parameter_name}" and it works fine now.  
     
    Thanks for the reponses regardless.
  2. manshack_one's post in How can I use multiples selects from differents tables withou any combination? was marked as the answer   
    With JasperReports you only get to run one query per report.  Exceptions to that would be subreport elements or writing the selects in code and adding a bean to the report to run it.  I generally find it's easier to build my query using a query editor outside of JasperStudio and view my results there.  Once I know I can build one query to pull everything together into one large dataset then I'll move it to JasperStudio and copy the query in.  Then you can decide what you're going to filter on or group.
     
    Hopefully that makes sense.
  3. manshack_one's post in passing url parameters and returning a pdf was marked as the answer   
    I always seem to answer my own questions.  :)
    You have to turn off "Always Prompt" in the input control or else the URL method will always display the input control screen in Jasperserver.  Here's my url:
    http://192.168.200.51:8081/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/HEALTH/HCD-HTN&standAlone=true&ParentFolderUri=/reports/HEALTH&j_username=HCD&j_password=health&output=pdf&begindate=20091014000000&enddate=20091031000000
    Aside from turning off that option you have to format your date like a timestamp.  I'm using mysql so adding 6 0's at the end worked fine.  The link will now directly bring back the pdf without the user seeing the jasper server screen.
  4. manshack_one's post in Error opening new Job was marked as the answer   
    It's a bug.  Create the project and job without spaces in the name.  I'm up and working now.
×
×
  • Create New...