I'm probably missing something obvious but thought I would ask here. I am working on developing various Velixo reports in Excel and trying to structure it so that multiple separate queries can be displayed one after another vertically—each showing a different set of data. The challenge I'm facing is that when the first query expands (i.e., returns more rows than expected), it overlaps the second query below it. This also applies when I want to have manual formatting of subtotals etc in report (i.e. I want all asset accounts in the balance sheet shown in one section then have the liabilities below in a second query to allow me to have a formatted subtotal and gap).
I.e. when I run a query for a given branch/duration the resulting list of data can vary greatly.
I’m aware of the Auto Hide Rows feature, which works great for hiding unused rows within the query range itself, but it doesn’t seem to help with hiding rows that aren't part of the resulting query range or how I can use the structuring to just arrange for the automatic shifting the next query down to make room for the expanded data above.
Is there a best practice or recommended method in Velixo for dynamically stacking queries or making room for variable result lenght like this?
Any tips or examples would be greatly appreciated!
0 Votes
Hi everyone,
I'm probably missing something obvious but thought I would ask here. I am working on developing various Velixo reports in Excel and trying to structure it so that multiple separate queries can be displayed one after another vertically—each showing a different set of data. The challenge I'm facing is that when the first query expands (i.e., returns more rows than expected), it overlaps the second query below it. This also applies when I want to have manual formatting of subtotals etc in report (i.e. I want all asset accounts in the balance sheet shown in one section then have the liabilities below in a second query to allow me to have a formatted subtotal and gap).
I.e. when I run a query for a given branch/duration the resulting list of data can vary greatly.
I’m aware of the Auto Hide Rows feature, which works great for hiding unused rows within the query range itself, but it doesn’t seem to help with hiding rows that aren't part of the resulting query range or how I can use the structuring to just arrange for the automatic shifting the next query down to make room for the expanded data above.
Is there a best practice or recommended method in Velixo for dynamically stacking queries or making room for variable result lenght like this?
Any tips or examples would be greatly appreciated!
Thanks in advance
0 Votes
0 Comments
Login or Sign up to post a comment