=cInt(Fields!Field1.Value / 1000) * 1000
Friday, 25 July 2014
Tuesday, 22 July 2014
SSRS: Error: The user or group name ‘CustomerDomain\SomeUser’ is not recognized
Hi
all,
When
installing SSRS on a installation where the database was a backup of a
customor’s setup, I got the following error:
An
error occurred while adding users ‘CustomerDomain\SomeUser’,'Domain\SomeUser2′
to the SQL Server Reporting Services DynamicsAXBrowser role in the folder
DynamicsAX. The error is: The user or group name ‘CustomerDomain\SomeUser’ is
not recognized..
The solution was to remove all records in the SysServerSessions
table and restart the AOS.
Monday, 7 July 2014
How to Display Checkbox on SSRS Report
A textbox with Wingdings font type can be used to display a checkbox on a report which is checked based on a value in a dataset. Wingdings are a series of fonts which render letters as a variety of symbols.
Select a text box:
Change a font family to Windings:
In a Value type the following expression:
- In my case the Fields!active.Value returns True or False, but it can be any type of value
Run the report to see check boxes:
When used chr(0238), a falling arrow is displayed instead:
=iif(Fields!active.Value,chr(0238),“o”)
List of possible characters in the Wingdings font are displayed below:
| Wingdings | |||
| Character |
Dec
|
Hex
|
PS Name
|
| ‘‘ |
32
|
0×20
| space |
| |
33
|
0×21
| pencil |
| |
34
|
0×22
| scissors |
| |
35
|
0×23
| scissorscutting |
| |
36
|
0×24
| readingglasses |
| |
37
|
0×25
| bell |
| |
38
|
0×26
| book |
| |
39
|
0×27
| candle |
| |
40
|
0×28
| telephonesolid |
| |
41
|
0×29
| telhandsetcirc |
| |
42
|
0x2A
| envelopeback |
| |
43
|
0x2B
| envelopefront |
| |
44
|
0x2C
| mailboxflagdwn |
| |
45
|
0x2D
| mailboxflagup |
| |
46
|
0x2E
| mailbxopnflgup |
| |
47
|
0x2F
| mailbxopnflgdwn |
| |
48
|
0×30
| folder |
| |
49
|
0×31
| folderopen |
| |
50
|
0×32
| filetalltext1 |
| |
51
|
0×33
| filetalltext |
| |
52
|
0×34
| filetalltext3 |
| |
53
|
0×35
| filecabinet |
| |
54
|
0×36
| hourglass |
| |
55
|
0×37
| keyboard |
| |
56
|
0×38
| mouse2button |
| |
57
|
0×39
| ballpoint |
| |
58
|
0x3A
| pc |
| |
59
|
0x3B
| harddisk |
| |
60
|
0x3C
| floppy3 |
| |
61
|
0x3D
| floppy5 |
| |
62
|
0x3E
| tapereel |
| |
63
|
0x3F
| handwrite |
| |
64
|
0×40
| handwriteleft |
| |
65
|
0×41
| handv |
| |
66
|
0×42
| handok |
| |
67
|
0×43
| thumbup |
| |
68
|
0×44
| thumbdown |
| |
69
|
0×45
| handptleft |
| |
70
|
0×46
| handptright |
| |
71
|
0×47
| handptup |
| |
72
|
0×48
| handptdown |
| |
73
|
0×49
| handhalt |
| |
74
|
0x4A
| smileface |
| |
75
|
0x4B
| neutralface |
| |
76
|
0x4C
| frownface |
| |
77
|
0x4D
| bomb |
| |
78
|
0x4E
| skullcrossbones |
| |
79
|
0x4F
| flag |
| |
80
|
0×50
| pennant |
| |
81
|
0×51
| airplane |
| |
82
|
0×52
| sunshine |
| |
83
|
0×53
| droplet |
| |
84
|
0×54
| snowflake |
| |
85
|
0×55
| crossoutline |
| |
86
|
0×56
| crossshadow |
| |
87
|
0×57
| crossceltic |
| |
88
|
0×58
| crossmaltese |
| |
89
|
0×59
| starofdavid |
| |
90
|
0x5A
| crescentstar |
| |
91
|
0x5B
| yinyang |
| |
92
|
0x5C
| om |
| |
93
|
0x5D
| wheel |
| |
94
|
0x5E
| aries |
| |
95
|
0x5F
| taurus |
| |
96
|
0×60
| gemini |
| |
97
|
0×61
| cancer |
| |
98
|
0×62
| leo |
| |
99
|
0×63
| virgo |
| |
100
|
0×64
| libra |
| |
101
|
0×65
| scorpio |
| |
102
|
0×66
| saggitarius |
| |
103
|
0×67
| capricorn |
| |
104
|
0×68
| aquarius |
| |
105
|
0×69
| pisces |
| |
106
|
0x6A
| ampersanditlc |
| |
107
|
0x6B
| ampersandit |
| |
108
|
0x6C
| circle6 |
| |
109
|
0x6D
| circleshadowdwn |
| |
110
|
0x6E
| square6 |
| |
111
|
0x6F
| box3 |
| |
112
|
0×70
| box4 |
| |
113
|
0×71
| boxshadowdwn |
| |
114
|
0×72
| boxshadowup |
| |
115
|
0×73
| lozenge4 |
| |
116
|
0×74
| lozenge6 |
| |
117
|
0×75
| rhombus6 |
| |
118
|
0×76
| xrhombus |
| |
119
|
0×77
| rhombus4 |
| |
120
|
0×78
| clear |
| |
121
|
0×79
| escape |
| |
122
|
0x7A
| command |
| |
123
|
0x7B
| rosette |
| |
124
|
0x7C
| rosettesolid |
| |
125
|
0x7D
| quotedbllftbld |
| |
126
|
0x7E
| quotedblrtbld |
| |
127
|
0x7F
| .notdef |
| |
128
|
0×80
| zerosans |
| |
129
|
0×81
| onesans |
| |
130
|
0×82
| twosans |
| |
131
|
0×83
| threesans |
| |
132
|
0×84
| foursans |
| |
133
|
0×85
| fivesans |
| |
134
|
0×86
| sixsans |
| |
135
|
0×87
| sevensans |
| |
136
|
0×88
| eightsans |
| |
137
|
0×89
| ninesans |
| |
138
|
0x8A
| tensans |
| |
139
|
0x8B
| zerosansinv |
| |
140
|
0x8C
| onesansinv |
| |
141
|
0x8D
| twosansinv |
| |
142
|
0x8E
| threesansinv |
| |
143
|
0x8F
| foursansinv |
| |
144
|
0×90
| fivesansinv |
| |
145
|
0×91
| sixsansinv |
| |
146
|
0×92
| sevensansinv |
| |
147
|
0×93
| eightsansinv |
| |
148
|
0×94
| ninesansinv |
| |
149
|
0×95
| tensansinv |
| |
150
|
0×96
| budleafne |
| |
151
|
0×97
| budleafnw |
| |
152
|
0×98
| budleafsw |
| |
153
|
0×99
| budleafse |
| |
154
|
0x9A
| vineleafboldne |
| |
155
|
0x9B
| vineleafboldnw |
| |
156
|
0x9C
| vineleafboldsw |
| |
157
|
0x9D
| vineleafboldse |
| |
158
|
0x9E
| circle2 |
| |
159
|
0x9F
| circle4 |
| |
160
|
0xA0
| square2 |
| |
161
|
0xA1
| ring2 |
| |
162
|
0xA2
| ring4 |
| |
163
|
0xA3
| ring6 |
| |
164
|
0xA4
| ringbutton2 |
| |
165
|
0xA5
| target |
| |
166
|
0xA6
| circleshadowup |
| |
167
|
0xA7
| square4 |
| |
168
|
0xA8
| box2 |
| |
169
|
0xA9
| tristar2 |
| |
170
|
0xAA
| crosstar2 |
| |
171
|
0xAB
| pentastar2 |
| |
172
|
0xAC
| hexstar2 |
173
|
0xAD
| octastar2 | |
| |
174
|
0xAE
| dodecastar3 |
| |
175
|
0xAF
| octastar4 |
| |
176
|
0xB0
| registersquare |
| |
177
|
0xB1
| registercircle |
| |
178
|
0xB2
| cuspopen |
| |
179
|
0xB3
| cuspopen1 |
| |
180
|
0xB4
| query |
| |
181
|
0xB5
| circlestar |
| |
182
|
0xB6
| starshadow |
| |
183
|
0xB7
| oneoclock |
| |
184
|
0xB8
| twooclock |
| |
185
|
0xB9
| threeoclock |
| |
186
|
0xBA
| fouroclock |
| |
187
|
0xBB
| fiveoclock |
| |
188
|
0xBC
| sixoclock |
| |
189
|
0xBD
| sevenoclock |
| |
190
|
0xBE
| eightoclock |
| |
191
|
0xBF
| nineoclock |
| |
192
|
0xC0
| tenoclock |
| |
193
|
0xC1
| elevenoclock |
| |
194
|
0xC2
| twelveoclock |
| |
195
|
0xC3
| arrowdwnleft1 |
| |
196
|
0xC4
| arrowdwnrt1 |
| |
197
|
0xC5
| arrowupleft1 |
| |
198
|
0xC6
| arrowuprt1 |
| |
199
|
0xC7
| arrowleftup1 |
| |
200
|
0xC8
| arrowrtup1 |
| |
201
|
0xC9
| arrowleftdwn1 |
| |
202
|
0xCA
| arrowrtdwn1 |
| |
203
|
0xCB
| quiltsquare2 |
| |
204
|
0xCC
| quiltsquare2inv |
| |
205
|
0xCD
| leafccwsw |
| |
206
|
0xCE
| leafccwnw |
| |
207
|
0xCF
| leafccwse |
| |
208
|
0xD0
| leafccwne |
| |
209
|
0xD1
| leafnw |
| |
210
|
0xD2
| leafsw |
| |
211
|
0xD3
| leafne |
| |
212
|
0xD4
| leafse |
| |
213
|
0xD5
| deleteleft |
| |
214
|
0xD6
| deleteright |
| |
215
|
0xD7
| head2left |
| |
216
|
0xD8
| head2right |
| |
217
|
0xD9
| head2up |
| |
218
|
0xDA
| head2down |
| |
219
|
0xDB
| circleleft |
| |
220
|
0xDC
| circleright |
| |
221
|
0xDD
| circleup |
| |
222
|
0xDE
| circledown |
| |
223
|
0xDF
| barb2left |
| |
224
|
0xE0
| barb2right |
| |
225
|
0xE1
| barb2up |
| |
226
|
0xE2
| barb2down |
| |
227
|
0xE3
| barb2nw |
| |
228
|
0xE4
| barb2ne |
| |
229
|
0xE5
| barb2sw |
| |
230
|
0xE6
| barb2se |
| |
231
|
0xE7
| barb4left |
| |
232
|
0xE8
| barb4right |
| |
233
|
0xE9
| barb4up |
| |
234
|
0xEA
| barb4down |
| |
235
|
0xEB
| barb4nw |
| |
236
|
0xEC
| barb4ne |
| |
237
|
0xED
| barb4sw |
| |
238
|
0xEE
| barb4se |
| |
239
|
0xEF
| bleft |
| |
240
|
0xF0
| bright |
| |
241
|
0xF1
| bup |
| |
242
|
0xF2
| bdown |
| |
243
|
0xF3
| bleftright |
| |
244
|
0xF4
| bupdown |
| |
245
|
0xF5
| bnw |
| |
246
|
0xF6
| bne |
| |
247
|
0xF7
| bsw |
| |
248
|
0xF8
| bse |
| |
249
|
0xF9
| bdash1 |
| |
250
|
0xFA
| bdash2 |
| |
251
|
0xFB
| xmarkbld |
| |
252
|
0xFC
| checkbld |
| |
253
|
0xFD
| boxxmarkbld |
| |
254
|
0xFE
| boxcheckbld |
| |
255
|
0xFF
| windowslogo |
Subscribe to:
Posts (Atom)