reporting services - Conditional formatting on multi page SQL Server Report (SSRS) -


i have report uses conditional formatting change font color , background color of text box containing expression using switch statement.

the text box shows value =reportitems!despatchmethod.value , have applied conditional formatting both background colour (fill) , font colour doing following:

for background colour:

=switch(fields!blackdespmethod.value = "true", "black", fields!blackdespmethod.value = "false", "white")

for font colour:

=switch(fields!blackdespmethod.value = "true", "white", fields!blackdespmethod.value = "false", "black")

the switch statement looking @ field in dataset called blackdespmethod either true or false. used determine formatting applied text box

this works fine if report single page - if value of blackdespmethod true colors change should. however, if report runs multiple pages (i.e. more 1 record in dataset) not work correctly.

for example, if report returns 40 records , first value returned blackdespmethod false, formatting not apply third record value returned true - applies false formatting pages. likewise if first value true applies formatting pages

i've tried using iif statements , worked in same way. i've considered using visibility show/hide different versions of text box based on value being true or false, due number of variations (and potential future changes) of values within despatchmethod.value rather avoid that.

the value of expression within cell correct every record (i have triple checked data in sql against report shows), formatting not being applied correctly.

any appreciated! couldn't find else having same problem me. bug in ssrs? unfortunately not experienced ssrs or instruction on how fix appreciated (in other words please excuse lack of understanding if make complex suggestion or answer).


Comments

Post a Comment

Popular posts from this blog

javascript - Google App Script ContentService downloadAsFile not working -

i have web app developed using google app script htmlservice , html form, populating excel sheet in google drive using spreadsheetapp . , 1 section calling contentservice download data excel file. function doget(e) { // read excel sheet //getappfile(); // render application html template return htmlservice.createtemplatefromfile('index').evaluate() .settitle('go smart') .setsandboxmode(htmlservice.sandboxmode.iframe); } function downloaddoublequatecsvfile() { var sheetid = propertiesservice.getscriptproperties().getproperty('sheetid'); var ss = spreadsheetapp.openbyid(sheetid).getactivesheet(); //var ss = spreadsheetapp.getactivespreadsheet().getactivesheet(); var maxcolumn = ss.getlastcolumn(); var maxrow = ss.getlastrow(); var data = ss.getrange(1, 1, maxrow, maxcolumn).getvalues(); if (data.length > 1) { var csv = ""; (var row = 0; row < data.length; row++) { (var c...
Read more

javascript - Function overwritting -

is there way overwrite function or event handling in function? using addeventlistener, can have many event handlers on element want var test=document.getelementbyid("div"); test.addeventlistener("click",function(){alert("im first");},false); test.addeventlistener("click",function(){alert("im second");},false); // alerts "im first" , after "im second" but if want overwrite function/event example based on client width example this function one() { alert("first"); } function two() { alert("second"); } window.onresize = function() { var test = document.getelementbyid("div"); if (window.innerwidth > 500) { test.onclick = 1 } else { test.onclick = two; } } is possible in javascript? in case use effective little known approach. addeventlistener can accept object property handleevent event handler. in case it's easy overwr...
Read more

php - Find a regex to take part of Email -

i have following emails need extract part from: bestellnummer xxx: 1 von xxx, 1er pack ------------- anfang der nachricht ------------- foo bar baz foo bar baz // <<<<< need text here ------------- ende der nachricht ------------- ------------- anfang der nachricht ------------- foo bar baz foo bar baz ------------- ende der nachricht ------------- there 0 unlimited occurences of ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- and i'm able extract first part regex: $re = "/------------- .*? -------------.?(.*?).?------------- .*? -------------/s"; but, i'm quite new on learning regex, i'm pretty sure there must better regex extract part (foo bar baz foo bar baz) of text between ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- as can in different languages, i'm using .? to match between hyphens. i...
Read more