Post reply

Globals!ReportFolder in Call to Custom Function

  • June 6, 2009 at 3:28 pm

    #210676

    My system is sql server 2005 running with reporting services in sharepoint integrated mode. I have a custom assembly added as a reference in my test report with a static function that takes a string argument {MyFunction.GetRelativeUrl(string sReportFolder)}. My goal is set an internal parameter with an expression, such as

    =MyFunction.GetRelativeUrl(Globals!ReportFolder)

    However, it seems the value of Globals!ReportFolder is null when I use it as an argument (I've checked that the function call is working by hardcoding a samplevalue into the function call). Any ideas on how to use a Globals in such a manner?

  • June 6, 2009 at 9:27 pm

    #1005766

    Duplicate post.

    Please post all responses here.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • June 7, 2009 at 9:50 pm

    #1005903

    Hi.. 🙂

    Many regards.

    You can try storing your report folder information in a hidden text box and refer this text box using ReportItems.

    Please try this once.

    Try using textbox1.Value = Globals!ReportFolder..with hidden property set to true.

    Now..refer this textbox using ReportItems as;

    =MyFunction.GetRelativeUrl(ReportItems!textbox1.Value)

    This should help. 🙂

    Thanks alot,

    Niraj Joshi

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply