Hello everyone,
I am testing Live Office with Business Views and have found problems.
Scenario 1:
Same as in thread782-1022051 the number of rows returned are related to RAS batch size, but correct rows are returned from the same Business View when using Crystal Reports or Crystal Reports Explorer.
Scenario 2:
A different Business View & database with hundreds of thousands of rows in the table. The sql being sent to the database is selecting all columns and does not have a where clause, even though only two columns with a filter are requested via Live Office. This results in Excel being given more than the 65,536 rows that it can support which is more than the RAS batch size per scenario 1. Again all works correctly via Crystal Reports.
Is anyone successfully using Live Office with Business Views? Have you had these same problems?
Thanks,
Malcolm.
I am testing Live Office with Business Views and have found problems.
Scenario 1:
Same as in thread782-1022051 the number of rows returned are related to RAS batch size, but correct rows are returned from the same Business View when using Crystal Reports or Crystal Reports Explorer.
Scenario 2:
A different Business View & database with hundreds of thousands of rows in the table. The sql being sent to the database is selecting all columns and does not have a where clause, even though only two columns with a filter are requested via Live Office. This results in Excel being given more than the 65,536 rows that it can support which is more than the RAS batch size per scenario 1. Again all works correctly via Crystal Reports.
Is anyone successfully using Live Office with Business Views? Have you had these same problems?
Thanks,
Malcolm.