Page footer - binding textbox to a bandedlist group dataset value

Posted by: ricardo.pereira on 7 September 2020, 2:39 am EST

    • Post Options:
    • Link

    Posted 7 September 2020, 2:39 am EST

    Hi,

    Context:

    We have an RDLX report with a single bandedlist with only one group definition. That banded list has a header and a footer both with fixed heights, but the details section height is dynamic depending on the data that was retrieved and grouped.

    Sometimes we might end up with the bandedlist taking almost the entire report page but sometimes it only takes half of it.

    We also have a page footer which displays the time on the left and the number of pages on the right.

    Doubt/Issue:

    Imagine the scenario where we run a report that retrieves 10 pages each with their distinct grouped data. Now we want to add a textbox to each page footer populating it with one value from the bandedlist group so we can obtain distinct values per page.

    Currently if I reference the field name I only the get the value from the first group/page. So I end up with duplicated values on the rest of the page footers. I also found this post https://www.grapecity.com/forums/ar-dev/populated-text-box-in-foot and tried the parameters solution but the I got the same result (only binds the first value, ignoring the rest).

    Is there any way to achieve this?

    Best Regards,

    Ricardo Pereira

  • Posted 7 September 2020, 11:53 pm EST

    Hello,

    You can drop the group field in the Detail section of the BandedList and make it hidden. After that use the value of this TextBox in the PageFooter as shown in the attached report.

    Hope it helps.

    Thanks,

    Mohit

    Untitled (2).zip

  • Posted 8 September 2020, 12:42 am EST

    Hi Mohit,

    Thank you very much. It worked perfectly!

    Best regards,

    Ricardo Pereira

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels