Customize ReportViewerWebPart in C# and render in SharePoint Pages(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 9 months, 4 days ago

This is one of the major milestone I have achieved recently to customize the report viewer web part for SharePoint sites. The issue I was facing: the SharePoint site which I have developed was too complex and it exposed via 3 zones. http://intranetsite, http://extranetsite, https://internetsite http://intranetsite – which is Windows based authentication site and for intranet people. http://extranetsite – Which is Windows based authentication site and for extranet people http://internetsite – Which is Forms based authentication site and for internet people. ..... read more...

add a comment |category: Architecture |Views: 31

tags: ReportViewer part Architecture SharePoint Web another

Activate only selected features while deploying a solution package in (praveenbattula.blogspot.com)

submitted by praveenbattula(629) 10 months, 4 days ago

In Visual Studio 2010 SharePoint Developer Tools is what we use to develop quick solutions to SharePoint. With these tools we can quickly deploy into SharePoint environment as well. But, the only issue we see here is, if we are trying to deploy a package which contains a set of 5 features then all of them will be activated by default. But, this might not be a valid behavior for us. We need to activate only 3 features while deploying the package and the other 2 features need to be installed into SharePoin... read more...

add a comment |category: Visual Studio |Views: 22

tags: VisualStudio another

Date validation in Infopath 2007(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 3 months ago

In SharePoint infopath forms I need to implement one thing which was a bit tricky as it is not the default supported by infopath forms. The requirement is like this: The date fields on form should not allow date plus/minus 5 years from current server date. For this, so many people recommended to implement validation events in c#. But, my form contains 40+ date fields. That is not possible to implement events for each control. But, when I looked into all option there is an option called “Data Validation”. But, there is no direct option available to implement this requirement....... read more...

add a comment |category: Architecture |Views: 9

tags: another

Remove Table of Contents web part maximum limit(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 6 months ago

We use the "Table of contents" web part on SharePoint landing pages to give access to users to easily navigate to the sites/pages. But, there is a default limitation on the display items in left navigation or table of web part contents in sharepoint. By default it shows only 50. If you have more than 50 items [either sub sites or pages] in a site then it will not show up. To increase the limit or to remove limit, please do below changes. read more...

add a comment |category: Architecture |Views: 32

tags: Architecture another

SharePoint 2007 limitations complete list(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 7 months ago

There are so many posts in the Internet describes about this. But, there is no place where I found all at once. So, I am planning to keep this post up to date with whatever I find. If I miss anything then please add here or let me know. That will be a great help. read more...

add a comment |category: Architecture |Views: 14

tags: Architecture limitations SharePoint MOSS another

Sql Server Management Studio for Sql Azure(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 7 months ago

Sql Azure is very powerful and good to know these concepts. I love it and very nice technology these days. Windows Azure is going to be very powerful in near future. When you install the Sql Azure in the system, then you may need to search for downloading the SSMS for it. Here are the links for it. read more...

add a comment |category: Database |Views: 4

tags: Database another

Template Explorer in Sql Server 2008(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 7 months ago

I know, most of us do not know what it is... But, there are nice advantages of it and everyone should know about it. Template Explorer contains so many templates which helps us to understand many things and these templates have many examples on how we can write or do things through SQL queries. There are lot of default templates available like Backup, Restore, Database Mail, Trigger, user, login etc... read more...

add a comment |category: Database |Views: 2

tags: Database another

Importance of !important property in CSS(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 7 months ago

I think in css most of the people don't have idea or complete idea on keyword called "!important". It will be useful in many scenarios where we have plenty of style sheets and want to overwrite all the styles applied to an element with some other styles. We know that applying styles in HTML for controls hierarchy will be like this, Which styles are very close to the element those will apply finally. i.e. if we apply some styles for a division in css and if we write inline style for the same element, then always inline styles apply. That means the inline styles overwrites all other styles to that element. Like the same, in our css, if we apply different styles to an element in different places and finally if you want to overwrite the styles in a perticular section then you need to use this !important property at end of the style. We have a scenario like where we need to overwrite all of the styles to a perticular control, there this property will help us. read more...

add a comment |category: ASP.NET |Views: 139

tags: ASP.NET another

How to know the number of days in a month in t-sql(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 7 months ago

Some times we can get requirement to know the number of days in a given month. For example, while calculating how many days remaining in a month or last day of month or any other scenarios. Here is a small script that will give you the number of days for given month. Example purpose, i am retrieving month from the current date...... read more...

add a comment |category: Database |Views: 1

tags: Database another

How to know month name from month index in t-sql(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 7 months ago

When I am working with reports, this is what every time I am looking for. Everyone gives date on the report as input, and I want display the month name on the report instead of month index [1-12]. So, how to do it? please use the below script to get the name of the month by month index. DateName(month, convert( datetime, '2007-' + cast(month(getdate()) as varchar(2)) + '-01', 120)) Here month(getdate()) returns the current month index from getdate() function. Hope this helps... read more...

add a comment |category: Database |Views: 0

tags: Database another

Detect request is from iPad in ASP.NET(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 10 months ago

iPad. People slowly liking it. Few days ago, I have written a post on how to detect the request is from the iPhone. So, as iPad applications are also growing day to day, I want to give you a small tip on how to detect requests are from iPad. So that you will write logic which is specific to the iPad like html, CSS, scripts etc. read more...

add a comment |category: Other |Views: 137

tags: another

More SharePoint 2010 templates in Visual Studio 2010(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 10 months ago

I am working on SharePoint 2010 these days and all the development is on Visual Studio 2010. The IDE is very cool and great features. Really very helpful for developers and administrators as everything is builtin like deploy, configure and easy development. I really love it. There are plenty of SharePoint 2010 templates are available by default in Visual Studio. Here are some from Microsoft with extra templates. Install them and use them for time saving and learn more... read more...

add a comment |category: Visual Studio |Views: 25

tags: VisualStudio another

How to detect request is from iPhone in ASP.NET(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 11 months ago

The usage of mobiles is growing and growing day to day and most of the users are browsing from their mobiles and do the stuff. So, it is becoming important to support the mobile phones the web sites we are developing. Recently we have developed applications which support for iPhone and I am strongly believing that ASP.NET MVC is the best architecture in all ASP.NET versions. As we are developing applications it can be accessible from any where and any device including computers, mobiles, iphone, ipod or whatever. But, the important thing is UI. A web site how it looks like on computers is completely different from the mobile. So, we need to detect the user agent or the client who requested the site. So, if request from computer browsers then we don't need to anything as this is the default type. Whereas the request from the mobile phones then we need to render different UI. So, this post will explains that... read more...

add a comment |category: ASP.NET |Views: 43

tags: ASP.NET another

Know COUNT of bit column using Group by in T-SQL(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 11 months ago

Here is a scenario most of the times we use and look for. I have a bit column in database table and want to filter the count of true count and false count by applying Group By on it. For example, below is the simple scenario I came up with to better present you. We are storing employee details in database and taking attendance once in every day. So, in reporting, I want to see month wise report on how many are total, absent and present. Now, the challenge is need to find out how many are total employee and among them how many are attended and how many are absent in the given month and year. read more...

add a comment |category: Database |Views: 8

tags: GroupBy Count Database T-SQL another

Best Split UDF function with delimeter in T-SQL to return result as a (praveenbattula.blogspot.com)

submitted by praveenbattula(629) 1 year, 11 months ago

This is what the function I am using since many years to get the table of values in the given ID's which are separated by some delimiter. Simple to understand and see the example in the comments in below function. From the UI there are sometimes need of sending the data or ID's in the string format separated by a delimiter. So, in database, we need to grab them and apply some operations like with the ID's we need to get the records from a table. In this case, we need to use this UDF function. Everyone knows that inner joins are far better than IN clause or something else. So, what the approach I have taken here is...... read more...

add a comment |category: Database |Views: 17

tags: UDF T-SQL Database another

SharePoint 2010 Silverlight Client Object Model samples and examples(praveenbattula.blogspot.com)

submitted by praveenbattula(629) 2 years ago

Download the samples and examples of SharePoint 2010 Silverlight Client Object Model. read more...

add a comment |category: Architecture |Views: 47

tags: examples SharePoint2010 ClientObjectModel Architecture Samples another