How to generate mutiple pages with BIRT Report Designer
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I would like to generate multiple page of a report. The number of pages would be defined in a variable from a Data Set.
example: if the variable is set to 5, the report would be generated in 5 copies (1/5, 2/5.. 5/5).
I'm using BIRT Report Designer 4.4.0.
The rest of the report is filled with other data that would stay the same in the n pages.
I managed to show the page number and the total number of pages (the variable) but didn't manage to generate that amount of pages.
I have no clue how to proceed, so until now, I only manage to generate 1 page.
report birt designer
asked Jan 4 at 8:44
SarekSarek
11
add a comment |
I would like to generate multiple page of a report. The number of pages would be defined in a variable from a Data Set.
example: if the variable is set to 5, the report would be generated in 5 copies (1/5, 2/5.. 5/5).
I'm using BIRT Report Designer 4.4.0.
The rest of the report is filled with other data that would stay the same in the n pages.
I managed to show the page number and the total number of pages (the variable) but didn't manage to generate that amount of pages.
I have no clue how to proceed, so until now, I only manage to generate 1 page.
report birt designer
asked Jan 4 at 8:44
SarekSarek
11
add a comment |
I would like to generate multiple page of a report. The number of pages would be defined in a variable from a Data Set.
example: if the variable is set to 5, the report would be generated in 5 copies (1/5, 2/5.. 5/5).
I'm using BIRT Report Designer 4.4.0.
The rest of the report is filled with other data that would stay the same in the n pages.
I managed to show the page number and the total number of pages (the variable) but didn't manage to generate that amount of pages.
I have no clue how to proceed, so until now, I only manage to generate 1 page.
report birt designer
asked Jan 4 at 8:44
SarekSarek
11
I would like to generate multiple page of a report. The number of pages would be defined in a variable from a Data Set.
example: if the variable is set to 5, the report would be generated in 5 copies (1/5, 2/5.. 5/5).
I'm using BIRT Report Designer 4.4.0.
The rest of the report is filled with other data that would stay the same in the n pages.
I managed to show the page number and the total number of pages (the variable) but didn't manage to generate that amount of pages.
I have no clue how to proceed, so until now, I only manage to generate 1 page.
report birt designer
report birt designer
asked Jan 4 at 8:44
SarekSarek
11
asked Jan 4 at 8:44
SarekSarek
11
asked Jan 4 at 8:44
SarekSarek
11
asked Jan 4 at 8:44
SarekSarek
11
asked Jan 4 at 8:44
SarekSarek
11
11
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You can use either a scripted data set or some SQL statement (for e.g. on Oracle something like this)
select rownum from user_objects where rownum <= :pi_num_copies
to create a "for-loop" data set.
answered Jan 7 at 7:41
hvbhvb
1,6711610
add a comment |
I would try the following.
- Insert (into the report) a Table binded to your Data Set with a
single column - your "NumberOfCopies" field. - Add Group for the NumberOfCopies.
- Put your repeating n-times data to the Table Detail (you can replace the original field with it). Add fixed (for
every page) info to Group header and footer. - Set After property to Always in Page Break paramener
section for Group Footer (not for table's one!)
I guess it will work. If not - play around with Page Break options in Table Footer and Detail...
answered Jan 25 at 15:13
Igor PiginIgor Pigin
213
Thanks for your help. I have been playing with Group and Page Break for a few hours. But I don't manage to repeat the group (or the detail row ?) n times. When I add Group for the NumberOfCopies, It only display the NumberOfCopies one time. Is it the Detail Row of the group that should reapet himself n times ? I don't know if I'm clear, I'm not really comfortable with group.
– Sarek
Jan 29 at 12:00
Sorry Sarek, I guess I did not got your question completely. My approach (with Group) will only work if your data set contains N records. Where N is number of pages. The data set should also contain an unique field (eg.: pageNumbers like 1, 2, 3, ...) for use in report Group. Otherwise I have no idea how to generate multiple pages based on a single number of pages. I guess you can do it by using some javascript in the report but...
– Igor Pigin
Jan 29 at 14:56
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%2f54035575%2fhow-to-generate-mutiple-pages-with-birt-report-designer%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can use either a scripted data set or some SQL statement (for e.g. on Oracle something like this)
select rownum from user_objects where rownum <= :pi_num_copies
to create a "for-loop" data set.
answered Jan 7 at 7:41
hvbhvb
1,6711610
add a comment |
You can use either a scripted data set or some SQL statement (for e.g. on Oracle something like this)
select rownum from user_objects where rownum <= :pi_num_copies
to create a "for-loop" data set.
answered Jan 7 at 7:41
hvbhvb
1,6711610
add a comment |
You can use either a scripted data set or some SQL statement (for e.g. on Oracle something like this)
select rownum from user_objects where rownum <= :pi_num_copies
to create a "for-loop" data set.
answered Jan 7 at 7:41
hvbhvb
1,6711610
You can use either a scripted data set or some SQL statement (for e.g. on Oracle something like this)
select rownum from user_objects where rownum <= :pi_num_copies
to create a "for-loop" data set.
answered Jan 7 at 7:41
hvbhvb
1,6711610
answered Jan 7 at 7:41
hvbhvb
1,6711610
answered Jan 7 at 7:41
hvbhvb
1,6711610
answered Jan 7 at 7:41
hvbhvb
1,6711610
1,6711610
add a comment |
add a comment |
I would try the following.
- Insert (into the report) a Table binded to your Data Set with a
single column - your "NumberOfCopies" field. - Add Group for the NumberOfCopies.
- Put your repeating n-times data to the Table Detail (you can replace the original field with it). Add fixed (for
every page) info to Group header and footer. - Set After property to Always in Page Break paramener
section for Group Footer (not for table's one!)
I guess it will work. If not - play around with Page Break options in Table Footer and Detail...
answered Jan 25 at 15:13
Igor PiginIgor Pigin
213
Thanks for your help. I have been playing with Group and Page Break for a few hours. But I don't manage to repeat the group (or the detail row ?) n times. When I add Group for the NumberOfCopies, It only display the NumberOfCopies one time. Is it the Detail Row of the group that should reapet himself n times ? I don't know if I'm clear, I'm not really comfortable with group.
– Sarek
Jan 29 at 12:00
Sorry Sarek, I guess I did not got your question completely. My approach (with Group) will only work if your data set contains N records. Where N is number of pages. The data set should also contain an unique field (eg.: pageNumbers like 1, 2, 3, ...) for use in report Group. Otherwise I have no idea how to generate multiple pages based on a single number of pages. I guess you can do it by using some javascript in the report but...
– Igor Pigin
Jan 29 at 14:56
add a comment |
I would try the following.
- Insert (into the report) a Table binded to your Data Set with a
single column - your "NumberOfCopies" field. - Add Group for the NumberOfCopies.
- Put your repeating n-times data to the Table Detail (you can replace the original field with it). Add fixed (for
every page) info to Group header and footer. - Set After property to Always in Page Break paramener
section for Group Footer (not for table's one!)
I guess it will work. If not - play around with Page Break options in Table Footer and Detail...
answered Jan 25 at 15:13
Igor PiginIgor Pigin
213
Thanks for your help. I have been playing with Group and Page Break for a few hours. But I don't manage to repeat the group (or the detail row ?) n times. When I add Group for the NumberOfCopies, It only display the NumberOfCopies one time. Is it the Detail Row of the group that should reapet himself n times ? I don't know if I'm clear, I'm not really comfortable with group.
– Sarek
Jan 29 at 12:00
Sorry Sarek, I guess I did not got your question completely. My approach (with Group) will only work if your data set contains N records. Where N is number of pages. The data set should also contain an unique field (eg.: pageNumbers like 1, 2, 3, ...) for use in report Group. Otherwise I have no idea how to generate multiple pages based on a single number of pages. I guess you can do it by using some javascript in the report but...
– Igor Pigin
Jan 29 at 14:56
add a comment |
I would try the following.
- Insert (into the report) a Table binded to your Data Set with a
single column - your "NumberOfCopies" field. - Add Group for the NumberOfCopies.
- Put your repeating n-times data to the Table Detail (you can replace the original field with it). Add fixed (for
every page) info to Group header and footer. - Set After property to Always in Page Break paramener
section for Group Footer (not for table's one!)
I guess it will work. If not - play around with Page Break options in Table Footer and Detail...
answered Jan 25 at 15:13
Igor PiginIgor Pigin
213
I would try the following.
- Insert (into the report) a Table binded to your Data Set with a
single column - your "NumberOfCopies" field. - Add Group for the NumberOfCopies.
- Put your repeating n-times data to the Table Detail (you can replace the original field with it). Add fixed (for
every page) info to Group header and footer. - Set After property to Always in Page Break paramener
section for Group Footer (not for table's one!)
I guess it will work. If not - play around with Page Break options in Table Footer and Detail...
answered Jan 25 at 15:13
Igor PiginIgor Pigin
213
answered Jan 25 at 15:13
Igor PiginIgor Pigin
213
answered Jan 25 at 15:13
Igor PiginIgor Pigin
213
answered Jan 25 at 15:13
Igor PiginIgor Pigin
213
213
Thanks for your help. I have been playing with Group and Page Break for a few hours. But I don't manage to repeat the group (or the detail row ?) n times. When I add Group for the NumberOfCopies, It only display the NumberOfCopies one time. Is it the Detail Row of the group that should reapet himself n times ? I don't know if I'm clear, I'm not really comfortable with group.
– Sarek
Jan 29 at 12:00
Sorry Sarek, I guess I did not got your question completely. My approach (with Group) will only work if your data set contains N records. Where N is number of pages. The data set should also contain an unique field (eg.: pageNumbers like 1, 2, 3, ...) for use in report Group. Otherwise I have no idea how to generate multiple pages based on a single number of pages. I guess you can do it by using some javascript in the report but...
– Igor Pigin
Jan 29 at 14:56
add a comment |
Thanks for your help. I have been playing with Group and Page Break for a few hours. But I don't manage to repeat the group (or the detail row ?) n times. When I add Group for the NumberOfCopies, It only display the NumberOfCopies one time. Is it the Detail Row of the group that should reapet himself n times ? I don't know if I'm clear, I'm not really comfortable with group.
– Sarek
Jan 29 at 12:00
Sorry Sarek, I guess I did not got your question completely. My approach (with Group) will only work if your data set contains N records. Where N is number of pages. The data set should also contain an unique field (eg.: pageNumbers like 1, 2, 3, ...) for use in report Group. Otherwise I have no idea how to generate multiple pages based on a single number of pages. I guess you can do it by using some javascript in the report but...
– Igor Pigin
Jan 29 at 14:56
Thanks for your help. I have been playing with Group and Page Break for a few hours. But I don't manage to repeat the group (or the detail row ?) n times. When I add Group for the NumberOfCopies, It only display the NumberOfCopies one time. Is it the Detail Row of the group that should reapet himself n times ? I don't know if I'm clear, I'm not really comfortable with group.
– Sarek
Jan 29 at 12:00
Thanks for your help. I have been playing with Group and Page Break for a few hours. But I don't manage to repeat the group (or the detail row ?) n times. When I add Group for the NumberOfCopies, It only display the NumberOfCopies one time. Is it the Detail Row of the group that should reapet himself n times ? I don't know if I'm clear, I'm not really comfortable with group.
– Sarek
Jan 29 at 12:00
Sorry Sarek, I guess I did not got your question completely. My approach (with Group) will only work if your data set contains N records. Where N is number of pages. The data set should also contain an unique field (eg.: pageNumbers like 1, 2, 3, ...) for use in report Group. Otherwise I have no idea how to generate multiple pages based on a single number of pages. I guess you can do it by using some javascript in the report but...
– Igor Pigin
Jan 29 at 14:56
Sorry Sarek, I guess I did not got your question completely. My approach (with Group) will only work if your data set contains N records. Where N is number of pages. The data set should also contain an unique field (eg.: pageNumbers like 1, 2, 3, ...) for use in report Group. Otherwise I have no idea how to generate multiple pages based on a single number of pages. I guess you can do it by using some javascript in the report but...
– Igor Pigin
Jan 29 at 14:56
add a comment |
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%2f54035575%2fhow-to-generate-mutiple-pages-with-birt-report-designer%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
