Acumatica:Tabular Report generates unexpected lines when calling as sub report









up vote
0
down vote

favorite












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







share|improve this question























  • 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
    2 days ago










  • 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
    yesterday














up vote
0
down vote

favorite












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







share|improve this question























  • 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
    2 days ago










  • 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
    yesterday












up vote
0
down vote

favorite









up vote
0
down vote

favorite











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







share|improve this question















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 10 at 14:16









mehrdad-pedramfar

3,44011232




3,44011232










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
    2 days ago










  • 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
    yesterday
















  • 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
    2 days ago










  • 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
    yesterday















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
2 days ago




You can open the rpx with a text editor and copy the content in your questions.
– HB_ACUMATICA
2 days ago












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
yesterday




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
yesterday

















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',
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
);



);













 

draft saved


draft discarded


















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















 

draft saved


draft discarded















































 


draft saved


draft discarded














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





















































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







-

這個網誌中的熱門文章

What does pagestruct do in Eviews?

圖片
0 I have a panel data with column name dateid and an ID variable crossid and several other variables over a period of time. What does the following command do in Eviews (I am very new to Eviews) pagestruct crossid @date(dateid) structure eviews share | improve this question edited Nov 12 at 4:19 asked Nov 8 at 9:13 Dom Jo 42 6 add a comment  |  0 I have a panel data with column name dateid and an ID variable crossid and several other variables over a period of time. What does the following command do in Eviews (I am very new to Eviews) pagestruct crossid @date(dateid) structure eviews share | improve this question edited Nov 12 at 4:19 asked Nov 8 at 9:13 Dom Jo 42 6 add a comment  |  0 0 0 I have a panel data with column name dateid and an ID variable crossid and several other variables over a period of time. Wh...
閱讀完整內容

Dutch intervention in Lombok and Karangasem

圖片
Dutch intervention in Lombok and Karangasem (1894) Attack of the Dutch on a Balinese stronghold in Lombok in 1894. Date July–November 1894 Location Lombok Result Decisive Dutch victory. Dutch control of Lombok and Karangasem. Belligerents Netherlands Eastern Sasak Lombok Mataram Western Sasak Commanders and leaders General-Major Jacobus Augustinus Vetter (Commander) General-Major P.P.H. van Ham (Second in command)   † Strength 2,200 (July expedition) Casualties and losses 500 (August 1894) 166 (November 1894) Thousands v t e Dutch interventions in Bali Northern Bali (1846) Northern Bali (1848) Bali (1849) Lombok and Karangasem (1894) Southern Bali (1906) Southern Bali (1908) v t e Dutch colonial campaigns 17th Century Bantam (1601) Malacca (1606) Cape Rachado (1606) Banda Islands (1621) Macau (1622) Pescadores (1622–1624) Bahia (1624) Persian Gulf (1625) Elmina (1625) Cuba (1628) Recife (1630) Albrolhos (1631) Liaoluo Bay (1633) Taiwan (1635–36) Lamey...
閱讀完整內容

Channel Islands

圖片
This article is about the Crown dependencies. For the islands off Southern California, see Channel Islands (California). For the French Channel Islands, see Chausey. Channel Islands Îles Anglo-Normandes    (French) Îles d'la Manche    (Norman) Satellite photo of the Channel Islands in 2012 Location of the Channel Islands Geography Location Western Europe Coordinates 49°26′N 2°19′W  /  49.433°N 2.317°W  / 49.433; -2.317 Coordinates: 49°26′N 2°19′W  /  49.433°N 2.317°W  / 49.433; -2.317 Adjacent bodies of water English Channel Total islands 8 inhabited Major islands Jersey and Guernsey Area 198 km 2 (76 sq mi) Highest point Les Platons Administration Bailiwick of Guernsey Capital and largest settlement Saint Peter Port, Guernsey Area covered 78 km 2 (30 sq mi;  7001394000000000000♠ 39.4%) Bailiwick ...
閱讀完整內容