wesleywj2
-
Posts
6 -
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
Everything posted by wesleywj2
-
hi there, the problem if i understood correctly, open up your subreport property; switch to 3rd tab call "subReport(other)" provide the valid subreport path to the expression. and below you create a new variable and will prompt out another mini window, put any name for variable and pass the $P{REPORT_CONNECTION} into the expression. then in your subreport create a new parameter which reference the variable you created earlier with same name & data type. to view sample and wanna find out more on JRXmlDataSource function, i suggest you to download the jasperreport projects, inside would have all the jrxml for your reference,jasper API documentation as well as the in-memory database. finally, jasper offer quite a number of export options to different format and by default it comes prepackaged with the report viewer which is also a java app.
-
thks for the reply giulio, on the oracle stored procedure, will the upcoming version include the query executor as well? again thks
-
thks for the reply giulio, on the oracle stored procedure, will the upcoming version include the query executor as well? again thks
-
as posted by David Karnowski, that method can actually work but your problems seems to be on the java application side where you're unsure how to pass the parameter. to pass parameter from java app into jasper/ireport, pass it as hashmap. define a key say "P_ID", and pass the whole intended parameter required; (in your case the string). From iReport retrieve it using the "P_ID" key, cast it as String object and concatenate it into your query.
-
if i assumed correctly, you should be using crosstabs to do the job. crosstabs provide the solution by dynamically append the number of columns available from your database's record count. try explore with the crosstabs.
-
Dear everyone, hello everyone, i've looked through posted sp(stored porcedure )topic and found out that majority stated that the current ireport does not fully support sp by calling it from within iReport's query window. I've attempt to test it by using postgres db's (simple)sp and ireport call it successfully. As opposed by majority said it's not fully supported yet, i'm confused by comparing it with my test result. so my questions are: 1. which db's sp not support/support by ireport? 2. if not supported on current version, when likely will it be available? thanks in advance and wish to hear from anyone who can provide me an answer and this will be very appreciated. regards, Wesley
