sum for all columns

(2 posts) (2 voices)


No tags yet.

  1. Derek, Member

    hi support
    i have some report which has non-fixed column,for example
    for today,this report has two columns
    for tomorrow,maybe this report has 5 columns

    Is there any solution for this?

    select 'dbr.sum',3,4,5,6,7,8,9?

    so how to caculate sum for all columns

  2. myDBR Team, Key Master

    How does your report query look like? How does it alternate the number of columns it selects?

    You can call 'dbr.sum' as many times as you like. Putting the call in the loop should give you the ability to dynamically select all columns.

    myDBR Team


You must log in to post.