I saw there is Stretch Height, Float, and Remove When Blank or Hidden field settings. Is it possible to use these settings to have a row of columns/fields stretch depending on how many columns have value?
For example, if I had cols 1-12. Each column takes up 60px width across 720px. If columns 4-12 were blank, columns 1-3 would stretch width to 240px each filling the entire 720px.
Report Builder doesn’t support automatically resizing columns horizontally.
Typically for these types of scenarios, we see report devs get creative, and do things like stacking content and conditionally hide/showing them based on incoming data. This works for like 2 resize options, not up to 12 though. Depending on what your use case is, there may be a solution that gets things pretty close to what you’re wanting to do.
Hi @jeremy.keller are there any options for Interactive Reports - specifically to hide empty columns/fields? Thanks
IR does not perform any hide/show logic. What is the use case scenario for this though? There may be other options available to achieve what you want to do.
Thanks @jeremy.keller we have a rather large change log report requirement, the idea is to keep it agnostic, but between environments most fields/columns will remain empty.
I would recommend getting a barebones report (either through report builder or IR) with the data that you want to exist, then work on formatting based on that. Feel free to message me directly or tag me on a thread here if you want my expertise once you get that going.