Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
for example
DROP TABLES
DROP FIELDS
DROP tables ... this can only be done for temporary tables.
Just make sure only the used fields are LOADED, so not unnecessary fields ...
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