[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 871
  • Last Modified:

How to handle the "&" sign in Query String (URL) Filter (SharePoint 2010)

Hello Experts,

I have a performancePoint Dashboard hosted on SharePoint 2010 website. The dashboard is comprised of two pages and the user has an option of clicking a text value in one report that will take him into another detailed report in a second page.

Both reports read data from SSAS cube and the parameter value that I'm passing has the following format (for example):
[Channel].[Genre].[Channel].&[2]
[Channel].[Genre].[Channel].&[4]
[Channel].[Genre].[Channel].&[100]

I'm using "Query String (URL) Filter" to pass the parameter between the two reports, but the problem is that the value gets truncated after the "&" sign, and I'm only getting this part:
[Channel].[Genre].[Channel].

Appreciate your help in trying to find a way to send the entire parameter value into the second page, i.e. [Channel].[Genre].[Channel].&[100]

You may wish also to suggest an alternative way for passing the value if you think that the "Query String (URL) Filter" is the not the best option.

Thank you,
Hani
0
Mehawitchi
Asked:
Mehawitchi
1 Solution
 
Rainer JeschorCommented:
Hi,
you will have to URLEncode the value passed by the query string.
What type of report do you use (which generates the link to the other page)?
If it is a SSRS report, this link will help:
http://capstonebi.blogspot.de/2010/04/url-encoding-in-reporting-services.html

HTH
Rainer
0
 
MehawitchiAuthor Commented:
Many thanks Rainer - It worked like charm
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now