Thursday, June 27, 2013

[SQL 2012] calculated fields in SSRS report

[SQL 2012] calculated fields in SSRS report


calculated fields in SSRS report

Posted: 26 Jun 2013 07:20 PM PDT

Hello all i want to add a calculated field in my report this is what i want to put in the expression of my calculated fieldIF UNITE_COUT_MATERIEL = Unité THEN (SUPERFICIE_INTER_CULTURE / SUPERFICIE_INTER) * QUANTITE_MATERIELIF UNITE_COUT_MATERIEL = h THEN (SUPERFICIE_INTER_CULTURE / SUPERFICIE_INTER) * DUREE_UTILISATION_MATERIELi put it like this : =Switch(Fields!UNITE_COUT_MATERIEL.Value = "Unité","(Fields!SUPERFICIE_INTER_CULTURE.Value/ Fields!SUPERFICIE_INTER.Value) * Fields!QUANTITE_MATERIEL.Value",Fields!UNITE_COUT_MATERIEL.Value = "h","(Fields!SUPERFICIE_INTER_CULTURE.Value / Fields!SUPERFICIE_INTER.Value) * Fields!DUREE_UTILISATION_MATERIEL.Value")when a execute my report i have just the expression in the report any idea please ?

No comments:

Post a Comment

Search This Blog