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 |
|
tomstone
Starting Member
4 Posts |
 Posted - 2012-05-07 : 14:26:36
|
| I want to set the background color expression (for every cell in a row) to something like ... =iif( [@selected_date] = fields!rpt_date.value, "Blue", iif( RowNumber(Nothing) Mod 2, "#f0ffff", "White") )i.e. when the user runs a sub report for a selected row in the tablix, I want the row to be highlighted so that when the user comes back to the calling report the row they selected is still highlighted.... maybe the question should be ... how do I set a parameter value when the user selects a row (in my case the user selects an image on the row that has an action associated with it that calls a sub report)?i.e. somthing like ... set Parameters!selected_date.Value=Fields!rpt_date.ValueThomas StonePrincipal Software and Database Consultantemail: The.Stone.Group@gmail.comoffice: 770-361-1870 The Stone Group, Inc.Serving Georgia’s EMCs since 19951025 Thimblegate Court, Johns Creek, GA 30022 This message contains confidential information that may be privileged and proprietary. If you are not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or conversion to hard copy or other use of this communication is strictly prohibited. Please notify The.Stone.Group@gmail.com immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Thomas Stone or The Stone Group, Inc. therefore do not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-07 : 17:17:02
|
| you can pass selected rows values through parameter using jump to url or jump to report properties------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tomstone
Starting Member
4 Posts |
Posted - 2012-05-08 : 11:38:02
|
| I will attempt to simplify the question.How can a set the value of a parameter with an expression when the user activates an action associated with an image for a row in a tablix? I would like to use something like RowNumber, or a field value for the selected row. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-08 : 12:42:57
|
| you'll have an action associated with image click like navigating to url or report right? then you can include the expression for parameter in url or inside report details tab in jump to reportif it still doesnt answer question please explain what exact action you're doing with clicking image------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
tomstone
Starting Member
4 Posts |
Posted - 2012-05-08 : 13:05:45
|
| - rdl A has tablix with several rows.- each row has an image which has an action that calls rdl B and passes field values from the row into rdl B.- I want a parameter in rdl A to be set when the user selects the image in row N. I want the value of this parameter to indicate that row N was selected.- I will use the value of the parameter to highlight row N in rdl A.Thomas StonePrincipal Software and Database Consultantemail: The.Stone.Group@gmail.comoffice: 770-361-1870 The Stone Group, Inc.Serving Georgia’s EMCs since 19951025 Thimblegate Court, Johns Creek, GA 30022 This message contains confidential information that may be privileged and proprietary. If you are not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or conversion to hard copy or other use of this communication is strictly prohibited. Please notify The.Stone.Group@gmail.com immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Thomas Stone or The Stone Group, Inc. therefore do not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-08 : 16:34:57
|
quote:
Originally posted by tomstone
- rdl A has tablix with several rows.- each row has an image which has an action that calls rdl B and passes field values from the row into rdl B.- I want a parameter in rdl A to be set when the user selects the image in row N. I want the value of this parameter to indicate that row N was selected.- I will use the value of the parameter to highlight row N in rdl A.Thomas StonePrincipal Software and Database Consultantemail: The.Stone.Group@gmail.comoffice: 770-361-1870 The Stone Group, Inc.Serving Georgia’s EMCs since 19951025 Thimblegate Court, Johns Creek, GA 30022 This message contains confidential information that may be privileged and proprietary. If you are not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or conversion to hard copy or other use of this communication is strictly prohibited. Please notify The.Stone.Group@gmail.com immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Thomas Stone or The Stone Group, Inc. therefore do not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
Ok for that you need to write a customcode and pass parameter object to it. then inside set value for parameter based on passed value.just call it like=Code.YourFunctionName(Parameters!Yourparam,Fields!RowNumberField.Value)inside customcode do likePublic Function YourFunctionName(ByVal paramName as Parameter,ByVal FieldVal as Parameter)parameter.value = FieldValEnd Function ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
tomstone
Starting Member
4 Posts |
Posted - 2012-05-08 : 16:41:25
|
| What triggers this custom code?Thomas StonePrincipal Software and Database Consultantemail: The.Stone.Group@gmail.comoffice: 770-361-1870 The Stone Group, Inc.Serving Georgia’s EMCs since 19951025 Thimblegate Court, Johns Creek, GA 30022 This message contains confidential information that may be privileged and proprietary. If you are not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or conversion to hard copy or other use of this communication is strictly prohibited. Please notify The.Stone.Group@gmail.com immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Thomas Stone or The Stone Group, Inc. therefore do not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-08 : 16:59:42
|
| Clicking on image. You can set this via action property of image------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
Highlighting a row that user has selected