Size of a qvw

[#1]

First sorry for my english.

i have a report that is bigger than 200 MB.

How can i reduce the size??? because it goes very slowly changing data from the pivot tables.

thanks.

[Anonymous]

The size depends also on the amount of data used in the report.

What you could do is to take a look at the data you load in the report ... is all data loaded needed ... (columns which are not used should be removed from the load ... etc etc)

[#3]

for example

DROP TABLES

DROP FIELDS

[Anonymous]

DROP tables ... this can only be done for temporary tables.

Just make sure only the used fields are LOADED, so not unnecessary fields ...

[Anonymous]

The size of file also increases if there are a lot of syntetic keys. If it is so, try to replace them wiht custom key fields.

But in general A Fuchten is right - try to reduce the amount of data you are loading in