qwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjkl
zxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiop
asdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmq
wertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklz
Hot SharePoint Buzz
xcvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopa
sdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqw
Useful SharePoint Posts Collection
ertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzx
SharePointBost Customers Research Center Presents
cvbnmqwertyuiopasdfghjklzxcvbnmqwertyuiopas
dfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnmqwe
rtyuiopasdfghjklzxcvbnmqwertyuiopasdfghjklzxc
vbnmqwertyuiopasdfghjklzxcvbnmrtyuiopasdfghj
klzxcvbnmqwertyuiopasdfghjklzxcvbnmqwertyui
opasdfghjklzxcvbnmqwertyuiopasdfghjklzxcvbnm
qwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjkl
Hot SharePoint Buzz
Keep You Updated With SharePoint Ecology
SharePoint Related Posts
Table of Contents
Deployment .............................................................................................................................................................................................................. 1
Change Default URL ................................................................................................................................................................................................ 2
Parent-Children Relation List ................................................................................................................................................................................. 3
Email Notification in Local Date and Time Format ................................................................................................................................................... 4
Administration .......................................................................................................................................................................................................... 4
Visible Checked-Out Documents ............................................................................................................................................................................ 5
Pop Up Login Often .................................................................................................................................................................................................. 6
Hide Scroll Bar .......................................................................................................................................................................................................... 7
Combine Documents .............................................................................................................................................................................................. 8
Hot SharePoint Buzz
Keep You Updated With SharePoint Ecology
I.
Q:
I have search for probable answer to this, but I can't seem to get it working.
I have a MOSS 2007 that uses the computer name as the default url name, how can I change this url to something else such as the
name of the company.
Also, I can achieve this during actual set up of the MOSS farm.
A:
Here is a quick procedure:
1) Open up your IIS
A) Expand the Web Sites folder
B) Right click on the site that you are using.
C) Click on Properties.
D) Make sure you are on the Web Site tab and click on the advanced button by IP address box.
E) Click Add and enter the following values:
i) IP address: (All Unassigned)
ii) TCP port: (use the port number associated with your site)
iii) Host Header Value: collaborate.kwd.ad.kellwood.com/sites/
iv) Click OK, OK, OK
2) Open Central Administration
A) Click on the Operations tab
B) Under the Global Configuration section, click on Alternate Access Mappings
C) Click on Add Internal URLs. Enter the following values.
i) Alternate Access Mapping Collection: Change the alternate access mapping collection to your site
ii) URL, protocol, host and port: collaborate.kwd.ad.kellwood.com/sites
iii) Click Save
3) Now you need to update the DNS to point to your SharePoint Server.
II. Q：
I am wondering about the login prompt and if it is appearing too often. When I 1st access my sharepoint site it pops up and asks
Hot SharePoint Buzz
Keep You Updated With SharePoint Ecology
me to login, no problem with that, however if I go to a document library and open a word doc, each time I open the word doc I am
prompted to log in again, this is very annoying and is this necessary or can I switch it off?
A：
Option One: Put your site either in
a) Trusted Sites (IE6)
or
b) Intranet Sites (IE7)
then you shouldn't get the additional login when opening a word doc.
If you are working in a domain, you will probably be able to avoid the first login by changing your Login settings
for the security zone of the site to "Automatic login using current name and password
III. Q:
If the document is checked-out to me in a document library, they are not visible to other users (administrator or contributor) on site.
How do I make them visible to others they are checked-out to me?
A：
Go to document library settings-> versioning settings, then select “Any user who can read items” for “who should see draft items in this
document library?”
IV. Q：
I have an excel report done with Performance Point Server and is deployed on a SharePoint site. Now in my SharePoint site I am
able to see that report as it is deployed but what I also see is a scroll bar. If I click on modify shared web parts and if I change the
height then I will not see the scroll bar but I don’t want to change the size.
Is there any way to hide that scroll bar??
Hot SharePoint Buzz
Keep You Updated With SharePoint Ecology
A：
Give this shot. Had the same problem this seems to work for me....
I created a new aspx page via SharePoint designer.
Add web part zone, add excel web access part & configure to show your excel file.
Attach your master page.
Ok to the scrollbars:
To remove the horizontal ones change the "columns to display" to something low like 10 or 5.
This can be done on the web part itself.
For vertical, go to the web part properties in SharePoint designer (should be on left hand side).
Change the height to something big like 1000px. This should remove the horizontal scrollbars.
Now, the trick is to slim down the height little by little so you aren't scrolling way down the page to see the footer.
For my application, a web part height of 775px is just right for displaying 50 excel rows.
-with that, my worksheet will never be larger than a max of 50 rows. if your height will be dramatically changing on a frequent basis then
this probably won't be your best bet. But it's an option for those who don't need dynamic sizing (which I have no idea how to do).
V. Q:
We deployed SharePoint 2007 Server, in which we have a document library. We have couple of content types. These content types have
some columns; and for one column there is a parent child relationship. When user selects first column (parent) second column (child)
values should be filtered based on parent column selection (basically getting Country and state functionality; when user selects country in
first drop down list all the states of that country should be filtered and displayed in second column drop down box. It is just kind of “list in
list”.
A:
I don't believe this functionality is available natively in MOSS2007. If it's critical that you need it, you can either custom code your own
web part to pull the two lists together, or look at someone like CorasWorks that provide this functionality as part of their plug-in product.
In my case I am using a tool called SharePoint Cascaded Lookup, which works fine. I recommend you take a look at it.
VI. Q:
Hot SharePoint Buzz
Keep You Updated With SharePoint Ecology
I have three document libraries and they have same structures and fields.
Now I want to display these three doc libraries as one list with the option of filter/group on document library name. I am using
SPD.
A：
I'm not sure what you mean by "club 3 document library" but I think you are looking to combine the three into a single data
source. You can do that by:
1. Open up SPD
2. Open up the page you want to put the view on.
3. In the Data View menu click the "Insert Data View" option
4. In the Data Source Library pane, expand the Linked sources option.
5. Click the "Create a new Linked Source..." link
6. Click the "Configure Linked Sources" button
7. Select the list you want to include and then click the "Add>>" button.
8. When you are done click next.
9. Choose "Merge" option to merge the results.
10. Click the "Finish" button.
11. Click the "Ok" button.
12. Drag the new data source onto your page and configure it as needed.
VII. Q：
SharePoint workflow notification e-mail messages do not use locale date and time formats.
A：
Here is the download links of October Cumulative Update (CU) for your convenience.
Description of the Windows SharePoint Services 3.0 hotfix package (Sts.msp): October 28, 2008
(http://support.microsoft.com/kb/957691)
Hot SharePoint Buzz
Keep You Updated With SharePoint Ecology
Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): October 28, 2008
(http://support.microsoft.com/kb/957693)
See Deploy software updates for Office SharePoint Server 2007 (http://technet.microsoft.com/en-
us/library/cc263467.aspx) for more information on deploying CUs.