Acumatica:Tabular Report generates unexpected lines when calling as sub report
Using Acumatica report designer, I've designed a tabular report to fetch one field from SOShiplinesplit.The report's main parameters are RefNbr and ShipLineNbr. If run the tabular report individually, for 1 doc's 1 shipline，its result looks like below:
Tabular Report results when running individually
However, if I add this tabular as a subreport like below,
Add Tabular report as a subreport at ShiplineNbr group level
I met with confusing results if I run the master report to call tabular report
Run within master report
Could anyone give me a hand to get out of this trouble?
report acumatica tabular
edited Nov 10 at 14:16
mehrdad-pedramfar
4,36111235
asked Nov 10 at 14:14
Michael Wang
54
add a comment |
Using Acumatica report designer, I've designed a tabular report to fetch one field from SOShiplinesplit.The report's main parameters are RefNbr and ShipLineNbr. If run the tabular report individually, for 1 doc's 1 shipline，its result looks like below:
Tabular Report results when running individually
However, if I add this tabular as a subreport like below,
Add Tabular report as a subreport at ShiplineNbr group level
I met with confusing results if I run the master report to call tabular report
Run within master report
Could anyone give me a hand to get out of this trouble?
report acumatica tabular
edited Nov 10 at 14:16
mehrdad-pedramfar
4,36111235
asked Nov 10 at 14:14
Michael Wang
54
This answer mentions using the TabularFreeze property to solve that issue: stackoverflow.com/questions/26551488/…
– HB_ACUMATICA
Nov 12 at 15:13
Hello, I looked and studied this post carefully before I posted my own question. It looks like something is wrong with the calling mechnism. In tabular report, if I set the layout [SOShipLineSplit.SplitLineNbr] "The red line" [SOShipLineSplit.Qty] in top group header, when passed parameter shiplineNbr=9 to it, it just executed 1 time with only the first SplitLineNbr displayed. If run within the master report, all the shipsplitLineNbr under shiplineNbr be displayed. Did I explain clearly? If not, could you reach me at michael.wang@orderock.com, or give me one possible way to send you my rpx
– Michael Wang
Nov 13 at 7:03
You can open the rpx with a text editor and copy the content in your questions.
– HB_ACUMATICA
Nov 14 at 17:01
Unfortunatly, even if I have cut the rpx to minmum, it still over the charaters limitations. So would you mind fetching my rpx at drive.google.com/drive/folders/…
– Michael Wang
Nov 15 at 6:10
add a comment |
Using Acumatica report designer, I've designed a tabular report to fetch one field from SOShiplinesplit.The report's main parameters are RefNbr and ShipLineNbr. If run the tabular report individually, for 1 doc's 1 shipline，its result looks like below:
Tabular Report results when running individually
However, if I add this tabular as a subreport like below,
Add Tabular report as a subreport at ShiplineNbr group level
I met with confusing results if I run the master report to call tabular report
Run within master report
Could anyone give me a hand to get out of this trouble?
report acumatica tabular
edited Nov 10 at 14:16
mehrdad-pedramfar
4,36111235
asked Nov 10 at 14:14
Michael Wang
54
Using Acumatica report designer, I've designed a tabular report to fetch one field from SOShiplinesplit.The report's main parameters are RefNbr and ShipLineNbr. If run the tabular report individually, for 1 doc's 1 shipline，its result looks like below:
Tabular Report results when running individually
However, if I add this tabular as a subreport like below,
Add Tabular report as a subreport at ShiplineNbr group level
I met with confusing results if I run the master report to call tabular report
Run within master report
Could anyone give me a hand to get out of this trouble?
report acumatica tabular
report acumatica tabular
edited Nov 10 at 14:16
mehrdad-pedramfar
4,36111235
asked Nov 10 at 14:14
Michael Wang
54
edited Nov 10 at 14:16
mehrdad-pedramfar
4,36111235
asked Nov 10 at 14:14
Michael Wang
54
edited Nov 10 at 14:16
mehrdad-pedramfar
4,36111235
edited Nov 10 at 14:16
mehrdad-pedramfar
4,36111235
edited Nov 10 at 14:16
mehrdad-pedramfar
4,36111235
4,36111235
asked Nov 10 at 14:14
Michael Wang
54
asked Nov 10 at 14:14
Michael Wang
54
asked Nov 10 at 14:14
Michael Wang
54
54
This answer mentions using the TabularFreeze property to solve that issue: stackoverflow.com/questions/26551488/…
– HB_ACUMATICA
Nov 12 at 15:13
Hello, I looked and studied this post carefully before I posted my own question. It looks like something is wrong with the calling mechnism. In tabular report, if I set the layout [SOShipLineSplit.SplitLineNbr] "The red line" [SOShipLineSplit.Qty] in top group header, when passed parameter shiplineNbr=9 to it, it just executed 1 time with only the first SplitLineNbr displayed. If run within the master report, all the shipsplitLineNbr under shiplineNbr be displayed. Did I explain clearly? If not, could you reach me at michael.wang@orderock.com, or give me one possible way to send you my rpx
– Michael Wang
Nov 13 at 7:03
You can open the rpx with a text editor and copy the content in your questions.
– HB_ACUMATICA
Nov 14 at 17:01
Unfortunatly, even if I have cut the rpx to minmum, it still over the charaters limitations. So would you mind fetching my rpx at drive.google.com/drive/folders/…
– Michael Wang
Nov 15 at 6:10
add a comment |
This answer mentions using the TabularFreeze property to solve that issue: stackoverflow.com/questions/26551488/…
– HB_ACUMATICA
Nov 12 at 15:13
Hello, I looked and studied this post carefully before I posted my own question. It looks like something is wrong with the calling mechnism. In tabular report, if I set the layout [SOShipLineSplit.SplitLineNbr] "The red line" [SOShipLineSplit.Qty] in top group header, when passed parameter shiplineNbr=9 to it, it just executed 1 time with only the first SplitLineNbr displayed. If run within the master report, all the shipsplitLineNbr under shiplineNbr be displayed. Did I explain clearly? If not, could you reach me at michael.wang@orderock.com, or give me one possible way to send you my rpx
– Michael Wang
Nov 13 at 7:03
You can open the rpx with a text editor and copy the content in your questions.
– HB_ACUMATICA
Nov 14 at 17:01
Unfortunatly, even if I have cut the rpx to minmum, it still over the charaters limitations. So would you mind fetching my rpx at drive.google.com/drive/folders/…
– Michael Wang
Nov 15 at 6:10
This answer mentions using the TabularFreeze property to solve that issue: stackoverflow.com/questions/26551488/…
– HB_ACUMATICA
Nov 12 at 15:13
This answer mentions using the TabularFreeze property to solve that issue: stackoverflow.com/questions/26551488/…
– HB_ACUMATICA
Nov 12 at 15:13
Hello, I looked and studied this post carefully before I posted my own question. It looks like something is wrong with the calling mechnism. In tabular report, if I set the layout [SOShipLineSplit.SplitLineNbr] "The red line" [SOShipLineSplit.Qty] in top group header, when passed parameter shiplineNbr=9 to it, it just executed 1 time with only the first SplitLineNbr displayed. If run within the master report, all the shipsplitLineNbr under shiplineNbr be displayed. Did I explain clearly? If not, could you reach me at michael.wang@orderock.com, or give me one possible way to send you my rpx
– Michael Wang
Nov 13 at 7:03
Hello, I looked and studied this post carefully before I posted my own question. It looks like something is wrong with the calling mechnism. In tabular report, if I set the layout [SOShipLineSplit.SplitLineNbr] "The red line" [SOShipLineSplit.Qty] in top group header, when passed parameter shiplineNbr=9 to it, it just executed 1 time with only the first SplitLineNbr displayed. If run within the master report, all the shipsplitLineNbr under shiplineNbr be displayed. Did I explain clearly? If not, could you reach me at michael.wang@orderock.com, or give me one possible way to send you my rpx
– Michael Wang
Nov 13 at 7:03
You can open the rpx with a text editor and copy the content in your questions.
– HB_ACUMATICA
Nov 14 at 17:01
You can open the rpx with a text editor and copy the content in your questions.
– HB_ACUMATICA
Nov 14 at 17:01
Unfortunatly, even if I have cut the rpx to minmum, it still over the charaters limitations. So would you mind fetching my rpx at drive.google.com/drive/folders/…
– Michael Wang
Nov 15 at 6:10
Unfortunatly, even if I have cut the rpx to minmum, it still over the charaters limitations. So would you mind fetching my rpx at drive.google.com/drive/folders/…
– Michael Wang
Nov 15 at 6:10
add a comment |
active
oldest
votes
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%2f53239823%2facumaticatabular-report-generates-unexpected-lines-when-calling-as-sub-report%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53239823%2facumaticatabular-report-generates-unexpected-lines-when-calling-as-sub-report%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
This answer mentions using the TabularFreeze property to solve that issue: stackoverflow.com/questions/26551488/…
– HB_ACUMATICA
Nov 12 at 15:13
Hello, I looked and studied this post carefully before I posted my own question. It looks like something is wrong with the calling mechnism. In tabular report, if I set the layout [SOShipLineSplit.SplitLineNbr] "The red line" [SOShipLineSplit.Qty] in top group header, when passed parameter shiplineNbr=9 to it, it just executed 1 time with only the first SplitLineNbr displayed. If run within the master report, all the shipsplitLineNbr under shiplineNbr be displayed. Did I explain clearly? If not, could you reach me at michael.wang@orderock.com, or give me one possible way to send you my rpx
– Michael Wang
Nov 13 at 7:03
You can open the rpx with a text editor and copy the content in your questions.
– HB_ACUMATICA
Nov 14 at 17:01
Unfortunatly, even if I have cut the rpx to minmum, it still over the charaters limitations. So would you mind fetching my rpx at drive.google.com/drive/folders/…
– Michael Wang
Nov 15 at 6:10