Folks:
I am a little new to CR. I am writing a bunch of CRs with VS .NET 2005. All of my reports have parameters. I am currently using Selection formulas approach. I would like to know if there is a big penalty in performance if I am using this approach vs. callling stored procedure, and bind it to the report.
Most of my reports returns > 2000 records if no data are filtered.
I speculate right now that the CR engine might load all data in the memory and filter the data on the server.
Let me know
Thx
-- Hai
Selection formulas vs. Stored procedure
Hot Topic
- Equivalent of WM_MOUSEACTIVATE?
- its no longer possible to use a 'different' build configuration
- VSS & VS very very slow compiling
- "late binding" communication and more questions
- Added project reference not reflected
- ReportViewer is very sensitive to where I put
- Did not work :-(
- Microsoft Document Explorer cannot be shown because the specified help collection 'ms-help://MS.MSDNQTR.v80.en' is invalid
- Paging in toolbar off-by-one
- Waiting for a process exit to restore window state
Visual Studio
- __ComObject in DataTemplate
- Creating a custom test type in VS 2005 Team System
- VisualBrush at Runtime BUG?
- how do i debug application using Remote Desktop Connection
- can't generate proxy classes for WCF SDK samples with svcutil
- LINQ and Workflow
- Not totally clear on source control options
- Serialization
- Excel File Deployed to WSS?
- Deploy hell
Selection formulas vs. Stored procedure
ausmock
Both ways don't have much difference in performance if the report selection formula is simple. I suggest you try one report with two ways to compare.