Generating report is very TEDIOUS

Hello everybody, I have a problem in generating the report. It takes 1 and half hours just to view my report. Is there anyone know how to make it fast. Im using MySQL and i used 16 views for my report thats why its very tedious.
Thank a lot!!!Whatever query or stored procedure u r using execute it outside report and test the time.|||Also check that the fields you are joining on are indexed. When you look at the SQL for the report is there a where clause? If not the entire report is being processed on the local machine. Do you have the option "perform grouping on server" checked?

Generate "RDL" xml file with XMLA.

HI,,,,,,,,,,EveryBody...
Does anybody have code sample for on the fly report generation , generate
"RDL" xml file with XMLA.
pls help me,
I am really stuck with this problem , becoz I have posted many posts but
still I didnt get a helpfull machanizam.
Thanks
Summa.Hi Sumudu,
We are working on this project and we have an alpha product now you can
generate your RDL on the fly no XML no VS
www.rdlcomponents.com
Jerry
"Sumudu Prasad" wrote:
> HI,,,,,,,,,,EveryBody...
> Does anybody have code sample for on the fly report generation , generate
> "RDL" xml file with XMLA.
> pls help me,
> I am really stuck with this problem , becoz I have posted many posts but
> still I didnt get a helpfull machanizam.
> Thanks
> Summa.
>
>