Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2013-01-15
2
Medium Priority
?
876 Views
Last Modified: 2013-01-16
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
Comment
Question by:Mehawitchi
2 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 2000 total points
ID: 38778949
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
 

Author Closing Comment

by:Mehawitchi
ID: 38781691
Many thanks Rainer - It worked like charm
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
Read this article to learn how to migrate data from SharePoint to SharePoint Online account. The entire process of SharePoint migration is described in detail.
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

605 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question