3 Replies Latest reply on Oct 18, 2016 12:01 PM by Thomas Dodds

    Repeating sections using views in Answers

    Morten_J

      Hello,

       

      I`m having trouble understanding how I can solve these requirements for a report in Answers (BICS).

      Does anyone have a suggestion?

       

      The dashboard should be like this:

       

      DASHBOARD PROMPTS - this is fine

       

      HEADER - valid for all subsequent data. Created an narrative view showing only 1 record, this should be fine.

       

      Customer: John Doe    Address: Street 1

       

      Now the problems start, each account should be listed with all information:

       

      ACCOUNTS

       

      ......................................................................................

       

      Account

      <narrative view>

      Account number: 111.222.333               Balance:  555$

      Account started date: 05-JUL-14           Interest: 3.6%

       

      Withdrawals

      <table view>

       

      Date               Withdrawn Amount

      01-SEP-16      34$

                             45$

      04-SEP-16      22$

                             11$

       

      Deposits

      <table view>

       

      Date              Deposited Amount

      01-JUL-16     3445$

      04-SEP-16     5645$

       

      .......................................................................................

       

      Account

      <narrative view>

      Account number: 333.4444.5555       Balance: 444$

      Account started date: 05-JAN-10       Interest: 3.6%

       

      Withdrawals

      <table view>

       

      Date               Withdrawn Amount

      01-SEP-16     34$

                            45$

      04-SEP-16     22$

                            11$

       

      Deposits

      <table view>

       

      Date               Deposited Amount

      01-SEP-16     3333$

      04-SEP-16     5645$

      ....................................................................................

       

      All information for one account is shown, then info for the next and so on.

      The

       

      Account <narrative view>

      Withdrawals<table view>

      Deposits<table view>

       

      needs to be in one repeating section, breaking on account number.

       

      How can the three views be grouped together to show all info for one account, and repeat for next account?

      Is there some other technique I can use to get the desired layout?

       

      Thanks,

      Morten