topic Re: Report Builder - Conditional Border for each text box in calendar format in Report Server

Report Builder - Conditional Border for each text box in calendar format

mng — Fri, 20 Oct 2023 18:29:36 GMT

Hi, I'm trying to replicate an existing feature on a report but I think my understanding of using parameters is hindering me from this replication. This feature creates a border around textboxes based on a condition.

I actually wrote a lot of information that I'm afraid will just confuse folks, so i'll just ask and if its not clear still, I'd be happy to provide more information.

Does anyone know how the variables "StartDay and "SwitchDays" would be designed in the report? I understand the logic of the expressions I just don't understand how to build this on the backend.

Re: Report Builder - Conditional Border for each text box in calendar format

d_gosbell — Sun, 22 Oct 2023 23:08:03 GMT

mng wrote:

Does anyone know how the variables "StartDay and "SwitchDays" would be designed in the report?

What do you mean by "designed"? Are you asking how you manually add parameters to a report? If so you can do this by right-clicking on the parameters folder and choosing the add parameter option

Re: Report Builder - Conditional Border for each text box in calendar format

mng — Mon, 23 Oct 2023 19:39:04 GMT

I just realized this is probably an SQL question, not sure why that didn't hit me before.

My "how to design" question was to get help understanding how the query would be written for the parameters in the calendar tables.

The parameter would be set from a column of dates but I'm struggling on how to set essentially 3 variables in sql using that column of dates for those 3 calendar months in report builder to create those borders around the dates.