Hi experts,
ich got a question about pretenting a global list, based on a relational SQL query to be claculated, as it costs loading time of the report. The report shows two areas A (at the top) and B (below A).
Both of the areas have a hyperblock including a relational list, but only one nedds to become calculated, the other one is just a loss of time.
The user will only be able to see one of them and switch the view from A to B and back. The rows as hided/displayed based on global variables. But according the perfomrance it it seems even when the rows are hided the list is being calculated.
Question is: How can I prevent the list withinthe hided area to be calculated? I thought adding to the query something like "where 1=0" should be sufficient, but in contrast to sql server where this syntax is very fast and faster than the query calculation, in application studio it alsways takes the same time without any difference.
Does anyone have an idea how to resolve this and save loading time/making the report faster?
Also thought about report design, but it makes sense having this two areas in one popUp report.
Kr,
Peter
