Notifications
Announcements
No record found.
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.
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.
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.
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
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.
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/
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 559 Most Valuable Professional
André Arnaud de Cal... 464 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
