Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Changing labels of temporary table fields in report at runtime.

(0) ShareShare
ReportReport
Posted on by 212

Hi,

I have a temp table in which I have an EDT field named RealBaseCopy. I have added 39 elements in Real Base Copy. Now my requirement is that I should be able to change the label of these elements when the RealBaseCopy EDT is added to the report in precision design dynamically. The label of the first element should be monday's date (05/22/2023) of the current week. The label of the 2nd element should be the monday's date (05/29/2023) of the next week and so on. I want to set these labels dynamically.

Please help me achieve this.

Thanks.

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Changing labels of temporary table fields in report at runtime.

    I think Array elements on EDT won't work here. You need to create as a field in temp table and add that field as column group so it will show as heading with details below.

    Refer to this below blog for understanding column grouping.

    https://www.tutorialgateway.org/grouping-in-ssrs-matrix-reports/

    Thanks,

    Girish S.

  • Dynamics365Admin Profile Picture
    Dynamics365Admin 212 on at
    RE: Changing labels of temporary table fields in report at runtime.

    Thanks Vishal for your response.

    Currently I do not have any form. By form control, do u mean I create a new form and add the temp table as form data source and then create a grid control and set the tmp table as its data source? I do not have a form. I only have a temp table, a contract class, a DP class and a report. How do I grab the form control since there is none. My requirement is to change the label of the field in the report dynamically at runtime.

    Regards.

  • Dynamics365Admin Profile Picture
    Dynamics365Admin 212 on at
    RE: Changing labels of temporary table fields in report at runtime.

    Thanks Girish for you response.

    Could you please elaborate on how to use column grouping in ssrs report and how column grouping would help in achieving dynamics labels for temp table fields.

    Regards

  • Suggested answer
    Vishals786 Profile Picture
    Vishals786 on at
    RE: Changing labels of temporary table fields in report at runtime.

    Hi ,

    You can create a form control and set the Auto declaration property to Yes for the control you need to change. Then you can change the labels by pointing towards the control name and call the label() method. Store this value in a temp table and then use it in your DP class.

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Changing labels of temporary table fields in report at runtime.

    Hi,

    I think you can go for column-based grouping in SSRS report design. Add that EDT field to the column grouping and see if helps your scenario.

    Thanks,

    Girish S.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans