.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Choice Filter Web part and Excel Web Access web part

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :SharePoint
I have a choice filter web part where in I have months like Jan,Feb,Mar etc and a excel web access web part. The choices in the filter web part should determine the URL of the workbook for the excel web access web part. In the filter web part I gave the choices as Jan;http://sitename:port/ExcelList/MyExcel.xlsx where "ExcelList" is the library that stores the excel files for each of the months. But the excel web part always says that "The file selected couldnt not be found". Is it possible for me to know the actual URL getting passed to the excel web access web part? Pl suggest if there is a better way to do this. Cutloo

View Complete Post

More Related Resource Links

How to pass a parameter from a choice filter with project IDs to a KPI web part?



I have an excel pivot table like this:

Report Filter: Project ID
proj_name     Status 
A              70
B              60
C              80

I have this workbook published onto Sharepoint server through excel services.
On the site i have a choice filter that has all the project ID's. I am able to show this table in a web part and filter the web part by passing parameter from the choice filter to the report filter in the workbook as shown above.
I added a KPI webpart that uses the "status" from the above table as its indicator value. What I want to do is that I want to pass the parameter from the choice filter on the site to this KPI web part so that it will show me the corresponding status dynamically accoring to the project chosen.
Can someone help me solve this problem?

Anonymous access on Excel Viewer web part for a no access .xslx file?

I have a public facing SharePoint 2010 Enterprise website with anonymous access enabled. I'd like to present information (a pivot chart) from an .xslx file using the Excel Viewer Web Part. It works fine when I place the .xslx file in a document library that the anonymous users can access. I would, however, like to remove anonymous access from the .xslx file and only expose the chart from the .xslx file using the Excel Viewer web part. When I alter the library permissions to remove anonymous access to the library that holds the .xslx file, the Excel Viewer web part displays an "Access Denied" message to the anonymous user. Is there some other way to achieve this?

Foundations: Adding Code Access Security to WCF, Part 2


This month's column continues the discussion around code access security in WCF and partially trusted services.

Juval Lowy

MSDN Magazine July 2008

Foundations: Code Access Security in WCF, Part 1


Here we discuss code-access security in Windows Communication Foundation (WCF) and present a solution for enabling partially trusted clients for WCF services.

Juval Lowy

MSDN Magazine April 2008

Data Points: The Enterprise Library Data Access Application Block, Part 3


E nterprise applications can have a wide variety of data update requirements. Sometimes you need to save multiple rows of changes at once within a single transaction. Other times, the user must be allowed to enter multiple rows of data, send them to the database in a batch; and if a row or two fails, only the rows that succeeded should be committed and remain committed.

John Papa

MSDN Magazine October 2005

Data Points: The Enterprise Library Data Access Application Block, Part 2


Last month I explored the foundation of the Enterprise Library Data Access Application Block (DAAB) including how it all fits into an architecture (see Data Points: The Enterprise Library Data Access Application Block, Part 1).

John Papa

MSDN Magazine August 2005

Data Points: The Enterprise Library Data Access Application Block, Part 1


A solid data access later (DAL) can benefit an application by hiding redundant tasks, helping handle exceptions more gracefully, helping clean up resources more efficiently, and providing a layer of abstraction from the database.

John Papa

MSDN Magazine July 2005

Can the default member for the sql server analysis filter web part be a mdx expression or not

I have designed a dashboard , some parametrized reports ( on date and time) in my case with a cube as datasource, added an analysis services 2005 filter, connected it to the reports. The issue concerns the default value for the filter . I f I choose [Date Local].[Calendar Hierarchy].[All] it works well. But the business requirement is to use the last day where there have been registered a measurement which in my case looks like the following mdx expression: Tail( Filter ([Date Local].[Date Key].[Date Key].Members , ( ( [Advisor Organisation].[Advisor organisation].[Contact Center].&[Denmark]&[Kundelinjen], [Measures].[Calls Offered] , [Date Local].[DK Holiday].&[False] , [Date Local].[Week Day].&[True] ) > 0 ) ), 1).Item(0).Item(0) The expression is all right as I use it in my report as an mdx filter expression. But when I use apply it I get an invalid dafault member value. So the question is : Does the filter support an mdx expression ? If yes, is there another syntax or change in order to make it work ? Thank you a lot for your answer.

Excel Web Part - different Powerpivot Slicer disabled tue to sharepoint users

Hello, first of all i'm new to sharepoint. I found quite similar question to mine http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/9f23a77c-1527-48a8-abbc-2ccded736d9e but unfortunately it hasn't been answered. So what i have done so far: I made a Excel 2010 Powerpivot chart and Published it to sharepoint via the Powerpivot gallery. I also created a Excel web part with the spreadsheed in it. I am searching for a vba script to achieve the sharepoint username but found only some for the windows username. I also managed to disable slicers in vba. What i want to achieve: Due to the fact that the Powerpivot chart has some critical security data in it the different users should only see two different filter options (whole data and one slice for themself) So i need to disable slicers in the pivot chart tue to the sharepoint accounts. My Qestion: Is it possible? If yes, how! Any help would be appreciated. Is it possible via VBA or do i have to use Excel web scervices?  Thanks for your help :)

Target audiences not working in excel services web part

My appologies i posted this originally in the pre-2010 forum So i'm reposting here: We have recently upgraded to Sharepoint 2010 and we're experiencing problems with the "target audience" field being available to the users. I am not the CA admin though so it'll make this a bit tough to get solved if the problem is there. What i'm looking for are the suggestions of things for me to forward to the CA admin to change or check if anything. We have a seperate Virtual Machine that is running 2010 that has this option available to users on that farm for some reason. however on our corporate farm we don't have that option available. Plus on top of this the quick launch items are not working with audiences as well to turn off the headers to links that have nothing in them due to security trimming on document libraries. I'm hoping that this being a more of an overview of things to check would help others who may have this problem as well. I've seen resolutions such as rebooting the server and such, however that's a bit lower level and we need some higher level things to check that may resolve the issue. Think the simple stuff first to check and lets work down the list. Doesn't matter how stupid it is but can we get a more compiled list of things to check to make sure that target audience visibility to users is enabled? Thanks!

Sharepoint Filter Web Part Connection to Picture Libary Web Part

It seems that a sharepoint or choice filter web part can connect to any list object in sharepoint that is displayed in a web part on a page but the picture library.  I want to allow the user to select a value so that only the image that applies is viewed (along with any correlating information stored in its library). Is there a work around for this?  I've looked all over the web and can only find where someone else has asked in another forum and has not yet received an answer.  I'm sure this isn't the first time this has come up, so what are folks doing to accomplish this?

How to access server/share resources from an internal/intranet Web Part?

We are a team of native-client/webforms developers who have been tasked with developing an internal intranet SharePoint system for our team. We want a WebPart that displays sets of files on internal shares, allows selection of subset(s), and then downloads the files to the local machine. Basically it's a builds/test-artifacts/documents "getter" scenario. We created less elaborate web sites that do somethihng like this (as proof of concept.) However, no matter what we do with our WebPart, it will not allow access to non-local(host) shares, files, etc. The WebPart CAN access said shares/files when the entire thing - client (IE session) and debug[ger/gee] etc - are run on a single dev box. However, when we attempt to run the client on a different machine accessing the dev box (in a server role), the code cannot access the network resources (for example, File.Exists() and Directory.Exists() fail.) How can we make this work?

Editing cells in Excel web acces web part

Hi, I am using the excel web access web part that displays an excel spreadsheet in my web page. In order to edit the cells I need to name each cell,add the name in the parameters section in the Publish options and then publish it to Excel Services. I was wondering if there is a way to edit the spreadsheet of the web access web part similar to a normal excel spreadsheet? Thanks

SQL Server Analysis Services Filter web part.

Hi all In a NTLM farm with 1 SharePoint and 1 SQL server, I am using clamis based authentication for Excel Services app in SharePoint Server 2010. While all Excel documents work, I get error on "SQL Server Analysis Services Filter" web part. The filter works when I am logged on the sharepoint server and open the Intranet to use it, but doesn't work if I reach the Intranet by not logging on the SharePoint server. The error I get is on the filter web part: "An error occured while retrieving filter values (The connection either timed out or was lost). Anyone else that have had the same problem? Any ideas to troubleshoot? :) Regards

Anonymous access - User prompted for login after click in web part area

I have a MOSS2010 site, internet-facing using anonymous access. I've found workarounds to many of the anonymous access issues I've come across, but I don't know how to fix this one. Any ideas or assistance would be appreciated. A user visits one of my pages with a OOB webpart. If they click within the area for that web part, essentially selecting the web part, it prompts for a login. I don't want my users getting prompted for a login, but I don't know why they're being prompted in the first place. According to the logs, it looks like it is trying to access _layouts/wpribbon.aspx. They aren't clicking on the items (titles aren't clickable), it's the area within the web part box. Can I make that area non-clickable?? Go to: www.carlile.biz/careers/pages/current-openings.aspx Click on the area around the Locations or the Current Openings listed. Either will prompt for a login. Even with a valid login, the view does not change and no further options are presented.

Custom Web Part doesn't work with in anonymous access

Hi there, I have a custom webpart in a farm solution deployed to my site. Anonymous users should be able to view the site, however they can't because they are required to login due to the custom web part. If i remove the webpart from the page, anonymous users can view the site perfectly without the need to login. There is nothing really special about the webpart. It's a visual web part which uses the site and it's web data to display a sort of menu. Any idea? Thx in advance! Brecht

User Filter web part: how to show items with no value in it

I want to set up a document library View that shows the current user all items with their Department name in a column, as well as those items that don't yet have a Department name. I thought I could do this with the User Filter web part, but I am struggeling to show the items that don't yet have a department name. The problem I have is this: I created a view called "My department's items". I use the User Filter web part on it to show the user all items that have got the user's department name in a column. However, when a user forgets to fill out the department name after uploading a file, or even when they upload the file but then cancel filling out the compulsory fields, the uploaded file disappears from the "My department's items" view (because the department column is empty). How can I set up a filter to show all files that match the current user's department name as well as those that don't have a department name yet? Thanks.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend