This is the technique format property of dates
=switch(fields!mylocale.value="DE" ,"d.MM.yy" ,fields!mylocale.value ="UK","d/MM/YY",
feilds!mylocale.value="US","M/d/YY")
This is the technique format property of currency
=switch(fields!mylocale.value="DE" ,"de-DE" ,fields!mylocale.value ="UK","en-GB",
feilds!mylocale.value="US","en-US")
Monday, August 24, 2009
How to display the alternate rows in different color ?
In ssrs you can select detail section of the report
goto the properties,on color goto the expressions--->
write a code
=IIF(ROWNUMBER(NOTHING) MOD 2,"RED","GREEN")
goto the properties,on color goto the expressions--->
write a code
=IIF(ROWNUMBER(NOTHING) MOD 2,"RED","GREEN")
Subscribe to:
Comments (Atom)
Search This Blog
DAX - Grouping on multiple columns and the count
Please go thorugh the below URL for entire soultion. http://community.powerbi.com/t5/Desktop/DAX-Grouping-on-multiple-columns-and-the-cou...
-
Synchronous vs Asynchronous The SSIS dataflow contain three types of transformations. They can be non-blocking, semi-blocking or full...
-
--SHRINKFILE and TRUNCATE Log File in SQL Server SELECT DB_NAME(database_id) AS DatabaseName, Physical_Name, Name AS Logical_Na...
-
The main statement used to retrieve data in T-SQL is the SELECT statement. Following are the main query clauses specified in the order that...