Monday, 4 November 2019

Take Data Offline Using Microsoft Synchronization Services for ADO.NET

Take Data Offline Using Microsoft Synchronization Services for ADO.NET


To view click on below link

How to Synchronize data local To server and Server to Local Database using C# 4.0 (Window application Software )


How to Synchronize data local To server and Server to Local Database using C# 4.0 (Window application Software )


Sir,
I Am Working on Windows Application that Run in Different location My application Name is Transport Management Software which in Work in local Machine work properly and Clint Want To This software Run Also his another branches (He have 5 branches) he store database in Server and use database from Serve

But he want to also Work in local Machine where does not having net connection but he want to Synchronize data from local to server and Server to local when one or two days net connection..

Sir for this task I am using Microsoft synchronization Microsoft Sync Framework in C# 2.1 dll file . but not any idea to work on that please Suggest me how to perform synchronization operation .. in transport application

How to get sum by groups in Crystal Report

How to get sum by groups in Crystal Report



  1. Right Click field which you want to Sum
  2. Select Insert -> Summary and select Group On field below on the same dialog window
  3. Click Ok

How to get sum by groups in Crystal Report

How to get sum by groups in Crystal Report


I want to get the sum by the groups in Crystal Reports.
Group OVERALL
-----------------
      group 1
     --------------
          5.00
          5.00
         10.00
     --------------
     total group 1      20.00
     --------------
      group 2
      --------------
         10.00
         25.00
         15.00
      --------------
     total group 2      50.00
-------------------
Total Group OVERALL     70.00
Using this formula sum({field.amount}, {field.group}) I only get sum for OVERALL but not for group 1 and 2.

crystal report is not showing one column in group expert


Crystal report is not showing one column in group expert
SOLUTION
The problem Was Column Name's DataType was varchar (max)
In crystal Report If U want to do Group then It Should have Fix Size of DataType it can be of varchar(1000) but it should not varchar(max)

crystal report is not showing one column in group expert

crystal report is not showing one column in group expert


Im using crystal reports with visual studio 2010 and sql server 2008
I've major problem in grouping data
i.e.
Whenever we click on group expert All columns are visible in group expert but in my case name column which I'm using to group data is not visible in group expert...
I've tried binding of stored procedure and view
please tell me how to fix it...

Wednesday, 30 October 2019

VS2012 Crystal Report Viewer Group Tree Hide

VS2012 Crystal Report Viewer Group Tree Hide



Try to turn Off

CrystalReportViewer.ToolPanelView = ToolPanelViewType.None
Try to turn On
CrystalReportViewer.ToolPanelView = ToolPanelViewType.GroupTree