Formatting Percentages in Crystal Reports 11

25 May

Ref:http://www.crystalreportsbook.com/Tip_FormatPercentages.asp

  1. Right-click on the numeric field and select Format.
  2. Go to the Number tab and click Customize.
  3. Click the Currency Symbol tab.
  4. Click Enable Currency Symbol.
  5. Change the Currency Symbol to ‘%’
  6. Change Position combobox to ‘-123%’
  7. Click OK, OK to exit and save.
Advertisements

Good Begining to Object Oriented Programming

2 Mar

http://www.blackwasp.co.uk/CSharpObjectOriented.aspx

Restore MS SQL Database with Move

28 Jan

RESTORE DATABASE bsc
FROM DISK = ‘e:\bsc.bak’
WITH REPLACE

RESTORE DATABASE bsc
FROM DISK=’e:\bsc.bak’
WITH
MOVE ‘bsc’ TO ‘c:\TSQL\bsc.mdf’,
MOVE ‘bsc_log’ TO ‘c:\TSQL\bsc_log.ldf’, STATS=5

Counting records based on Condition

4 Oct

SELECT PCPNO,IPA,[Provider Name], COUNT(DISTINCT MEMBNO) as “Number_Of_Members”
FROM PCP
GROUP BY PCPNO, IPA, [Provider Name]
HAVING COUNT(DISTINCT IPA) = 1
ORDER BY Number_Of_Members desc

Using Conditional Split

29 Aug

This article describes the Conditional Split Process

http://www.programminghelp.com/database/sqlserver/sql-server-integration-services-dealing-with-bad-data/

Controling the look of Datagridview

18 Apr

http://www.solovb.net/index.php/2009/01/06/datagridview/

Analysis Services Stuff

28 Jan

MS-Analysis Services 2008 Part I
http://www.youtube.com/watch?v=yawq4SGoRoY

Comparing Relational Databases to Multidimensional Databases in SQL Server 2008/R2 Analysis Services
http://www.youtube.com/watch?v=q8p_2j5yTHI

What is Business Intelligence?
http://www.youtube.com/watch?v=LhZX0MAYKp8&feature=mfu_in_order&list=UL