Crystal Reports 2008 programatically limiting results
Posted on 2008-10-25
Hello, I am somewhat new to Crystal Reports and have been working on an application for a big system to create reports on-the-fly at runtime. I do have one issue though, I have tables that can have one million records and when I am programatically linking tables and I run the application it freezes because of the large number of records.
I am using the Crystal Reports 2008 API for .NET and would like to know how I can restrict the records programatically. I know I can do so by creating and accessing a view like this - SELECT TOP 1000 FROM TABLE1 as opposed to accessing the table directly but I have about 250 tables and want to avoid creating views for each one, I am accessing and linking the tables directly in code at the moment. Any ideas?