Archive for February, 2011
Configuring State Service in SharePoint 2010
To day I have got the problem when I am publishing the content and documents to internet web site in SharePoint. The error description is
“The form can not be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server state service”
The state service is automatically configured as part of the basic installation of SharePoint 2010. Advance installation requires the separate configuration of state service. Configuring the State Service after installation of SharePoint 2010 by using Power Shell or Farm configuration wizard
The solution to fix this error is well explained in both Power Shell and using the configuration wizard.
You can read the post here
Related Posts:
No commentsInstalling AdventureWorks Analysis Services Database
| This post discuss about configuring the AdventureWorks Analysis Services Database in SQL Server 2008 R2. You can download the sample databases from here. By default when you install the setup you would not see the analysis services database, you need to do some configurations to get it appear in analysis services database. |  |
To deploy the analysis services database perform the following steps:
1. Ensure that Analysis Services service account has got the access to the AdentureWorksDW2008R2 database.
2. Start the Business Intelligence Development Studio
Related Posts:
3 commentsFiltering Techniques for SQL Server 2008 R2 Reports
|
It is important to consider to filter report data based on user’s selection criteria as many databases contain large amounts of data. This post discusses different techniques to filter report data using report parameter concepts. By using the filters on reports, it greatly reduces the network traffic and helps the report to render efficiently. |
|
We are using same data source and query that we used to demonstrate the tabular reports demo. You can read the post here.
Filtering by query - You can filter the records in query by adding a where clause to it. Write the following query in query designer as follows
Related Posts:
No commentsChart Reports in SQL Server 2008 R2 reporting services
| Charts are effective way to visualize the aggregated values. This post discuss about creating a chart, Pie and Gauge reports using SQL server 2008 R2 Reporting Services. You will notice a significant difference in chart types in SQL 2008 R2 compared to SQL 2005. | |
Choosing Chart types: The important point while choosing a report type is – choose a chart type that meets the need and adds business value to the report.
You can choose Linear bar and column charts for visualizing the quantitative points. Line Chart may be the best choice when you measure the time on one axis and data values on another axis. Pie chart is suitable when you want to show portions and ratios.
We can use the same dataset that we used for tabular report for creating chart reports. You can read the post here.
Related Posts:
1 commentTabular Reports in SQL Server 2008 R2 Reporting Services
| It is important to understand the reporting options available in SQL Server 2008 R2 to provide an appropriate report layout to meet the business requirements and needs of our end users. This post briefly discusses about different report layout types available and explains in detail the steps to create a Tabular Report. It also explains how to sorting and drilldown features to your report. | |
Different Available Report Layouts are
- Tabular Reports – these reports are defined using table data and organized in to rows and columns. The columns are typically fields in the table. Reporting detail rows can be grouped on various fields, each group can have header, footer , breaks and subtotals.
Related Posts:
2 commentsDatabase Mail Configuration in SQL Server 2008 R2
| This post explains the configuration steps that require to send an email from SQL server 2008 R2. It is useful if we could send an email from SQL Server to our administrators and end users. Database Mail is SQL server component that uses Simple Mail Transfer Protocol (SMTP) to send email messages. After setting up the Database email we can test the email and mail-log. | |
1. Open the SQL server management studio and expand the Management node under the server
Related Posts:
No commentsInternet Explorer 9 features for Developers
| Microsoft recently launched its first release candidate for Internet Explorer 9 (IE9 RC1) can be downloaded from here. This post briefly speaks about the IE9 features and how developers can use these features. |  |
With IE9 you can take the full advantage of hardware through windows so that you can enjoy the rich graphical interface which are fast and responsive as windows applications in your PC. Web developers gets the support for HTML5 and modern web standards. Reference is IE9 RC Product Guide
Top New Features in IE 9
| Hardware-accelerated HTML5 - IE 9 takes the advantage of your PC’s hardware through windows. The new HTML5 features include support for audio, video elements and embedded media content without any plug-ins. It takes the advantage of hardware acceleration through windows and GPU(graphics processing unit). |  |
Related Posts:
No commentsGuidelines for Developing Class Libraries in .NET
|
This post explains about design guidelines for developing class libraries that extends the .NET Framework. Following design guidelines provides benefits of consistency and unified programming model for developers. |
Naming Conventions for Casing Identifiers
There are two different styles in Casing Identifiers
Related Posts:
3 commentsConfiguring SQL Server Reporting Services in SharePoint 2010
| This post discusses how to configure SQL server reporting services in SharePoint Integration mode. You must do some configuration steps on both report server and SharePoint server to get report viewing on SharePoint sites. |  |
SQL server reporting services can be configured in two modes
Related Posts:
11 commentsConfiguring PerformancePoint services in SharePoint 2010
|
The following are the configuration steps to get PerformancePoint up and running on SharePoint 2010 enterprise edition. As PerformancePoint service is integrated in SharePoint 2010 environment, we need to do some configurations in Sharepoint2010 Central Administration tool. |
|
Related Posts:
10 comments
