This discussion is archived
5 Replies Latest reply: Feb 1, 2013 7:02 AM by user9976634 RSS

Horizontal overflow

987927 Newbie
Currently Being Moderated
Hi Experts,

I have Xml as shown below.

<DepreciationDtl>
<Depreciation>
<Year>1<\Year>
<Percentage>5<\Percentage>
</Depreciation>
<Depreciation>
<Year>2<\Year>
<Percentage>10<\Percentage>
</Depreciation>
<Depreciation>
<Year>3<\Year>
<Percentage>15<\Percentage>
</Depreciation>
<Depreciation>
<Year>4<\Year>
<Percentage>20<\Percentage>
</Depreciation>
<Depreciation>
<Year>5<\Year>
<Percentage>25<\Percentage>
</Depreciation>
<Depreciation>
<Year>6<\Year>
<Percentage>30<\Percentage>
</Depreciation>
<Depreciation>
<Year>7<\Year>
<Percentage>35<\Percentage>
</Depreciation>
<Depreciation>
<Year>8<\Year>
<Percentage>40<\Percentage>
</Depreciation>
<Depreciation>
<Year>9<\Year>
<Percentage>45<\Percentage>
</Depreciation>
<Depreciation>
<Year>10<\Year>
<Percentage>50<\Percentage>
</Depreciation>
<Depreciation>
<Year>11<\Year>
<Percentage>55<\Percentage>
</Depreciation>
<Depreciation>
<Year>12<\Year>
<Percentage>60<\Percentage>
</Depreciation>
<Depreciation>
<Year>13<\Year>
<Percentage>65<\Percentage>
</Depreciation>
<Depreciation>
<Year>14<\Year>
<Percentage>70<\Percentage>
</Depreciation>
<Depreciation>
<Year>15<\Year>
<Percentage>75<\Percentage>
</Depreciation>
</DepreciationDtl>

Using the XML mentioned above i need to display dynamic table as shown below.

YEAR Dep% YEAR Dep% YEAR Dep%
-------------- -------------- -------------- -------------- -------------- --------------
1 5 2 10 3 15
4 20 5 25 6 30
7 35 8 40 9 45
10 50 11 55 12 60
13 65 14 70 15 75

Can anyone let me know how to make it possible using overflow concept...

Thanks in Advance....
  • 1. Re: Horizontal overflow
    Bryan Burr Newbie
    Currently Being Moderated
    Hi,
    What version of Documaker?
    You say it needs to be dynamic, but do you have a fixed width or fixed height? Maximum number of columns? Your example shows six columns (3 pairs) is this the structure you want with dynamic row counts?
    -DA
  • 2. Re: Horizontal overflow
    RamanC Newbie
    Currently Being Moderated
    Hi,
    I have tried this senario.I have used GroupBegin option funtion as Coulmn Function Parameter as ColCount(3) ColWidth(2400) ColSeparation(300) .
    but i got output like below,

    1 5 6 30 11 65
    2 10 7 35 12 70
    3 15 8 40 13 75
    4 20 9 45 14 80
    5 25 10 50 15 90

    This is not like the order you mentioned. Let me know whether you get the same output as what you mentioned.

    Note: I didnt use overflow concept and i have used only DAL scripting to did this.

    Anyone tried in any other way ?

    Welcome and share your thoughts........

    Regards,
    RAMAN C
  • 3. Re: Horizontal overflow
    987927 Newbie
    Currently Being Moderated
    Hi,

    We are using Documaker 11.5;
    We have the display in six columns(3 pairs)....

    Thanks
  • 4. Re: Horizontal overflow
    Sruthi Newbie
    Currently Being Moderated
    Hi,

    I am not sure about XML extracts. Hope this hint may help. If the data is in flat file something like below, you can code the 6 fields in one section (since it is fixed), with section level overflow selected and Overflow Multipliar as 3. For first pair of Year & Dep%, the Record should be 1. For second pair the Record should be 2 and for third it should be 3. Trigger the section using the regular conditions.

    Datarecord1 1 05
    Datarecord2 2 10
    Datarecord3 3 15
    Datarecord4 4 20
    Datarecord5 5 25
    Datarecord6 6 30
    Datarecord7 7 35
    Datarecord8 8 40
    Datarecord9 9 45
    Datarecord10 10 50
    Datarecord11 11 55
    Datarecord12 12 60
    Datarecord13 13 65
    Datarecord14 14 70
    Datarecord15 15 75

    Thank you,
    Sruthi Jayasimhan
  • 5. Re: Horizontal overflow
    user9976634 Journeyer
    Currently Being Moderated
    It sounds like you have created a "line" or "row" section with the 6 fields (3 sets of 2) on it. That is fine.
    Then you would create a trigger to calculate your total occurrences, divide by 3 (add 1) and then return that as your trigger count. This will get you enough rows for your content.
    Within the "row" section you have, you would add the appropriate xPath or XDD reference to the field rule section. Then review the help on the Overflow and Overflow Multipliers. Essentially, you want the overflow per section and a multiplier of 3 (I think) since you have 3 sets per section.
    Don't just do a search in the help for Overflow because you will see all different kinds that have existed over the years. You want to see the Overflow Multiplier definitions in the Fields section under rules.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points