generate view to advanced report