[SOLVED] Query with fields advice request

PointsWell

I'm trying to build a query that has some summary data at the top.

I can't use a form with a relationship grid because the form won't size to 100% of the available space. I'd like to ensure that the grid fills the space available for the sake of UI consistency.

The results are shown in a VP and that VP gets filled with different queries at different times based on user selection.

The summary data is not a straightforward summary of columns in the grid, so I can't use the summary functionality within the grid. But I have collected the data on a BO that is related to the query results.

Does anyone have any suggestions as I'm kinda stumped at the moment.

tford

Is there a reason you can't use an HTML panel on the VP to present the summary info?

PointsWell

None beyond not knowing how to do that.

Would that cope with fill to bottom of the screen / screen resize issue? Also not sure where I would put the HTML document in the Aware objects structure.

Is there a Youtube video that would lay it out? Or do you have an example to hand that you could share/point me to

customaware

Draw us a picture of what you want Sean

PointsWell

Looks sort of like this.

The data in the image is representative but nonsense (obviously)

The section in red is the parent form. The buttons on the parent form fill the area in black with query results. In all other cases the results are straightforward. In this case I am challenged by the fact that I need to provide a summary of data from the query.

At the moment the area in green is being added to the parent BO in the red section, but other than processing time there is no reason why it couldn't be calculated on the fly.

The area in the black has been filled with queries as these allow for "Fill to bottom of screen" which is responsive to the size of the screen and don't require me to specify how large the grid is.

tford

So, what are you trying to fix in your pic?

PointsWell

I don't know how to get the area in green to show on the query results.

customaware

You can use html in the Query Header for those figures Sean

PointsWell

eagles9999 wrote
You can use html in the Query Header for those figures Sean

Yay - This is why I ask you guys!

Where do I do that (its a standard query) - or is there an example somewhere that I can crib from?

customaware

In the Hamburger menu for the Query.... Panel Header.... drop your html in the Custom Header

PointsWell

Thank you! Just what I needed