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
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.
@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
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.
User | Count |
---|---|
6 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
14 | |
5 | |
5 | |
4 | |
4 |