How to create iReport with two different data source of Main and SubreportHow can I concatenate two arrays in Java?How can I create an executable JAR with dependencies using Maven?How do I create a file and write to it in Java?iReport subreport return valueHow to pass main report data source to subreport (JasperReports)?How to add subreports to the main report while creating a pdf in JasperReports (iReport)iReport/JasperReports Server: Subreport return value nulljasperReport/iReport subreport shows blank (not displayed)subreport using iReport toolCreating Subreport within list in iReport
Supporting developers who insist on using their pet language
How do I write a romance that doesn't look obvious
What are some symbols representing peasants/oppressed persons fighting back?
Was adding milk to tea started to reduce employee tea break time?
What is the German equivalent of 干物女 (dried fish woman)?
How might the United Kingdom become a republic?
Doing research in academia and not liking competition
Too many spies!
Draw 3D Cubes around centre
Why does the autopilot disengage even when it does not receive pilot input?
Can I intentionally omit previous work experience or pretend it doesn't exist when applying for jobs?
Ambiguous sentences: How to tell when they need fixing?
Chaining Dissonant Whispers via War Caster feat
Can anybody provide any information about this equation?
Won 50K! Now what should I do with it
Why does java.time.Period#normalized() not normalize days?
How do Windows version numbers work?
Do native speakers use ZVE or CPU?
Pre-1968 YA science fiction novel: robot with black-and-white vision, later the robot could see in color
Filtering fine silt/mud from water (not necessarily bacteria etc.)
nginx serves wrong domain site. It doenst shows default site if no configuration applies
Data standardization vs. normalization for clustering analysis
I quit, and boss offered me 3 month "grace period" where I could still come back
Bob's unnecessary trip to the shops
How to create iReport with two different data source of Main and Subreport
How can I concatenate two arrays in Java?How can I create an executable JAR with dependencies using Maven?How do I create a file and write to it in Java?iReport subreport return valueHow to pass main report data source to subreport (JasperReports)?How to add subreports to the main report while creating a pdf in JasperReports (iReport)iReport/JasperReports Server: Subreport return value nulljasperReport/iReport subreport shows blank (not displayed)subreport using iReport toolCreating Subreport within list in iReport
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I need to create a report combining data from SQL server and from PostgreSQL. I was already looking for tutorials online but got no help.
I already have created before reports with multiple subreports but using only one data source. But never done multiple data source.
java netbeans ireport subreport
asked Mar 26 at 5:57
Jerson CalinawanJerson Calinawan
241 gold badge1 silver badge7 bronze badges
add a comment |
I need to create a report combining data from SQL server and from PostgreSQL. I was already looking for tutorials online but got no help.
I already have created before reports with multiple subreports but using only one data source. But never done multiple data source.
java netbeans ireport subreport
asked Mar 26 at 5:57
Jerson CalinawanJerson Calinawan
241 gold badge1 silver badge7 bronze badges
add a comment |
I need to create a report combining data from SQL server and from PostgreSQL. I was already looking for tutorials online but got no help.
I already have created before reports with multiple subreports but using only one data source. But never done multiple data source.
java netbeans ireport subreport
asked Mar 26 at 5:57
Jerson CalinawanJerson Calinawan
241 gold badge1 silver badge7 bronze badges
I need to create a report combining data from SQL server and from PostgreSQL. I was already looking for tutorials online but got no help.
I already have created before reports with multiple subreports but using only one data source. But never done multiple data source.
java netbeans ireport subreport
java netbeans ireport subreport
asked Mar 26 at 5:57
Jerson CalinawanJerson Calinawan
241 gold badge1 silver badge7 bronze badges
asked Mar 26 at 5:57
Jerson CalinawanJerson Calinawan
241 gold badge1 silver badge7 bronze badges
asked Mar 26 at 5:57
Jerson CalinawanJerson Calinawan
241 gold badge1 silver badge7 bronze badges
asked Mar 26 at 5:57
Jerson CalinawanJerson Calinawan
241 gold badge1 silver badge7 bronze badges
asked Mar 26 at 5:57
Jerson CalinawanJerson Calinawan
241 gold badge1 silver badge7 bronze badges
241 gold badge1 silver badge7 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You can create Map of parameters and put sql in map, then send parameters to report.
sql could be created from any data base
Map parameters = new HashMap();
parameters.put("SQL_INPUT", sql);
JasperFillManager.fillReport(reportFile.getPath(), parameters, connection);
in report
you create parameter with name SQL_INPUT
and replace query with $P!SQL_INPUT
answered Mar 26 at 6:25
Ramzi WaselRamzi Wasel
1
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55350676%2fhow-to-create-ireport-with-two-different-data-source-of-main-and-subreport%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can create Map of parameters and put sql in map, then send parameters to report.
sql could be created from any data base
Map parameters = new HashMap();
parameters.put("SQL_INPUT", sql);
JasperFillManager.fillReport(reportFile.getPath(), parameters, connection);
in report
you create parameter with name SQL_INPUT
and replace query with $P!SQL_INPUT
answered Mar 26 at 6:25
Ramzi WaselRamzi Wasel
1
add a comment |
You can create Map of parameters and put sql in map, then send parameters to report.
sql could be created from any data base
Map parameters = new HashMap();
parameters.put("SQL_INPUT", sql);
JasperFillManager.fillReport(reportFile.getPath(), parameters, connection);
in report
you create parameter with name SQL_INPUT
and replace query with $P!SQL_INPUT
answered Mar 26 at 6:25
Ramzi WaselRamzi Wasel
1
add a comment |
You can create Map of parameters and put sql in map, then send parameters to report.
sql could be created from any data base
Map parameters = new HashMap();
parameters.put("SQL_INPUT", sql);
JasperFillManager.fillReport(reportFile.getPath(), parameters, connection);
in report
you create parameter with name SQL_INPUT
and replace query with $P!SQL_INPUT
answered Mar 26 at 6:25
Ramzi WaselRamzi Wasel
1
You can create Map of parameters and put sql in map, then send parameters to report.
sql could be created from any data base
Map parameters = new HashMap();
parameters.put("SQL_INPUT", sql);
JasperFillManager.fillReport(reportFile.getPath(), parameters, connection);
in report
you create parameter with name SQL_INPUT
and replace query with $P!SQL_INPUT
answered Mar 26 at 6:25
Ramzi WaselRamzi Wasel
1
answered Mar 26 at 6:25
Ramzi WaselRamzi Wasel
1
answered Mar 26 at 6:25
Ramzi WaselRamzi Wasel
1
answered Mar 26 at 6:25
Ramzi WaselRamzi Wasel
1
1
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55350676%2fhow-to-create-ireport-with-two-different-data-source-of-main-and-subreport%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
