How to rename newly added column automatically in ssrs without opening report

Question

Hi All,

     I have designed a Matrix report which is displaying the all columns(Ex:ss,dd,ff,gg,hh) dynamically from the table(Ex: Table A). I have added new column(JJ) to the table (Table A),which is also displaying in report while executing. I have renamed all available columns(Ex:ss,dd,ff,gg,hh) in table as follow:

=Switch(Fields!TransactionType.Value = "SS","ss",
Fields!TransactionType.Value = "DD","dd",
Fields!TransactionType.Value = "FF","ff",
Fields!TransactionType.Value = "GG","gg",

Fields!TransactionType.Value = "GG","hh"

)

 But If i add any new column like 'JJ' how to rename that column automatically without opening report and writing expression as below manually.

Fields!TransactionType.Value = "JJ","jj"

Is this possible through SSRS ?

Thanks in advance,

Visu

Answer 1

Hello,

not understood your Isuse exactly. If you don't want to open the report then handle it in SQL .Name it as it as you want in report.

---

blog:My Blog/

Hope this will help you !!!
Sanjeewan

Answer 2

Thanks for reply Sanjeewan,

    I tried through SQL its working but i want to do that through report. I am using Matrix report. If i use above expressions i am able to rename because those are known columns from table But If any new column added it is coming as Blank(No name displaying in report). If i open the report and added newly added column in expression(Ex:Fields!TransactionType.Value = "JJ","jj") it is coming in report with header "jj" but i want to handle it automatically without opening report.

Answer 3

Hello,

In my point of view every columns you will add in future have some name . In that case you have to handle it somewhere either in report or in SQL .

for value which does not have any name then you can check =IIF(Fields!ABC.Value)=Nothing,"NA",Fields!ABC.Value)

or every time you want lower to upper case

see this thread

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/72f8f04b-fb74-431a-8709-f2db9bbccba1

and check these value for null case again like above example

---

blog:My Blog/

Hope this will help you !!!
Sanjeewan