Hi, I'd like to know where the script below stores this RDCE parameter when I execute in SSRS server. Public Sub Main() Dim props(0) As [Property] Dim SetProps As New [Property] SetProps.Name = "RDCE" SetProps.Value = "RDCE" props(0) = SetProps rs.SetProperties("/Folder/InServer", props) End Sub Br, Sami

Hi Please take a look on this link: http://www.codeproject.com/Articles/355461/Dynamically-Pointing-to-Shared-Data-Sources-on-SQL and on this thread for RDCE. I hope it will help. Thanks Vishal

Hi Vishal, I have read this article couple of times when I implemented my solutions. It is good article but I still wondering where this RDCE property is exactly located. The reason why I like to know this is that I'm wondering is it possible to set this RDCE to true in design phase so that I don't need to execute any scripts in server side after deployment. Or is it so that I always need that server side script to activate RDCE functionality in report? BR, Sami

Hi, please check these links, here you can see the steps of RDCE Implementation which i found as: http://my.safaribooksonline.com/book/databases/microsoft-sql-server/9780768689174/report-definition-customization-extension/ch29lev2sec3 and http://www.scribd.com/doc/73569353/330/Steps-to-Deploy-and-Use-Your-RDCE-Implementation Thanks Vishal T

Hi Vishal, Thanks for your reply. I have already made that script shown in first link and I'm currently using it. And I'have already read the RDCE chapter from that book on scribd. And as I see it not directly answered to my basic question. But it seems that currently the only way set RDCE property on for deployed reports is this script way which execution could be embedded to installation pakcage. Br, Sami

Hi Sami, If I understand correctly, you want to enable RDCE and set the RDCE property when designing a report rather than run the script after deploying the report to a report server. When we design a report, we define the Report Definition Language (RDL) which is an XML-based file that represents the metadata for defining a Report Server report. However, the RDCE property for a report is not part of the RDL, hence, cannot be defined within the .rdl file. So, running the script after publishing the report is the only way to set the RDCE property currently. Regards, James

Hi Sami, If I understand correctly, you want to enable RDCE and set the RDCE property when designing a report rather than run the script after deploying the report to a report server. When we design a report, we define the Report Definition Language (RDL) which is an XML-based file that represents the metadata for defining a Report Server report. However, the RDCE property for a report is not part of the RDL, hence, cannot be defined within the .rdl file. So, running the script after publishing the report is the only way to set the RDCE property currently. Regards, James