| Author |
Topic |
|
Ciupaz
Posting Yak Master
232 Posts |
 Posted - 2011-08-17 : 04:37:09
|
| Hi all,with Reporting Services of SQL Server 2000, how can I show decimal values in my report with point (.) separator decimals, instead of comma (,) that appears now, without changing the default language of the report? Thanks in advance. Luigi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-17 : 05:06:13
|
| you need to change the standard formats in cell properties------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2011-08-17 : 05:25:06
|
| And what is the Format for change the comma with the point? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-17 : 05:31:47
|
| its N1, N2 etc depending on how many digits you want after decimal------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2011-08-17 : 05:47:53
|
| Ok, but I have a problem. This cell has already a Format expression, this one: =IIF( ((Fields!UnitaProduttive_ID.Value>=0) OR (Fields!UnitaProduttive_ID.Value < -4) ) ,"N1","N2")Is it possibile to "merge" this expression with something like: =iif(Fields!DescrizioneUnitaProduttiva.Value = "Totale al Blindato di Mese", .....)Luigi |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-17 : 05:59:37
|
| sorry didnt understand the merge part. do you mean add the extra condition also? if yes, you can add with another OR condition. if this is an additional check i think you need to use nested iifs or use switch------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2011-08-17 : 08:15:49
|
| Yes, I've solved with a nested IIF. Now a little adding.I need to change the font size of the value cell if the description has an ID that I can get with another Dataset (I don't have this value in my Dataset).Is it possible to solve this? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-17 : 09:59:53
|
| will that datset have only single id value?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2011-08-17 : 10:15:21
|
| Yes, I've solved with a nested IIF. Now a little adding.I need to change the font size of the value cell if the description has an ID that I can get with another Dataset (I don't have this value in my Dataset).Is it possible to solve this? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-18 : 04:43:00
|
| is that dataset having a single value? if not, how would you determine what value to be retrieved. is there some way it can be related to main dataset------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2011-08-18 : 09:10:59
|
| I've solved adding the missing value in the first Dataset. I've not found a way to merge 2 distinct Datasets.Luigi |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-18 : 09:38:02
|
| there's not any way to merge datasets------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Replace comma with point in decimal values