Programming Heaven

Step 1 Create new Column as ID in Table with data type INT. Step 2 Update table with below query . ;WITH cte AS (     SELECT *, RowNum = ROW_NUMBER() OVER (ORDER BY GETDATE())     FROM  TableName ) UPDATE cte SET ID = RowNum + 1 WHERE (RowNum = RowNum) Step 3 Modify the ID column Identity (1,1)

How to   Display  Page Wise Total Amount And  Grand Total Amount in Last page SSRS & RDLC Report Step 1 Go to Project Menu >> Add Page Footer After click on the Add Footer Menu footer automatically add in the report. See Figure 1 Figure 1 Step 2 Add new TextBox for display page wise total and edit expression of TextBox . See Figure 2 Figure 2 Add this expression for page total TextBox =Sum(ReportItems!TotalAmount.Value) Step 3 Add new TextBox for display Grand Total in Last Page of RDLC report and edit expression of TextBox . See  Figure 3 Figure 3 =IIF( Globals.PageNumber =Globals.TotalPages,Sum(Fields!TotalAmount.Value, "DataSet1"),  "") Step 4 Run the application and test the reports Thanks Smruti

Today I am going to give you the tips and tricks on Sql Server Database Management. This is a common problem for Database developer when they are working on different database servers connected on a single machine. It is very difficult to identify on which server u r connected or executing on which server. SSMS (Sql Server Management Studio ) gives  gives u the facility to easily identify on which server u r currently working on. Follow the Simple Steps Below..