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 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.
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.
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
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.
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.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156