SQL server view

[john]

__Hi, ____Currently I select a view from SQL server, If I use SQL Server Query Analyer, just need less 2 second retrieve 900 rows data, however,if I use R&R result set, takes me 10 min, and lots of overhead, CPU is 100% used. ____How can I customize R&R report?____Thanks__John

[kfleming]

Do you see a sorting window prior to the actual report output in R&R?____Kathleen__R&R Support

[john]

>Do you see a sorting window prior to the actual report __>output in R&R? __>__>Kathleen __>R&R Support ______Yep, I can see the sorting window before the actual report output.____The issue is SQL server comsume 100% CPU and it takes over 10 min to process all the data. I am suspect some bottle neck between sql- server and R&R report, since I can run my view table less 2 sec at SQL analyzer.______Thanks__John__

[kfleming]

It sounds like the sort you have selected is being evaluated locally rather than by sending an ORDER BY clause to the SQL engine. What are your sort fields and what is displayed when do you a Database Show SQL?____Kathleen__R&R Support

[Darylwar]

I did in both of SQL clause with ORDER BY column1, column2, and R&R filter column1 and column2. It still takes far longer time and overhead at R&R report, in my sql execuation just less couple sec and no any overhead.____How can I custermize my R&R report design, with filter? with sort? or anyelse?__

[kfleming]

Have you tried creating a USER SQL report that uses the same SELECT statement as in native SQL?____Kathleen__R&R Support

[mstoreFeame]

__We do not have .NET, we just use Java stuff.

[kfleming]

A user SQL report is a report you create using File New User SQL. It then lets you select a data source and then write your own SELECT statement.____Kathleen__R&R Support