ReportNet performance

[firefee]

Hi,

my problem is that our reports are runnig very slowly!

Do you have any ideas, how can I make them faster ?
Where can I set the native SQL for the queries I use ?

Thanks

Firefee

[COGNOiSe administrator]

In ReportStudio, you click on the Show SQL elipsis button, then you click convert to SQL.

[sir_jeroen]

Do you see any strange SQL Codes in your reports? Are you using a lot of local processing functions? You'll have to examine your reports and also take a look at the indexes on your tables...