Solved

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

Posted on 2013-01-15
2
850 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 500 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now