I have a problem. I have created a report which shows the data from table in SQL Server (just a "select * from
where catid in (..)).
There is a parameter where I can choose if it should show MAIN categories, OTHER categories or ALL categories - and depend on choose - the list of catid is shorter or longer.
It works fine when I choose MAIN or OTHER categories. But when I choose ALL - after some time I receive an error - out of memory.
Result of this select (for all categories) is quite big - 25k records, but it should just be shown - there are no calculations in the report.
What is more strange - this worked a month ago for me and other people, but a week ago in stopped working on my collegue's computer, but still worked on mine. Today it stopped working also on mine.
I tried to restart (local machines, SQL server) - nothing helped.
Do you have any idea why it happened like that and how to fix it?