We have a grid that is fed by a dynamic dataview in one of our layers. This dataview will always have columns labeled 1 - X, depending on the number of returns. I have applied data rules to this successfully and wondered if there was a way to lock rows and columns in place using these data rules.
If not, is there another way to lock the top 3 rows and the 2 left most columns in place (ie keep them from moving when scrolling?
I have tried using the “Personalize Columns” section, but because of the nature of the dataview no columns show in this section.
Figured out the columns thing. Turns out I had to add build out the total columns needed for the dataset within the grid model. Thankfully this is easy as the columns come in numerically labeled. So after creating 120 columns in this grid, setting it to be able to display 200 so all 120 show and loading the data I can see the columns listed in the personalization section. Thus the user can now lock those columns to the grid using this setting:
Now I need a way to hide any row whose value is “” from the view so I dont have 50 populated columns and 70 that are blank and eating up space. I thought I would be able to do this in the data rules section, but that doesnt appear to be the case.
Any thoughts on how to dynamically hide columns based on the value in that column?
