How to create crystal report by displaying the amounts c#

Question

Hi friends ,

I have 4 tables

decompte==>

create table decompte

(

Id_decompte int primary key identity NOT NULL,

Id_marche int foreign key references marche (Id_marche) NOT NULL,

Num_decompte varchar(100) COLLATE French_CI_AS NOT NULL,

Date_etablissement date,

Flag_dernier varchar(3) COLLATE French_CI_AS,

Montant_ttc decimal,

Retenue_garantie decimal,

Penalite_retard decimal,

Revision_prix decimal,

Autres_retenues decimal,

Retenue_source decimal,

Ind_supp INT DEFAULT 1,

User_create varchar(100) COLLATE French_CI_AS NOT NULL,

Date_create datetime DEFAULT getdate()NOT NULL,

User_modif varchar(100) COLLATE French_CI_AS ,

Date_modif datetime,

Retenue_avance decimal

)

marche==>

create table marche

(

Id_marche int primary key identity NOT NULL,

Id_site int foreign key references site (Id_site),

Num_marche varchar(100) COLLATE French_CI_AS NOT NULL,

Id_fournisseur int foreign key references fournisseur (Id_fournisseur),

Libelle_marche varchar(100) COLLATE French_CI_AS,

Date_demarrage datetime ,

Date_fin datetime,

Ind_supp INT DEFAULT 1,

User_create varchar(100) COLLATE French_CI_AS NOT NULL,

Date_create datetime DEFAULT getdate(),

User_modif varchar(100) COLLATE French_CI_AS ,

Date_modif datetime,

Type_marche varchar(100) COLLATE French_CI_AS ,

Description varchar(100) COLLATE French_CI_AS ,

Montant decimal NOT NULL,

Devise varchar(100) COLLATE French_CI_AS,

Budget varchar(100) COLLATE French_CI_AS,

Flag_cloture varchar(1) COLLATE French_CI_AS DEFAULT 'N'

)

fournisseur ==>

 

create table fournisseur

(

Id_fournisseur int primary key identity,

Code_fournisseur varchar(100) COLLATE French_CI_AS NOT NULL,

Libelle_fournisseur varchar(100) COLLATE French_CI_AS NOT NULL

)

Bon_reception_marche ==>

create table bon_reception_marche

(

Id_bon_reception_marche int primary key identity NOT NULL,

Id_marche int foreign key references marche(Id_marche),

Designation_bon_reception varchar(100) COLLATE French_CI_AS,

Num_bon_reception varchar(100) COLLATE French_CI_AS,

Date_commande date,

Date_reception date,

Unite varchar(50) COLLATE French_CI_AS,

Qte decimal,

Prix_unitaire decimal,

Montant decimal,

TVA decimal,

MO varchar(100) COLLATE French_CI_AS,

OT varchar(100) COLLATE French_CI_AS,

Ind_supp int DEFAULT 1,

User_create varchar(100) COLLATE French_CI_AS NOT NULL,

Date_create datetime DEFAULT getdate() NOT NULL,

User_modif varchar(100) COLLATE French_CI_AS ,

Date_modif varchar(100) COLLATE French_CI_AS,

)

 

And I have to create crystal report which like the

I have created a dataset that contains the data I want to display but I find

The problem is in the amounts it does not display even if I specified the datatype decimal or double

When i choose in the datatype string it works otherwise it does not work

Please can you help me this is a graduation project

thank you in advance