PingBack from http://stevepietrek.com/2008/12/14/links-12142008/

In looking at your code, I have a related question, kind of.  In using the Sharepoint ReportViewerWebPart it is easy to set the ReportPath in the Sharepoint User Interface, but I haven't been able to figure out how to set the ReportPath in code. I have a requirement to do this in a site definition solution I am developing.  Can you point me in the right direction?

I am not sure what you starting point is in code, but can determine the report path by using SPContext, which gives you the context of the current site or site collection that you are in.  From there you can iterate the lists or items in the list and use the SPListItem.RelativeUrl property (I think) to get the url of the item you are interested in.

Hi Cliff,

I probably misstated my question.  In my site definition, the provisioning code knows the url for the new site, so I know the url for the report rdl files.  The ReportViewerWebPart has a ReportPath property that I must update in the site provisioning code to reflect the path for the site being created but I haven't found any way to get at that property and change it so I was looking for suggestions on how I might do that.  If I try to use the SPLimitedWebPartManager, it only sees the ReportViewerWebPart as an ErrorWebPart.  My hack right now is to update the onet.xml for the site definition before my provisioning code calls it.

Are you using a featurereceiver to do this work in site provisioning?  It may be a timing issue as far as when the feature receiver is called.  Does SPLimitedWebPartManager allow you to see the properties once the site has been provisioned?   If so, you may want to look at a solution like the one linked below where your master page or default.aspx has a control on it that runs the first time someone comes to the site and sets the properties then.

http://blogs.msdn.com/sharepoint/archive/2007/03/22/customizing-moss-2007-my-sites-within-the-enterprise.aspx

I’m using the SPWebProvisioningProvider suggested by Connell so that I can get the site constructed before doing any custom code. The basic code outline is

public override void Provision(SPWebProvisioningProperties props)

{

Microsoft.Office.Server.Diagnostics.PortalLog.LogString(”Beginning CPDCMSiteDef provision code.”);

SPWeb elevWeb = null;

try

{

SPSecurity.RunWithElevatedPrivileges(delegate()

{

// Apply the actual Web template for the CPD CM site

// get elevated web - sometimes sharepoint doesn’t like to do stuff inside the elevpriv block

elevWeb = props.Web;

elevWeb.ApplyWebTemplate(CPDCMSiteDef#0);

});

elevWeb.AllowUnsafeUpdates = true;

elevWeb.Site.AllowUnsafeUpdates = true;

… all of the site pieces are in the onet.xml of the CPDCMSiteDef#0 template. After the site has been created above, I run the custom code, which is where I have tried to use the SPLimitedWebPartManager to get at the ReportViewerWebPart. ListViewWebParts on the same page are accessible but the ReportViewerWebPart doesn’t seem to be.  Right now I'm experimenting with an awkward hack.  The page in question is provisioned in a module of the onet.xml. Before I call the code to create the site, I update the ReportPath property in the onet.xml file.  I'm probably breaking a million rules but it seems to work.

Dan,

I am not sure why the web part is reacting that way.  If I get a chance to investigate I'll report back.

I am now trying to follow your example to create a custom assembly that I can use within an RDL.  In my case I have modified the code to return the ServerRelativeUrl, which I am using as the default value for a parameter in a RDL.  when the RDL is loaded, it returns the error "Failed to load expression host assembly. Details: That assembly does not allow partially trusted callers".  the assembly is in the GAC but I haven't done anything with the report server config file (it wasn't clear to me if I needed to when the assembly is in the GAC, or what to add to the config).  Do you have any examples of how you've deployed and called a custom assembly in a RDL?  thanks

After I posted this I realized that you can also use the Globals!ReportFolder expression to provide the location of the report in SharePoint.

For using a custom assembly in RDL follow this guidance:

http://support.microsoft.com/kb/920769

In your case you may just need to open your AssemblyInfo.cs file in your project (located in the properties folder).  

Add a reference to using System.Security;

at the bottom of the AssemblyInfo file add [assembly: AllowPartiallyTrustedCallers()]

thanks for the link - it was very helpful.  The change to the AssemblyInfo.cs cleared up my security issue but it raised another.  My test report attempts to use the custom assembly to get the default value for a parameter.  When I deployed it to my sharepoint site and tried to test the report, it would never render. In debugging the queryString is "http://win2k3mossdev:1234/reportserver/ReportExecution2005.asmx" rather than the string with embedded rdl path in your example.  I'm guessing that this is because my reporting services is running with "integrated" mode rather than "native" mode?  I poked around in the HttpContext while debugging but didn't see anything with the actual report path.  any ideas?

What is your assembly doing?  What parameter value default is it trying to provide?  Where did you get the HttpContext?  

The example shown in the blog post is running in integrated mode.  I used HttpContext embedded in the report, if I remember, to inspect the url by adding a reference to System.Web.HttpContext in the report properties code section and having it output the current request information.

The report path can be gathered by using the Globals!ReportFolder expression in the report whether in integrated or native mode.

I had just mimicked your code in its own dll, added it to the report references, then called it in an expression.  Sounds like I don't have it quite right.  I've just started looking at the Globals, which seems to make it even easier.  Thanks

using System;

using System.Collections.Generic;

using System.Text;

using System.Web;

using Microsoft.SharePoint;

using Microsoft.SharePoint.Security;

using System.Security;

namespace CPDCMSiteDef

{

   public class ReportFunctions

   {        

       public static string GetRelativeSiteUrl()

       {

           string relativeSiteUrl = "";

           try

           {

               string siteCollectionUrl = "";

               string webUrl = "";

               string queryString = HttpContext.Current.Request.Url.ToString();

               int indexStart = (queryString.IndexOf("?") + 1);

               int indexEnd = queryString.IndexOf("&");

               string reportUrl = queryString.Substring(indexStart, (indexEnd - indexStart));

               siteCollectionUrl = reportUrl.Substring(0, reportUrl.LastIndexOf("/"));

               SharePointPermission sharePointPerm = new SharePointPermission(System.Security.Permissions.PermissionState.Unrestricted);                

               sharePointPerm.Assert();

               using (SPSite siteCollection = new SPSite(siteCollectionUrl))

               {                    

                       int i = siteCollection.Url.Length;

                       int j = siteCollectionUrl.Length - i;

                       webUrl = siteCollectionUrl.Substring(i + 1, j - 1);

                       int x = webUrl.IndexOf("Project Reports");

                       webUrl = webUrl.Substring(0, x - 1);

                       using (SPWeb myWeb = siteCollection.OpenWeb(webUrl))

                       {

                           relativeSiteUrl = myWeb.ServerRelativeUrl;

                       }                  

               }

               sharePointPerm.Deny();

           }

           catch (Exception ex)

           {

               relativeSiteUrl = ex.Message + ex.StackTrace;

           }

           return relativeSiteUrl;

       }

   }

}

I've been banging my head against trying to use the Globals!ReportFolder in a call to a funtion in an external library.  In my simple test report I am using a expression

=MyFunctions.GetRelativeUrl(Globals!ReportFolder)

I get an error that implies the Globals!ReportFolder is empty.  Another text box with an expression

=Globals!ReportFolder does show the correct value for the ReportFolder. If I hard code a value in the function call, the correct value is returned.  Is there a trick to using the Globals!ReportFolder in a function call?  thanks

When I put this example together I called an embedded expression and called my custom assembly from there.

=Code.GetPath(Globals!ReportFolder)

Function GetPath(path As String) As String

 Myassembly.GetPath(path)

End Function