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