Groups in Crystal Report. Tutorial part - 2

This post is permanently moved at below URL

http://publisharticle.in/KB/C8EA8904E3514/Groups-in-Crystal-Report-Tutorial-part---2

Simple report using Crystal Reporting Tool. Tutorial part - 1

This post is permanently moved at below URL

http://publisharticle.in/kb/F50BB8763CCC4/Simple-report-using-Crystal-Reporting-Tool-Tutorial-part---1

Generate a report using Crystal Reports in Visual Studio 2010 tutorials.

This post is permanently moved at below URL

http://publisharticle.in/kb/1F7271EF64794/Generate-a-report-using-Crystal-Reports-in-Visual-Studio-2010-tutorials

How to remove dots signs viewed instead of spaces(White Space)?

Hi today I was developing my project and by mistake I pressed some combination of the key and VS replaces all the spaces with dots, like below figure

I have tried a lot to remove it but it took long time for me.
So I thought let me write a post about how to show/hide white space character from .cs file.











We can do it by 2 ways.

1. From Menu
Go To Edit → Advance → View White Space
Here is the screen shot

I have edited this images because it was very large.

And

Using Short Cuts.

There are two short cuts for this issue

1. Ctrl + R + W
2. Ctrl + E + S

Disable a trigger temporarily.

In my project I was thinking is it possible to disable all triggers temporarily?

Then answer is yes. We can disable it. The alternate is we can drop them and re-create it but it's not good way.

Any how to disable trigger it's not good idea because it can create a lot more issue with the data integrity. But you can perform this action when you alone are working on a database or in test environment or bulk inserting data.

But make sure once you have done your work enable all the trigger so you can maintain data integrity.

While you are importing bulk data then trigger should not fire once it's done then you have to fix to fire it again when actual data is coming.

Whenever I am doing this thing then I am disabling all the trigger using following command.

To disable all constraints and trigger:

sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"

To enable all constraints and trigger:

exec sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? ENABLE TRIGGER

Find Stored Procedure name with help of partial name (word).

Some times we want to find a stored procedure but don’t remember exactly sp name then it’s bit complex to find the whole name of the sp in Management Studio. But might be you know that SQL Server provides some system object from there we can easily finds the any object name. There are inbuilt tables which stores the all the details of table, view, sp, triggers, comment etc….

Like there is one table name sys.procedure which has all the information about available stored procedures.

If we want to find all the sp which starts name ‘adm’ then just write below qyery

select * from sys.procedures where name like 'adm%'

Like SP we can also find details about all the available tables in SQL Server.

select * from sys.tables where name like 'adm%'

above query will returns all the tables which starts with adm so we can use like clause as we are using in normal table.