Configuring Reporting Services for SharePoint 2010 Integration

This is the basic information to use the SSRS integrated in SharePoint, interesting reading for learning.

http://msdn.microsoft.com/en-us/library/bb326356.aspx

I have to ask about how the Report Server Database exactly works, there are so much things without answer in my mind.

Other important thing to be clarify: let’s talk about performance!!

The business case I have on my desktop does not require so much reponse time because the reports can be calculated during the night, but for on demand reports I would like to know if someone has done something similar.

SharePoint, Business Data Connectivity

Learning about SharePoint BDC, that is an standard functionality that is there in the server, but that the configuration and its start-up is not free in terms of effort.

1.- BDC service provides a means for storing and securing external content types and related objects. An external content type defines the following:

  • A set of fields of data, such as “building”, “room”, “connection”
  • The operations for interacting with the data’s external system, such as read, write, and create. There are so much options here.
  • The connectivity information that lets solutions that use the external content type connect to the external system.

2.-External content types are stored in a dedicated database that is part of the BDC service.

3.- To guarantee a secure connection, credential sets for the external systems are created. These credential sets are associated with identities of individuals or with group identities. All these data is stored in a secure database that belongs formally to the Secure Store Service.

To have BDC enabled into your MOSS server, you have to:

  • Activate BDC
  • Grant Access to BDC
  • Define the External sources you want to connect
  • Define and create the external content type
  • Create the Connection to SQL-Server

Note: to be able to configure the BDC you need to be granted as SharePoint Farm Administrator.

These are the basics, I’m not an expert for sure, but I need to understand what is behind.

Chemical Industry Outlook – May 2011 (By Zacks Equity Research)

I have these reports on my reader feed, they are so useful:

Share Chemicals are generally used to make a wide variety of consumer goods and are also used in agriculture, manufacturing, construction, and service industries. The chemical industry itself consumes 26% of its own output. Major industrial customers include rubber and plastic products, textiles, apparel, petroleum refining, pulp and paper, and primary metals.

The chemical industry has shown rapid growth for more than fifty years. The fastest-growing areas have involved the manufacture of synthetic organic polymers used as plastics, fibbers and elastomers. Globally, the chemical industry is mainly concentrated in three areas of the world: Western Europe, North America and Japan. The European community is the largest producer, followed by the U.S. and Japan.

Chemicals are a nearly $3 trillion global business, and the European Union (EU) and U.S. chemical companies are the world’s largest producers.

The US chemical industry produces 19% of the world’s chemicals output, amounting to $689 billion. The industry directly employs over 800,000 people nationwide. A total of nearly 5.5 million additional jobs are supported by the purchasing activity of the chemical industry and by the subsequent expenditure-induced activity. In addition, the US chemical industry is responsible for 10% of US merchandise exports, totalling $145 billion annually, as well as 11% of all US patents.

Complete Report:

http://www.zacks.com/commentary/17726/Chemical+Industry+Outlook+-+May+2011

Occupational Health

I assisted to a great session where the different processes related to Occupational Health were reviewed.

In summary, so much data to organize, the implementation of the processes depends on the product you choose.

In the business case we have for it, we have to cover Europe, a place where our customer is implementing all activities in different ways (mainly manually), so the consolidation of the processes is going to be a project itself.

The good thing for us is that they have clear in a business blueprint which processes they want to implement and this decision has come from the sponsor of the project. The position of the customer has been clear: you do this well, here you have the budget to implement a global solution for you and the others.

Things to read in deep:
– OH – Occupational Health
– IH – Industrial Hygiene
– IH&S – Industrial Hygiene & Safety

You requested a project not a simple technical action

Looking into information about SharePoint My Sites I have found this excellent article that talks about the lack of understanding that some customers have about the meaning of the installation of a tool, a feature or the effort needed to have something done.

Implementing SharePoint MySites: A Project in Itself:

http://www.cmswire.com/cms/enterprise-collaboration/implementing-sharepoint-mysites-a-project-in-itself-009519.php

We have received this morning the same request 🙂

SharePoint 2010, filtered view

The aspect of the view is easy, there are a lot of options to enable the visualization in the right way.

The only problem I have faced is within the filtering. I have tried to use brackets to point to other fields (for instance: [field_A] ) with the purpose of showing just the documents where the approver is equal to the responsible.

Reading on the internet I have found that the right way to do it is not with the filter option of the view. The proposed solution I found is creating a calculated column on the view.

I have added this formula: =IF([Field_A]=[Field_B],”Is Equal”,”Is Different”)

but this error is always shown:

Let’s continue working on this funny activity,

What is a REACH Only Representative?

A Reach Only Representative is a legal entity established in the EU, nominated by natural or legal persons that manufacture substances, formulate preparations or produce articles outside the EU.

An OR should have sufficient background in the practical handling of substances and the information related to them to be able to fulfil the obligations of importers.

Non-EU company appoints an only representative,

  • Although companies from outside the EU cannot register substances themselves they can appoint an Only Representative.
  • It is important that the OR has the skills, resources and experience to do the job.
  • Companies that import from outside the EU become Downstream Users and need to work with the OR for those chemicals where one is appointed.

This case study is so much interesting:

http://www.hse.gov.uk/reach/casestudies/redflag.htm

MS-SharePoint – Default language for first-time user cannot be German?

In the system we are developing, the default language for user which are using first time the system must be German.

At the moment it’s English.​

It looks that this can’t be modified through SharePoint (link). First SharePoint checks if the user already selected a preferred language, if not it is taking the preferred language out of the browser and at last it is taking the language settings out of the site collection.

Summary out of the link:

SharePoint Server 2010 selects the language in which to display pages of a site collection by using the first rule that applies from the following list:

  1. Does the user have a preferred language for this site collection on this computer? If so, use the user’s preferred language.
  2. Is the language preference that is specified in the Web browser one of the supported languages for the page? If so, use the preferred language of the browser.
  3. Otherwise, use the default, primary language for the site collection.​

Definitely this is not fun,

🙁