Downloading Crystal Reports missing Components for SSRS 2008

Recently i have assigned a task to add crystal reports in SSRS 2008 and open their design in it. I have tried one of my colleague's system and i will see report design successfully opened in it. But when i have tried to open it in my system it returns binary format of file. I have uninstall SSRS 2008 and install it again but fails. Even i have tried to use SSRS 2008 R2 and i did not find my required result.

Then during search i found missing components needs to install in SSRS 2008. I have used following link to download CR package for SSRS.

http://resources.businessobjects.com/support/additional_downloads/runtime.asp#09

List of components requried to install with sSRS 2008 can be
- Runtime Pre-requisites
- Microsoft .NET Framework v3.5 (x64)
- Microsoft Visual Studio 2008 64bit Prerequisites (x64)
- Microsoft Document Explorer 2008
- Microsoft Visual Studio Web Authoring Component
- Microsoft Visual Studio 2008
- Microsoft .NET Compact Framework 2.0 SP2
- Microsoft .NET Compact Framework 3.5
- Microsoft Visual Studio Tools for the Microsoft Office system (version 3.0 Runtime)
- Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System Runtime
- Microsoft SQL Server Compact 3.5
- Microsoft SQL Server Compact 3.5 Design Tools
- Microsoft SQL Server Compact 3.5 For Devices
- Windows Mobile 5.0 SDK R2 for Pocket PC
- Windows Mobile 5.0 SDK R2 for Smartphone
- Microsoft Device Emulator version 3.0 (x64)
- Microsoft SQL Server 2005 Express Edition
- Microsoft Visual Studio 2008 Remote Debugger (x64)
- Crystal Reports Basic for Visual Studio 2008
- Crystal Reports Basic 64-Bit Runtime for Visual Studio 2008
- Microsoft Windows SDK for Visual Studio 2008 Tools (x64)
- Microsoft Windows SDK for Visual Studio 2008 Headers and Libraries (x64)
- Microsoft Windows SDK for Visual Studio 2008 Win32 Tools (x64)
- Microsoft Windows SDK for Visual Studio 2008 .NET Framework Tools (x64)
- Microsoft Windows SDK for Visual Studio 2008 SDK Reference Assemblies and IntelliSense (x64)
- Microsoft SQL Publishing Wizard

More blogs are
http://msmvps.com/blogs/martinpoon/archive/2008/03/09/installing-components-full-installation-of-visual-studio-2008-professional-edition.aspx

Izdenda reporting Tool: An easy way to generate a report.

Build a sample report.
http://www.youtube.com/watch?v=N3uY9hi2UNQ

Handling report from sample dashboard
http://www.youtube.com/watch?v=5UT6pwMT3lM

SSRS is also a powerfull tool but Izenda have much more options.

Searching Multi key word in SQL Server 2005

There are many types of searches operators applies in SQL Server SQL to find related data. One of the most famous opeator is Like operator. When we need to search any character from a string we use like opeator and append %% with parameter like

Select * from tbl where columnname like '%xyz%';

Now if user wants to enable google type search and ask for searching Multicharacters at a time. Then we have another solution for that type of search example as follows

Now we can see we have I and a in parameter string and using cross apply query can easly search both values.

How it works
1. fn_Split is a self made function that return a table with one column and it has all values seperated by comma. In above example we have 2 rows with "I" and "a" values respectivly. 
2. Cross apply duplicates all data against each value of fn_split. In this example 10 rows generated five with joins for "I" and five with "a" .
3. Using "item" column in where clause instead of parameter name search for both characters from 10 rows.
4. Distinct clause removes duplicate records from result set.

Now if we need to impliment this in muliple tables and columns as mostly required we can easily get our required result. as shown in example

NOTE: Remember this is a space hungry query as much values you have in your parameter, data will be duplicated but this will help you to enable google like search in your application.