stored procedures
1 Topic
Paginated reports - stored procedures
Hi guys! I am currently working in an enviroment with: - PBRS -import mode - and an ODBC connector to a database that I'm not allowed to name. The problem is that currently we have to load tables with 20-100 million rows of data and sometimes we have columns where 1 cell contains ~20 pages long strings. We were looking for solutions (unfortunatelly Direct Query is not an option with this database and connector) to make the import faster. I have come accross paginated reports and stored procedures. How is this really works with import mode ? The user can choose from parameters and the paginated report only imports the data that is filtered ? Or it imports firstly everything? Thank you for your help in advance and have a nice day!Solved3.3KViews0likes2Comments