Hey all, I have a situation that I need help with. I need to affect all of my company reports (over 300+) at the same time. I need to generate some sort of script (or something), that will run across all reports. The script needs to scan the entire report and convert the datetime value to European or Asian if the customer is located in those areas. My question is not how to do this, as I could do this across various reports, 1 by 1. My question is, how can I generate something to carry out this task, so I only create it once..? Thank you in advanced. Be more than a developer...be a business asset!

first, open up xml code of at least one of your report rdl. Find what needs changes and what need to be changed into. Then, copy all or make sure you store all your 300+ rdls into one central folder. then, use SQL Server Management Studio, click on top menu, Edit -> Find and Replace -> Replace in Files. You will see a new pop up window. Enter what needs to be looked and what needs to be replace. In the Look In: section, click the ... on the right and point it to where you stored all your rdls. Then click Replace All. hth. good luck.Think out of the box

One more thing, in the window, expand Find options, at the bottom, Look at these file types, select or pick *.rdlThink out of the box

Problem is that the fields, values, etc., are not universal across all RDL's....there are times that the field value might be different than in other RDL's, so i can't simply just do a "write to all" type of deal....the more i think of my situation, the more i think that i'm going to have no choice but work on each RDL independently. Thank you very much for your help nonetheless i_h :) Be more than a developer...be a business asset!

Hi Andy, From yoru description, you want to modify the format of the date time in more than 300 existing reports based on the customers location. Besides, each report that pending modification is only applied to the customers in a specific area. If I have anything misunderstood, please feel free to let me know. If there are not too many customers, you can view the code of a report in the project, search for the target datatime value, and then replace the value with an expression like below in the whole project scope: =IIF(User!UserID=A or User!UserID=B or User!UserID=C, FormatDateTime(Fields!FieldName.Value, "MM/dd/yyyy"), FormatDateTime(Fields!FieldName.Value, "dd/MM/yyyy")) Note: If there are more than two areas avaiable, you can use nested IIF functions or use the Switch function in the expression. If there are too many customers, I suggest that you sort out the reports into different projects according to the area. Then, you can modify all the reports in one project at one time. Hope this helps. Regards, Mike YinMike Yin TechNet Community Support

Hi Michael, Yes, that is exactly what I have been doing with my reports, pretty much exactly what you laid out....What I was looking for was a "one size fits all" of sorts, that I can execute and affect say 50 different reports at once so I don't have to do this report after report. Like I stated earlier, I've come to the realization that this might not be the best solution as different reports have different fields, parameters, etc., that might be depending on this. Andy.Be more than a developer...be a business asset!