Forum Discussion

mng's avatar
mng
Icon for Advocate I rankAdvocate I
2 years ago

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

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 bas...
Need Help
NEED HELP Paginated Report
report builder
SSRS
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
2 years ago
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

 

  • mng's avatar
    mng
    Icon for Advocate I rankAdvocate I
    2 years ago

    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.