Average for a Calculated Field?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Windows Services
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Combining Data from 2 Lists Hi All, After a bit of help with this if anyone could... I have two lists on my WSS site. 1 - Scheduled Events 2 - Consultant Assignments. In the scheduled event list, each event has an ID code and the event title In the consultant assignment list it refers to the ID code of the event but does not store the event title I want the data view to list the consultant assignments, and display the event title from the scheduled event list eg. Event Code Event Title Consultant Name Date of Event (from assignments) (from scheduled (from assignments) (from scheduled events) events) I know I can use a web part connection, but this means I have to click the list. What I want is something like the query builder in microsoft access, simply drag and drop the fields from the 2 lists, and create a join on the event UID. Is this possible? Any help/advice greatly appreciated. Cheers Chris Tag: Average for a Calculated Field? Tag: 45844
  - 2
    - SSL SharePoint Site revealing Local IP to remote users I have an internal SharePoint site that is being opened to a select number of remote users. A certificate was obtained and installed. When I visit https://sharepoint.organization.org, I'm prompted for my login and password and access the site. However, if I then try and navigate the site, some URLs are referencing the local IP address - http://111.222.33.4/site It seems to be the URLs from webparts that were added to the site prior to its conversion to a secured site. Any input? Tag: Average for a Calculated Field? Tag: 45843
  - 3
    - how to add non-domain users to a WSS site? Hi, I have created a WSS site wherein i have chosen domain authentication. Is it possible to give access to a person who does not belong to the domain Thanks, Sri Tag: Average for a Calculated Field? Tag: 45840
  - 4
    - Question about the MS Helpdesk Application I've downloaded and implemented the HelpDesk app that Microsoft released some time back for Sharepoint. I've gotten it customized almost 100% to our liking. My last hangup is the notifications for the submitters of tickets. Thanks to another post I read, someone suggested changing the Assigned to field to Submitted by. Thereby allowing the submitter to receive notifications about when I ticket has been modified and so forth. However the text of the email reads that a ticket assigned to them has been added or modified. I would like to find the template for that email and adjust so that it it reflects the submitter. Also if possible, like to include that Status field from the ticket so that the submitter knows what stage their ticket is at. Anyone know if I can do this? Tag: Average for a Calculated Field? Tag: 45838
  - 5
    - Allowing users to see web parts in web part gallery if they do not have access to top-level site I have WSS setup and the top-level site is not used - only a few people have permissions on it and I would like to keep it that way. However I have added some web parts (content editor, image, form, xml etc) to the web part gallery in the Top-level WSS site. As a user with permission to read the top-level site, and admin a sub-site you are shown the list of web parts. However if the admin of the sub-site does not have access to read the top-level site then the web parts do not appear in the browse list. Many Thanks in anticipation of any help. Jenny Tag: Average for a Calculated Field? Tag: 45833
  - 6
    - prompted password every time access to wss site wss 2.0 sp2 installed on a windows server 2003 R2. A top level website, say, companyweb has been created. "domain\domain users" group has been added to the reader group. Most users have no problem in browing to http://companyweb/ But a few users are prompted to enter username/password every time browing to that site. How to get rid of that? Tag: Average for a Calculated Field? Tag: 45825
  - 7
    - Alerts form non domain SP-Server not working (Timer Service/Netlog Hello Everybody, we've setted up an extranet on our external webserver located at the providers datacenter. This server is not an member of any domain only in a workgroup. We've installed Sharepoint Services incl. SP2 (english) - local installation without SQL Server, only WMSDE and the german languagepack. My problem is that Alerts are not sended out, only the email "An alert has successfully been added on ...". I've already googled and found that the "Timer Service" must be running. I can't get this service work. Each time I start it, an message come up that the services couldn't be started. Out of the event-log I can see that the error seems to be that the time service depends on netlogon service. I can't start netlogon because the server ins't a domain member. Furthermore I found that the Timer Service was running under NetworkService first, I should change it to localSystem but the service also does not start. Can anybody help me? Could it be, that alerts only work with SQL Server not with the WMSDE, like the search? Tag: Average for a Calculated Field? Tag: 45824
  - 8
    - The server could not complete your request. Contect the internet service... Error when I Edit my WSS site in FrontPage Hi, This is how i edit all my WSS sites in forntpage, and was working fine till last week. Now i get a error message saying The server could not complete your request. Contact the internet service provider or web server administrator to make sure the server has the frontpage server extensions or sharepoint services installed. and when i click the Details button, it gives me a message from which i cud sort out nothing. Object moved Object Moved here. If any of you have come across this prob, or if you the solution pls help me out, I feel like my hands are tied up...... Tag: Average for a Calculated Field? Tag: 45823
  - 9
    - Changing the text for "ID" in the Help Desk template I am looking for a way to change the text for 'ID' column in All Issues Datasheet used in the Help Desk Template. Instead of showing "ID" it is preferred to have it say "Item #". The "edit in datasheet" does not allow the name to be changed and under "modify settings and columns" for a View that column is not listed. Any thoughts or ideas on how this default Column can be edited and changed? Thank you. Tony Tag: Average for a Calculated Field? Tag: 45810
  - 10
    - Connecting with Enterprise Mgr to a Sharepoint instance I just installed Sharepoint Services on W2K3 Server used the defaults. Created a couple of sites. Now I wanted to look at the database (MSDE) that was installed. I tried using Enterprise Mgr but was unsuccessful when providing the \\servername\sharepoint_instance (MSSQL$SHAREPOINT). Neither Windows Auth or SQL Auth worked. I am not sure what the 'sa' password. What am I missing? What is the default 'sa' password or admin account for this installation? Thanks. Tony Tag: Average for a Calculated Field? Tag: 45806
  - 11
    - The ID 'spnUniqueWeb' is already used by another control. Hey, Can anyone help, I've been trying to sort out permissions, and access levels for all of the users for our site. I now find that I receive an error "The ID 'spnUniqueWeb' is already used by another control. " when accessing the Manage site groups page. Is anyone able to give me a heads up on what might be causing this error. Tag: Average for a Calculated Field? Tag: 45803
  - 12
    - Accessing internal site remotely? I have SBS2003 installed and running. I have an internal website setup and running SPS. Internaly it all works great. But how do you or is there a way to set it up to acess the site remotely with https? I can go in through the SSL connection and use the remote desktop or server connections links and logon to one of the local machines and access the page but I am unable to pull off the website directly from the default page after you logon. It says site cannot be found. I would normaly think that the link had the wrong information listed but it is listed like it would be if you were logged on locally. I want to be able to access the local SharePoint services company site remotely without making it a public site....like updating the calendar and documents when your not on the local lan. Is this possible? Or am I just missing something. Tag: Average for a Calculated Field? Tag: 45799
  - 13
    - Powerpoint documents hang on download We have recently installed WSS and some, but not all, Powerpoint documents cause IE and Powerpoint to hang when downloading. The files are not large - around 1 MB. The file download/open gets to about 95% and freezes. Any ideas? Tag: Average for a Calculated Field? Tag: 45795
  - 14
    - Any idea when we'll see WSS V3? Hi all, I've looked all over and the most accurate(?) info I can see on V3 is that the second beta is now out. I guess it's a closed beta programme cos there's no hint that I can download the code, even with my MSDN Enterprise subscription. A bit of info that worries me is that Microsoft have some (incredibly basic) info on "Office Sharepoint Server 2007" so I hope this doesn't mean that WSS V3 will not be available till next year. Anybody have the scoop on when we may see V3? Cheers, Scott Tag: Average for a Calculated Field? Tag: 45792
  - 15
    - Avoid double entry in event calendar Hi, I have a bunch of meeting rooms that can be booked via a SharePoint event calendar. Each meeting room has its own calendar and requires approval by a content manager. I want to avoid users from adding an event on a date/time that is already booked. Is there any way of achieving this? Thanks in advance for your replies. Sjoert Tag: Average for a Calculated Field? Tag: 45790
  - 16
    - Email enable doc lib SBS/SP Ive followed all the instructions on enabling public folder mailbox and SP but the mail/attach dont arrive in the SP doc lib. The mail items are in the public/folder in exchange!! Somewhere I read that the client permissions on the public/folder need to have added the SP profile. But my snapin only shows users! and not profiles. I tried giving "anonymous" full access to the client permissions in exchange for the public/folder but still SP doesnt collect the items. I did configure the virtual server and the SP site itself, which all seemed straightforward. Any ideas on any Gotcha's or a way of testing, fault finding. Thanks Jonathan Tag: Average for a Calculated Field? Tag: 45789
  - 17
    - Recover SPS to SQL Server from Desktop Engine data Greetings, I have a bit of a mess and before starting anew I thought I'd give the experts a go. I had a nicely functioning SPS site until I tried to upgrade my SBS server to SP1. The upgrade failed, as did the backout. Apparently my backup did not include system state so I could not recover. Since then I've rebuilt the SBS and installed SP1 as well as SQL Server. I have the following data files available: ----.STS_config.mdf ----.STS_config.log.ldf ----.sts_server2_1.mdf ----.sts_server2_1.log.ldf I've created a new SharePoint site on SQL Server with a name of httP://companyweb/default.asp which is different from the old one. My question is .. can i import these files into the new site and get back to where I was? FYI, I'm running SBS2003, SQL Server Thanks, in advance for the help. Mike Tag: Average for a Calculated Field? Tag: 45788
  - 18
    - Meeting workspace error Hi, I have a meeting workspace associated with a regular weekly meeting. I added dates to my weekly meeting and tried to link them to my existing meeting workspace, but I get the message that there are no meeting workspaces to link to. If I enter the URL of the meeting workspace used by the previous two meetings, it tries to create a new one and give an error message. Can anyone help? This is urgent. My boss is breathing down my neck waiting to enter the next meeting agenda! -- Jorobina Tag: Average for a Calculated Field? Tag: 45783
  - 19
    - Advanced Site Group Rights I would like to customize a site group but not in the normal way. I know I can create a new group etc and change as I'd like but I would like to have a group with certain permissions. Example : Instead of Manage List Permissions - Grant, deny, or change user permissions to a list. I would like Manage List Permissions - Grant or deny user permissions to a list. No create etc. Is there a way to define advanced Site Group permissions? Thanks Tag: Average for a Calculated Field? Tag: 45768
  - 20
    - Office Web Parts and Outlook -- Weird Error Hi, I have created a SharePoint page that has a document library in it and 3 office web parts (pivot charts) that are hitting a sql database. When I view the page stand-alone (via URL) or clicking the link in SharePoint the web page works fine. However, I also want this page to show up in Outlook 2003. I have taken my folder and chosen "Properties" and pasted the URL into the space provided. However, when I access the page via Outlook, the document library works but I am getting errors that are related to the Office Web Parts. It is saying: ******** Web page outlook://PathToFile is unavailable offline. To make this page available offline, connect to the Internet, click the Favorites menu, click Add to Favorites, and then select the Make available offline check box. ******** Problem is that I am not offline and even if I do what it says, it does nothing. Thoughts? Tag: Average for a Calculated Field? Tag: 45767
  - 21
    - How files are locked for editing in SharePoint I called MS to get the anser to this question and am pasting the summary provided by them below. Summary: -------------- Q1- Is there a difference in file locking when accessing document for editing over the Internet or internally? A1- no. It will be treated the same Q2-Clarification about Short term Locking vs. long term locking A2-SharePoint supports two kinds of check-out: Long term check out: This is the explicit check out. This holds a lock on the document whether you have it open for edit or not. Short term check out: You get this feature implicitly. If you open a document for editing, you get a short term lock on the document to prevent other people from editing the doc while you are. The Office client applications refresh this lock periodically as long as you keep the document open. Once you close the document, your short term check out is released. Q3- What is time period for the short term lock message? A3- Every three minutes Q4- What happens if the Internet session is terminated before it releases a document? A4- If session is terminated for any reason, WSS does not receive short term lock every three minutes, after 10 minutes WSS will release the document Tag: Average for a Calculated Field? Tag: 45764
  - 22
    - linking outlook to meeting workspace Some weeks ago, I created a recurring meeting in Outlook and (from Outlook) was able to create a linked meeting workspace. Then the meeting was cancelled so I deleted it from Outlook. Of course the data in the meeting workspace was still there, just no longer linked to any Outlook meeting. Now I have a need to re-establish this recurring meeting. I created the new Outlook meeting and then attempted to "link to an existing workspace" but the drop-down box of workspaces shows "None found". I tried each choice in "Select a location" (even "Other" then typed in the base URL to my pre-existing meeting workspace) but have had no luck. How could I link to this existing meeting workspace? Tag: Average for a Calculated Field? Tag: 45763
  - 23
    - Disk Space Hi, I have windows 2003 small business server and we are using team services for 15 people. The PC has 80 Gigs of space partiant (20 Gigs C: and 60 Gigs D:). I am running out of space on C drive. I would like to sharepoint to use the D drive for storage. How can do that? What is the best way to redirect or migrate??? I am using MSDE and not SQL Thanks Tag: Average for a Calculated Field? Tag: 45762
  - 24
    - We are experiencing several issues involving STS, SQL, and IIS 1. We cannot run maintenance plans and therefore we can not use SQL automated backups and maintenance tasks. 2. We can not use SQL Enterprise Manager over the network to connect to the database. If we install anything under the network parameters the site then refuses connections. 3. The search function in SharePoint is not working. The full text function is installed in SQL and the searh function button is checked. The database is installed as a single instance in IIS and is not installed as a farm. Should it be installed as a farm? If so, is there a way to either migrate this installation, or do we need to do a new install with a restore from a sharepoint backup? Are these issues related to the IIS database being installed as a single install instead of as a farm, or is this a characteristic that is inherent to setting up this type of configuration of WSS and SQL? Tag: Average for a Calculated Field? Tag: 45760
  - 25
    - Workspaces and User Access who aren't site members We have a situation where we need people who are not active users of our portal to access certain workspaces. We want them to be able to access the workspace only and no other sections of the site. We are using WSS 2.0. Is this possible? How would we go about implementing this? Thanks! Tag: Average for a Calculated Field? Tag: 45759
- Next
  - 1
    - slow authentication time I have Sharepoint Services and have setup anonymous access. If you go to the site it is really fast. If you try and authenticate it is really slow. 10-15 seconds each request of anything. Any ideas? Also what would be the best way to set this up for people to connect? Can I assign a DNS record with whatever I want to name it? How would I go about that. Thanks for the help. I am a beginner. Tag: Average for a Calculated Field? Tag: 45753
  - 2
    - Manage sites and workspaces not showing all subwebs When I go into Manage sites and workspaces I am not seeing all the subwebs (but I see some). If I go into Site Hierarchy (using the same user account) I can see them all. Has anyone else seen this? Any suggestions? Thanks Charles McClellan Tag: Average for a Calculated Field? Tag: 45752
  - 3
    - Restoring WSS from Content database backup only..... Hey guys, I have recently received the task of restoring a WSS website. The original server which contained the WSS top-level site has been moved to a new server (better hardware) and the only backup of the WSS site is a content Database STS_SERVER_1 and config database which I suspect we won't need. I know that you can add content DB's to an already extended WSS site but how do you then retrieve the old site content (documents, images etc..). The old URL was http://companyName.... my best guess would be to extend a new website with the exact same URL (host header)? When I create a new website how would I exactly go about pointing that website to my old content database..(extend and map??) I am not sure how or where to access the old site content... My question is with only the WMSDE content Database (no stsadm.exe backup) how do I restore that and retrieve the content. Any help would be greatly appreciated! Thanks, Tag: Average for a Calculated Field? Tag: 45750
  - 4
    - Command to add a domain group I've tried STSADM ADDUSER but it requires an Email account which Domain groups don't have. Does anyone know how to add Domain groups to WSS Sites via a Command Line? Tag: Average for a Calculated Field? Tag: 45748
  - 5
    - Is there a newsreader webpart? For example, the web-based interface to this newsgroup uses WSS styling. Does anyone know of any web parts out there that provide newsreader functionality? Tag: Average for a Calculated Field? Tag: 45747
  - 6
    - Home Link missing on navbar One of our senior mangers has some how managed to "remove" the Home link one navbar on the "_layouts/1033/viewlsts.aspx" page. However...it is only on one site. sSnce this page is located in the layouts catalogue I find it kind of strange cause he shouldnt have access to change anything there, which of course also would affect other sites. Since I cant just fix up the site with FP I'm wondering how and where to fix this, and I'm also wondering how this can have happend??? It also seems that every new doclib or list created under this site inherits this behaviour in the AllItems.aspx for the given list or doclib... You can find an image showing the problem at this URL: http://www.sharepointu.com/forums/upfiles/19085/Hf987892133.jpg Cheers Tag: Average for a Calculated Field? Tag: 45745
  - 7
    - How can I open a file in WSS database Hi How can I open a file that is located in the WSS database, but I don't want to open it through WSS but trough an ASP.NET page? Is this possible? How can I ask for this file or where is this document stored in the database? Thanks Joris Tag: Average for a Calculated Field? Tag: 45741
  - 8
    - asks for login for viewing web sites Hi all, I have installed WSS 2 on my virtual server with SQL Server 2005 as default database. Every thing went fine and I chose the windows authentication while selecting the database and application pool etc. For the application pool, I chose an existing application pool which is StsAdminAppPool(NT AUTHORITY\NETWORK SERVICE). I have successfully made the configuration and one default content database. But when I wanted to see my first default web site it asks me for the username and password which I never set for anything. I do have a username for my virtual machine but I never set a password for that. It asks for a username and password to connect to virtual server so that I can view the default site. I do have the administrator rights for every thing. I don't know which password and username it is asking for? Can anyone suggests me what should I do now? As far as I think the problem is that I should have chosen CentralAdminAppPool instead of StsAdminAppPool. Does anyone know how I change that now if that's the problem? Thanks Kahkashan Tag: Average for a Calculated Field? Tag: 45739
  - 9
    - Public Folder & Sharepoint Hello All I am running SBS2003 I need to indicate an e-mail has been replied to (dealt with) in a Public Folder (the icon doesn't appear unlike users normal mailbox) for a group of users. If I associate an Exchange Public Folder and Sharpoint will users have a replied icon on the relevant e-mail - unlike pure PF in Outlook2003 Thanks in advance Matt Tag: Average for a Calculated Field? Tag: 45732
  - 10
    - Is the Folowing Applicationb Possible Hello All I'm just finishing an instalation and my customer has seen Sharepoint and has asked one of 'those' questions. My customer has a small office (5 PCS 8 users) and needs all users to note down Telephone calls with owners (Timeshare Complex) and generally have an online database of owners details, which then could be printed out say when a page of A4 the notes fill an an A4 page. Can Sharepoint cope with say a word Document (template) open by a number of users at the same time? Is this possible with Sharpoint? To me it shouts An SQl App but have upgraded SP to SQL Thanks in advance Matt Tag: Average for a Calculated Field? Tag: 45731
  - 11
    - WSS FAQ corrections and additions - 3rd - 9th April 2006 Note: All of the addresses of the KB / MS / Non-MS Articles below were valid at the time I added them to the WSS FAQ site and to this file. I can't guarantee that they still are. (This is also posted to my blog at (feed) http://mikeswss.blogg.de/rss.xml (site) http://mikeswss.blogg.de) where you'll also find earlier versions) (Items are added to the WSS FAQ throughout the week so you will find new items more quickly by checking at wss.collutions.com or www.wssfaq.com daily.) From 3rd April - 9th April 2006 I. KB Articles New http://support.microsoft.com/default.aspx?scid=kb;en-us;915744 Description of the SharePoint Portal Server 2003 post-Service Pack 2 hotfix package: March 24, 2006 5th April 2006 http://support.microsoft.com/?kbid=915746 Description of the Microsoft Windows SharePoint Services post-Service Pack 2 hotfix package: March 21, 2006 31st March 2006 http://support.microsoft.com/?kbid=915774 Entries in a Microsoft Office 2003 Web Components PivotTable report may take longer to appear than you would expect 28th March 2006 http://support.microsoft.com/?scid=kb;en-us;826412 You receive a "The document could not be created" error message when you add a Visio 2003 template to the SharePoint Portal Server 2003 Document Library (ver 2.2) 11th January 2006 (new here - SPS and WSS not in Applies To section) Modified http://support.microsoft.com/?kbid=829065 You receive a "You are not authorized to view this page" error message when you connect to the SharePoint Central Administration page in Windows SharePoint Services (ver 3.0) 30th March 2006 II. MS Articles New http://www.microsoft.com/downloads/details.aspx?familyid=b64ac76f-0725-4091-a6b9-fa43377fc203&displaylang=en MSDN TV: Introduction to Upcoming SharePoint Products and Technologies (Mike Fitzmaurice) 6th April 2006 https://msevents.microsoft.com/CUI/WebCastRegistrationConfirmation.aspx?culture=en-US&RegistrationID=9555131 TechNet Webcast: SQL Server 2005 for the IT Professional (Part 4 of 11): Upgrade Considerations and Migration Paths (Level 200) 31st March 2006 https://msevents.microsoft.com/CUI/WebCastRegistrationConfirmation.aspx?culture=en-US&RegistrationID=9555122 TechNet Webcast: Rapid Deployment of Large SharePoint Intranets and Extranets on IIS 6.0 (Level 300) 29th March 2006 https://msevents.microsoft.com/CUI/WebCastRegistrationConfirmation.aspx?culture=en-US&RegistrationID=9555117 Microsoft Office System Webcast: Tips and Tricks for Microsoft Windows SharePoint Services (Level 200) 28th March 2006 https://msevents.microsoft.com/CUI/WebCastRegistrationConfirmation.aspx?culture=en-US&RegistrationID=9555106 TechNet Webcast: Increase Your Productivity with Free Discussion Database, Document Library, and Team Work Site Applications (Level 100) 27th March 2006 https://msevents.microsoft.com/CUI/WebCastRegistrationConfirmation.aspx?culture=en-US&RegistrationID=9555079 TechNet Webcast: SQL Server 2005 for the IT Professional (Part 3 of 11): Understanding Installation Options and Initial Configuration (Level 200) 24th March 2006 Modified None III Non-MS Articles New https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/9e891378-0601-0010-5386-a3387f1b161b Interoperability between SAP Enterprise Portal 6.0 and Windows SharePoint Services (SAP) September 2005 (new here) Modified None IV. WSS FAQ additions None V. WSS FAQ amendments http://www.asaris.de/sites/walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=579 I.23.4 What is fixed in the fix packs to WSS Service Pack 2? http://www.asaris.de/sites/walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=580 I.28.2 What is fixed in the fix packs for SPS 2003 Service Pack 2 Tag: Average for a Calculated Field? Tag: 45729
  - 12
    - can't add groups Whenever I try to add groups from AD into site permissions, the group is always auto-expanded into the individuals names in the box. WSS won't let me add groups, just users. Did I setup something wrong in my WSS initial setup? Is there a way I can fix it without blowing away my sites and starting over? Tag: Average for a Calculated Field? Tag: 45728
  - 13
    - Sharepoint User authentication.. Hi, I have Microsoft SharePoint question that someone might have answer for. I have Windows Server 2003, SharePoint portal, Business Intelligence (BI) portal, and Analysis Service installed on same PC. I have one admin login (administrator) and other non-admin logins (user1, user2) created. In Analysis Service cube, I have two roles (role and role2) that have access to only certain dimensions in cube. Added user1 to role1 and user2 to role2. When I browse cube using Analysis service, this role based security is working fine and data is viewed as per security permissions for user1 and user2. On SharePoint, I have created a Business Intelligence (BI) Portal that accesses the same cube as outlined above. I am logging into machine as Administrator and logging onto IIS/SharePoint as User1. However, when I browse the cube through SharePoint/BI Portal, my role based security defined in analysis service for user1 is not working and I get to see all data. Instead, I should be able to see only that data that user1 has access to because I am connecting to IIS/SharePoint as user1 (logged onto machine as administrator though). If I login machine as user1 (and not administrator), login to IIS/SharePoint as user1 and then view cube through SharePoint-BI Portal, I see only that data that user1 has access to. So, the security is not working when login to machine as administrator but login to IIS/SharePoint as user1/user2. Does anyone know how to impose role based security in SharePoint/BI Portal even if I logged onto machine as administrator? ~Raman Tag: Average for a Calculated Field? Tag: 45726
  - 14
    - Download directory from sharepoint? Is it possible to download or upload an entire directory from a Document Library in Sharepoint? Tag: Average for a Calculated Field? Tag: 45718
  - 15
    - Tree View web part? Is there a web part that allows a user to easily see what's "in" a share point site without having to inspect all the different places (lists, calendars, etc.). What I'm thinking about is maybe a tree view that can be easily exploded to show at least headings on documents, etc. Sort of a web site map. Tag: Average for a Calculated Field? Tag: 45717
  - 16
    - Alerts-specific changes Anyone know of a way to set alerts to send only if a specific change is made to a record? For example, a status column is changed to Approved? -- Jennifer White Tag: Average for a Calculated Field? Tag: 45716
  - 17
    - Alert to Folder Status Is there a way to indicate whether a document list folder has content or is empty? -- Jennifer White Tag: Average for a Calculated Field? Tag: 45715
  - 18
    - Can calculations be performed on rows in lists? I remember I was not able to do this (see title) but maybe someone has come up with a workaround in the meanwhile? I would like to create a column of totals, which adds up all the previous rows in the same column. Tag: Average for a Calculated Field? Tag: 45713
  - 19
    - Join two lists in SharePoint for one view of data I have two lists each containing a Project ID key. List A contains project data that only the PMO may update. The project ID key is established in this list. List B contains project status information that the PM's update. The project ID field in this list is populated via a look-up from List A. Where can I find step-by-step, very easy instructions on how to "join" these two lists, based on the common Project ID field, to create a view that contains data from both lists? There is a one-to-one relationship between the entries in these lists. It seems that creating one view with data from both lists should be very easy to do; but I have been unable to find any easy instructions that I could follow. I am not a programmer. Can someone help me please? Tag: Average for a Calculated Field? Tag: 45708
  - 20
    - Database restore, both from same and different server Here's the problem. Production WSS is working, but a web part has a memory leak. In order to try and debug, I am trying to restore content database from production to a development server. Development server is fairly new and only had a few test sites created by hand, not the 3-4 hundred in production. I've had all kinds of problems trying to restore this data. Here is the setup. PRODUCTION WSS SP1 with security fix on Server 2003 Standard with 1 virt server running site (2GB memory 3.4 Xeon HP server) SQL server 2000 exclusively for SharePoint DEVELOPMENT WSS SP2 on Server 2003, Pentium M laptop with 1GB memory and SQL Server 2000 Production is fine except for a poorly written web part. My problem is restoring db from production to development. Here is what I have done so far: (SQL Server 2000 SP4 already installed) 1) Backed up both Config and Content database from production 2 Restored back up content db over top of a default content db created when first virtual server extended (that virtual server was removed, so just reused db) I'm not really familiar with SQL Server, so this might have been a mistake 3) Installed WSS SP2 4) This automatically extended a default virtual server (fine) 5) I kept default config db (was this smart?) and just tried to add the new content db that I just restored 5) Received the following error message The account being used by Windows SharePoint Services to connect to database 'STS_standard-zzwskt_1_25040' on server 'STANDARD-ZZWSKT\SharePoint' is not the database owner (DBO). For more information, please refer to Knowledge Base article 841216 at http://go.microsoft.com/fwlink/?LinkId=45207. Looked over KB article. Searched group here and read about every discussion about restoring databases. I am using an AppPool with Windows Authentication and Network Service as the account. Since this is the only thing running, I didn't see this as a big issue. The KB article states as long as you give Network Service rights in SQL server (which I did) this should work. Then I remember (I was not in on initial production deployment so this didn't cross my mind at first) that Production is SP1 and dev is SP2. I attempt to use the stadmin to force the upgrade, but wait, the database I want to upgrade is not attached to SharePoint so nothing happens. So, I start over and uninstall WSS SP2 and reinstall WSS SP1. When I try and install security fix for SP1 (to get to same version as production), it states that the fix is already installed. I look, and somehow WSS is still SP2, not SP1 even though that is what I downloaded and installed. During installation there were some files that were being copied for which newer versions already existed, but I told it to overwrite anyway. So, I'm still stuck with SP2 on dev and need to restore my SP1 database. Ok, now I decide to make sure that I can at least restore the backup I made of the dev WSS content db before all this started. When I try and restore this, I get the exact same error as above, even though this db was created on this machine, is same version, and has dbo as administrator. I did all this work while as local administrator to the server. I'm at a loss and banging my head against the wall since I can't even add the content db that was made on this machine. I have a feeling it has to do with the AppPool settings/ using Network Services for the restore of db from same machine. However, the restore from prod server could be something else. I've only been working with SharePoint for about 3-1/2 months so I'm still trying to understand all its little intricacies. If more information is needed (I thought I would stop here since it's long enough already), let me know and I'll provide. Thanks for all the help. Adam Tag: Average for a Calculated Field? Tag: 45707
  - 21
    - Creating an ASP.NET V2 web application using WSS Hello everyone i'm new to the sharepoint world but have good experience in .Net application. I'm studying a development of a web application which will be host on a SBS server with sql server 2005 and I would like to take advantage of WSS for file sharing, web parts, site templates, etc. As i understood WSS is also possible on SQL2005. I allready have a database like let say AdventureWork which is the main store of my application. My first question is how does the merging or relation between those two databases possible ? Can i merge the two easily? how are user rights and goups related? Is it possible to create web part using ASP.NET V2 using my custom tables and integrate easily in a WSS site. What is support for multi-language, how is it handled. And finally can i use some AJAX async controls (like the telerik suite) web parts (using WSS tables and my custom tables) If someone experienced could help me a bit in understanding all the bits and pieces it will be very appreciated. And if you know some goog documentations out there let me know. Thanks mateo Tag: Average for a Calculated Field? Tag: 45701
  - 22
    - Anyway to blow away Sharepoint on SBS and not have other issues? Sharepoint is trashed on my new SBS box and I'd like to just start over since I am still in deployment. If I go into Add/Remove can I pull Sharepoint out and then reinstall and actually get a clean Sharepoint install with no hints of what was there before? Tag: Average for a Calculated Field? Tag: 45697
  - 23
    - [Wss] page viewer Is there a way to pass a certain user and password for a pageviewer webpart? I have a public calendar in a page viewer but it prompts for a login and password. Tag: Average for a Calculated Field? Tag: 45692
  - 24
    - Subtasks for projects My boss has a list of tasks on which he receives updates. Some of them may spawn sub-tasks. Can sub-tasks be assigned to ongoing tasks? If so, how? Tag: Average for a Calculated Field? Tag: 45691
  - 25
    - Missing Banner Navigation Alright. I did it. I screwed up. I was thrown into managing our SharePoint server well before the decision was made to hire a Microsoft consultant to guide our efforts. So here I am being overwhelmed with requests for site additions and upgrades and I am left to fuddle my way through being a SharePoint administrator... One of the first and loudest requests was to rebrand with the corporate logo and colors. I realize now (after research) what my error was. But I do not know how to fix it. And the same people that were clamoring for upgrades are now screaming for a fix. And our hired gun is still 4 weeks from coming in to save my arse. My version of my mistake: I went into the \60\TEMPLATE\LAYOUTS\1033 folder and edit a few documents (in FP2003). The only change I made was to point to a different image file for the small sharepoint people logo in the upper left corner and the logo to the left of the page title. I made the changes in FP2003 and saved the files. My version of the recurring error: Ever since that change was made in about 5 of the aspx files in the above referenced location, about half of the sites in SharePoint completely lost the banner navigation. (The other half didn't but they have been heavily customized in FP2003 and I suspect they are not ghosted so they did not inherit the error.) Also, any new sites created from a ghosted site is also created lacking the banner navigation. Weird part: If I open the site in FP2003, the banner navigation appears as a part of the page. So I don't understand why it would not appear when the site is opened in a browser. My version of a desparate plea for help: So, now I know that I should never have edited those files, especially not in FP2003. But moving forward, I am unsure of the approach to take to restore the banner navigation not only to the sites that it no longer appears on, but also to the sites that get created. HELP!!!! Thank you! Tag: Average for a Calculated Field? Tag: 45690

I have several calculated fields and I want to Average them by Group.

In the Totals section It does not let me choose the Calculated fields to do
my totaling on.

Is there another way besides putting in another field and using a Trigger in
the Sharepoint DB to copy over the Value to that field and then total that
field?

Thanks,
Scott<-

Top