BIRT report / combine field from two datasets into one dynamic text box












0















In eclipse Birt report tool, I have two datasets, each return one row.
Then I have a grid, and inside that, I need to combine one field from each dataset into one, and I can't seem to figure out how to do it. Any ideas?



Should look like that:
DS1.Field / DS2.Field



ANy help is appreciated.










share|improve this question



























    0















    In eclipse Birt report tool, I have two datasets, each return one row.
    Then I have a grid, and inside that, I need to combine one field from each dataset into one, and I can't seem to figure out how to do it. Any ideas?



    Should look like that:
    DS1.Field / DS2.Field



    ANy help is appreciated.










    share|improve this question

























      0












      0








      0








      In eclipse Birt report tool, I have two datasets, each return one row.
      Then I have a grid, and inside that, I need to combine one field from each dataset into one, and I can't seem to figure out how to do it. Any ideas?



      Should look like that:
      DS1.Field / DS2.Field



      ANy help is appreciated.










      share|improve this question














      In eclipse Birt report tool, I have two datasets, each return one row.
      Then I have a grid, and inside that, I need to combine one field from each dataset into one, and I can't seem to figure out how to do it. Any ideas?



      Should look like that:
      DS1.Field / DS2.Field



      ANy help is appreciated.







      eclipse birt






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 21 '18 at 16:55









      SteveSteve

      55541735




      55541735
























          1 Answer
          1






          active

          oldest

          votes


















          0














          Assuming that you have access to DS1 inside the grid G.



          You can place a dynamic text item T inside one of G's cells and bind this item T to DS2.



          In the expression builder for T, notice that the category "available column bindings" now shows sub-categrories T and G and that you can insert fields from DS1 and from DS2 into the expression.



          Thus you can write



          row._outer["Field"] + " / " + row["Field"]
          // ^-- = DS1.Field
          // ^-- = DS2.Field





          share|improve this answer
























          • Thank you for the suggestion, the problem I run into is that I need to combine fields in each row from two different datasets. Row1: DS1.Field / DS2.Field Row2: DS3.Field / DS4.Field and so on. That's why I can't bind the grid to just one dataset.

            – Steve
            Nov 23 '18 at 18:59











          • Reconsider your data model. For example, perform the joins with SQL or use a joint data set.

            – hvb
            Dec 6 '18 at 12:13











          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
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53417032%2fbirt-report-combine-field-from-two-datasets-into-one-dynamic-text-box%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









          0














          Assuming that you have access to DS1 inside the grid G.



          You can place a dynamic text item T inside one of G's cells and bind this item T to DS2.



          In the expression builder for T, notice that the category "available column bindings" now shows sub-categrories T and G and that you can insert fields from DS1 and from DS2 into the expression.



          Thus you can write



          row._outer["Field"] + " / " + row["Field"]
          // ^-- = DS1.Field
          // ^-- = DS2.Field





          share|improve this answer
























          • Thank you for the suggestion, the problem I run into is that I need to combine fields in each row from two different datasets. Row1: DS1.Field / DS2.Field Row2: DS3.Field / DS4.Field and so on. That's why I can't bind the grid to just one dataset.

            – Steve
            Nov 23 '18 at 18:59











          • Reconsider your data model. For example, perform the joins with SQL or use a joint data set.

            – hvb
            Dec 6 '18 at 12:13
















          0














          Assuming that you have access to DS1 inside the grid G.



          You can place a dynamic text item T inside one of G's cells and bind this item T to DS2.



          In the expression builder for T, notice that the category "available column bindings" now shows sub-categrories T and G and that you can insert fields from DS1 and from DS2 into the expression.



          Thus you can write



          row._outer["Field"] + " / " + row["Field"]
          // ^-- = DS1.Field
          // ^-- = DS2.Field





          share|improve this answer
























          • Thank you for the suggestion, the problem I run into is that I need to combine fields in each row from two different datasets. Row1: DS1.Field / DS2.Field Row2: DS3.Field / DS4.Field and so on. That's why I can't bind the grid to just one dataset.

            – Steve
            Nov 23 '18 at 18:59











          • Reconsider your data model. For example, perform the joins with SQL or use a joint data set.

            – hvb
            Dec 6 '18 at 12:13














          0












          0








          0







          Assuming that you have access to DS1 inside the grid G.



          You can place a dynamic text item T inside one of G's cells and bind this item T to DS2.



          In the expression builder for T, notice that the category "available column bindings" now shows sub-categrories T and G and that you can insert fields from DS1 and from DS2 into the expression.



          Thus you can write



          row._outer["Field"] + " / " + row["Field"]
          // ^-- = DS1.Field
          // ^-- = DS2.Field





          share|improve this answer













          Assuming that you have access to DS1 inside the grid G.



          You can place a dynamic text item T inside one of G's cells and bind this item T to DS2.



          In the expression builder for T, notice that the category "available column bindings" now shows sub-categrories T and G and that you can insert fields from DS1 and from DS2 into the expression.



          Thus you can write



          row._outer["Field"] + " / " + row["Field"]
          // ^-- = DS1.Field
          // ^-- = DS2.Field






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 23 '18 at 9:05









          hvbhvb

          1,6711610




          1,6711610













          • Thank you for the suggestion, the problem I run into is that I need to combine fields in each row from two different datasets. Row1: DS1.Field / DS2.Field Row2: DS3.Field / DS4.Field and so on. That's why I can't bind the grid to just one dataset.

            – Steve
            Nov 23 '18 at 18:59











          • Reconsider your data model. For example, perform the joins with SQL or use a joint data set.

            – hvb
            Dec 6 '18 at 12:13



















          • Thank you for the suggestion, the problem I run into is that I need to combine fields in each row from two different datasets. Row1: DS1.Field / DS2.Field Row2: DS3.Field / DS4.Field and so on. That's why I can't bind the grid to just one dataset.

            – Steve
            Nov 23 '18 at 18:59











          • Reconsider your data model. For example, perform the joins with SQL or use a joint data set.

            – hvb
            Dec 6 '18 at 12:13

















          Thank you for the suggestion, the problem I run into is that I need to combine fields in each row from two different datasets. Row1: DS1.Field / DS2.Field Row2: DS3.Field / DS4.Field and so on. That's why I can't bind the grid to just one dataset.

          – Steve
          Nov 23 '18 at 18:59





          Thank you for the suggestion, the problem I run into is that I need to combine fields in each row from two different datasets. Row1: DS1.Field / DS2.Field Row2: DS3.Field / DS4.Field and so on. That's why I can't bind the grid to just one dataset.

          – Steve
          Nov 23 '18 at 18:59













          Reconsider your data model. For example, perform the joins with SQL or use a joint data set.

          – hvb
          Dec 6 '18 at 12:13





          Reconsider your data model. For example, perform the joins with SQL or use a joint data set.

          – hvb
          Dec 6 '18 at 12:13




















          draft saved

          draft discarded




















































          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.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53417032%2fbirt-report-combine-field-from-two-datasets-into-one-dynamic-text-box%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







          這個網誌中的熱門文章

          Xamarin.form Move up view when keyboard appear

          Post-Redirect-Get with Spring WebFlux and Thymeleaf

          Anylogic : not able to use stopDelay()