Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mng
Helper I
Helper I

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 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. 

 

img1 - calander.png

2 REPLIES 2
d_gosbell
Super User
Super User


@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

d_gosbell_0-1698016075771.png

 

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. 

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.