Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simflex
Constraint Violating Yak Guru
327 Posts |
 Posted - 2010-04-15 : 10:51:00
|
| Hi mates,I have 2 questions regarding the SRS(2005).How do I drag and drop popup calendar so user can select dates rather than type them in?Second, is it possible to set up alternating color highlighter so color changes from row to row? If yes, how?A solution to any or both questions would be greatly appreciated. |
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2010-04-15 : 12:13:26
|
| I searched through the forum and found this code:=Iif(RowNumber(Nothing) Mod 2=0,"Silver", "Transparent")It seems to work in terms of alternating row colors between Silver and Transparent.The problem is that is changing the actual values, not the background color which is what I really want to change.Can you please tell me what's wrong?Am I putting the above at the wrong place?Please respond.Thank you. |
 |
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2010-04-15 : 16:11:38
|
Ok, I have solved the 2 problems I posted but need one more help.Can someone, please help.What I am trying to do is bold 3 sub headers.This one below works fine.=IIF(Fields!Incident.Value="Hazards", "Bold", "Normal") However, I have 3 sub headers that I need to bolder programmatically.I tried CASE statement:Case (WHEN =Fields!Incident.Value="Hazards" Then "Bold")else (WHEN =Fields!Incident.Value="Grease" Then "Bold")Else (WHEN =Fields!Incident.Value="Hazards" Then "Bold")Else ="Normal"I don't know if SRS (2005) accepts CASE Statement but I will appreciate your assistance. |
|
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2010-04-15 : 22:00:31
|
| Good Gracious.This part of the forum is... hmm |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2010-04-16 : 13:58:40
|
quote:
Originally posted by simflex
How do I drag and drop popup calendar so user can select dates rather than type them in?
If the parameter datatype is date, it would automatically display a popup calendar icon besides the text box. |
|
|
|
|
|
|
|
|
Date icon