Download Crystal Reports 2010 for Visual Studio Now

Supported Operating Systems

Design Time

The following operating systems shall be supported for design time scenarios (i.e., in development environments).  Each operating system shall be supported in both 32-bit and 64-bit versions (as supported by the operating system).

• Windows Vista SP2
• Windows XP SP3 Professional
• Windows Server 2003 SP2
• Windows Server 2003 R2
• Windows 7
• Windows Server 2008 R2

Runtime

The following operating systems shall be supported for runtime scenarios (i.e., deployment/client environments).  Each operating system shall be supported in both 32-bit and 64-bit versions (as supported by the operating system).

• Windows Vista SP2
• Windows XP SP3 Professional
• Windows Server 2003 SP2
• Windows Server 2003 R2
• Windows 7
• Windows Server 2008 R2

Minimum Hardware Requirements

• Crystal Reports for Visual Studio is supported running on 32-bit versions of Windows running on x86 and x64 CPUs made by AMD and Intel.
• Crystal Reports for Visual Studio is supported running on 64-bit versions of Windows running on x64 CPUs made by AMD and Intel.

Design Time

• 1.6Ghz or faster processor,
• 1 GB (32 Bit) or 2 GB (64 Bit) RAM ,
• 650MB (32-bit) or 1.1GB (64-bit) available hard drive space

Runtime

• Intel Pentium III or faster processor,
• 512 MB RAM, 
• 300MB (32-bit) or 325MB (64-bit) available hard drive space

Unfortunately only Visual Studio 2010 is supported. Well, I think it’s not actually a big deal. Since other version like 2008 and below has built-in Crystal Reports.

Download now at share your experience here. You may also wish to share your source code and promote yourself to the programmer’s community.
Happy coding!

Read More

Convert Number to Roman Numerals in Sql Serve

CREATE FUNCTION fnConvertIntToRoman(@i INT)
RETURNS VARCHAR(100)
AS
BEGIN
    RETURN    Replicate('M', @i/1000)
            + REPLACE(REPLACE(REPLACE(
                  Replicate('C', @i%1000/100),
                  Replicate('C', 9), 'CM'),
                  Replicate('C', 5), 'D'),
                  Replicate('C', 4), 'CD')
             + REPLACE(REPLACE(REPLACE(
                  Replicate('X', @i%100 / 10),
                  Replicate('X', 9),'XC'),
                  Replicate('X', 5), 'L'),
                  Replicate('X', 4), 'XL')
             + REPLACE(REPLACE(REPLACE(
                  Replicate('I', @i%10),
                  Replicate('I', 9),'IX'),
                  Replicate('I', 5), 'V'),
                  Replicate('I', 4),'IV')

END

Read More

How to recover corrupted database file( .mdf .ldf).

EXEC sp_configure 'allow updates',1

RECONFIGURE WITH OVERRIDE

UPDATE sysdatabases SET status=1073741840 WHRE name='DatabaseName'

CHECKPOINT--shutdown with nowait

DBCC traceon(3604)

DBCC rebuild_log ('DatabaseName', 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\DatabaseName_Log.LDF')


USE DatabaseName
sp_dboption 'DatabaseName', 'single_user', 'true'

ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CHECKDB (DatabaseName, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

USE MASTER

UPDATE sysdatabases SET status = 0 WHERE name = 'DatabaseName'

DBCC CHECKALLOC ('DatabaseName')

DBCC CHECKDB ('DatabaseName')

sp_dboption 'DatabaseName', 'single_user', 'false'

USE MASTER

sp_configure 'allow updates', 0

EXEC sp_resetstatus DatabaseName 

Read More

Top 10 Best CSS Time Saving Tools

The Cascading Style Sheets (CSS) is considered as one of the most popular and widely used development language. CSS is quite easy to learn and use, it also offer some really nice features.

Aside from the fact that CSS is quite fun as compared to other languages, but still some of the tasks in it can be quite irksome. For this reason, various CSS tools were created to help you and make your life easier as a programmer.

We are going to present to you a list of the Top 10 Best CSS Tools to save your Time. This kind of tools will definitely help you do your work more quickly and save your precious time. The most important thing is it will enhance your productivity.

Here's the Top 10 Best CSS Tools: Listed in No Particular Order

1. Quick Form Builder

Accessify’s quick form builder merges two older tools (form builder and form element generator).

2. CSS Text Shadow

It is an amazing CSS tool that generates text shadows.

3. Sencha Animator

Sencha Animator is a powerful CSS3 Tool for creating Animations, text, images, buttons with gradients and embed analytics.

4. CSS Menu Maker

CSS Menu Maker is one of the best tool that provides every freelancer to create custom cross browser compatible CSS menus. You do not need any background of programming because it provides source code for all CSS menus.

5. Patternify

Patternify is a CSS pattern generator.

6. CSS Compressor

An amazing CSS Tool to compress CSS code and and help to speed your website loading time. It can save your server bandwidth as well compressed CSS in a good balance.

7. Prefixr

Prefixr provides Cross-Browser CSS in Seconds! it is also helpful for developers in testing their codes.

8. 3D Transforms

CSS 3D Transforms is an online tool that provides various level of Transforms. This tool is on experimental mode and require specific prefixes in all browsers.

9. CSS3 PIE: Decorations for IE

PIE makes Internet Explorer 6-9 capable of rendering several of the most useful CSS3 decoration features.

10. Layer Style

Layer Style is like graphic editor which creates codes in CSS.

Read More