Solved

Dashboard filter not working

Posted on 2011-02-14
5
950 Views
Last Modified: 2012-05-11
I created a dashboard in dahs board designer and added to it an ssrs gouge with a parameter.
The gouge has 2 datasets , one for the data and one for the values of the parameter.
I gave the parameter the list of avalaible values from the query, and the same for default values.
In "advamce" tab of properties I chose "refresh allways" (though I tries all options).
I added then a tabular filter usig the same query (from view this time) as the parameter uses.
I linked between them and deployed.
The issue is that the filter does make th gauge to refrsh, but it does not affect the data, it always present acording to the default value, though when opening the gouge stand alone the filter wokrs fine.
Any Ideas?
0
Comment
Question by:martinte
  • 3
  • 2
5 Comments
 
LVL 18

Expert Comment

by:chrismc
ID: 35387122
I think you mean a "GAUGE", a gouge is something entirely different ;-)

I mention it, not to poke fun at your English - which is far better than my ability to speak any other language.
But if you are spelling it that way when searching on the internet, you are probably not getting to the pages you need.

I'm not familiar with Dashboard designer, but this question has been put into the SSRS zone.
Could you send a screen shot so I can get a sense of what this product is. If it is SSRS then I can try and help.

Regards
Chris
0
 

Accepted Solution

by:
martinte earned 0 total points
ID: 35393603
Sorry, we found the problem - dashboard designer filter does not work with int values (!!??)
once we moved everything to strngs it worked.
0
 
LVL 18

Expert Comment

by:chrismc
ID: 35394288
Sounds bizarre!

Thanks for letting us know.
0
 
LVL 18

Expert Comment

by:chrismc
ID: 35394302
No objections to closing this as requested.
0
 

Author Closing Comment

by:martinte
ID: 35422378
We found it by trial and mistake.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

930 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

12 Experts available now in Live!

Get 1:1 Help Now