|
SharePoint Content Types
by Michael Mullin, Consultant, MCAD, CRCP, MCTS
This article is the last in
a series which will describe and explain the content management. Previous
articles have discussed metadata and workflows. Now we are going to use that
information to explore the concept of content types.
Read the full article...
Customizing an LOV to include "All"
by Joe Roberts, Principal Consultant, BECP, SLE, MCP
Just like with Crystal Reports, with
Web Intelligence we are often asked “can I create an ‘All’ option in a List of
Values to use in my reports?” This
would save a great deal of time on the part of the user and have the added
benefit of making the system friendlier to the user.
In this article we take a look at exact how to accomplish that.
Read the full article...
SQL Coding Standards
by Sean Beal, Sr. Consultant, CRCP,
A critical part of managing data as a
team is the ability to read and perceive the intent of your teammate’s SQL code.
The key to this is a comprehensive set of SQL formatting standards.
Without one, at best you have ‘variety’; at worst, it is like your team
is speaking different languages.
Read the full article...
|
Crystal Reports or WebIntelligence
by Kristen St. Jean, Sr. Consultant, CRCP
How do we choose between Crystal Reports and Web Intelligence
for our reporting needs?
There is no cut and dry answer to this question, however,
there are advantages and disadvantages to each tool that we will discuss here.
Read the full article...
Finding and Removing Duplicate Records
by Charles Tournear, Sr. Consultant, CRCP,
MCSE, MCT, MCSD, MCDBA
This article will look at the SQL code used to find duplicate records and then
to delete all but one copy of each group of duplicates.
It will look at two scenarios: a table having an auto-incrementing unique
field and a table without a unique identifier for each record.
Read the full article...
Cautionby Aaron Zechman, Consultant, CRCP,
MCSE, BOCP
Creating universe objects from a table
which contains a field that contains multiple values, depending on a certain
criteria, can add a level of complexity to the universe.
I will walk you through the dangers on using the WHERE clause in order to
correct this issue and then show you a better way of solving the problem.
Read the full article...
|
