[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 ?

You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610