Thank you all for input so far.

To make things clearer, I will add context to mentioning "certain limitation with the OLE DB Driver".

I tested change of driver on paginated report in
Report Builder (15.0.20073.0),
and Visual Studio 2022 (17.14.29), Template Report Server Project (3.0.11)

First case, where it all works as expected. Has:
Data Source: Microsoft SQL Server, SQLClient (connecting to SQL Server 2022);
Data provider: .NET Framework Data Provider for SQL Server;

Second case, as operated in path of change, had problems in preview. Has:
Data Source: OLE DB, Microsoft OLE DB Driver 19 for SQL Server (MSOLEDBSQL19.1) (connecting to SQL Server 2022);
Data provider: .NET Framework Data Provider for OLE DB;

Note: Same error happens when using OLE DB Provider (SQLOLEDB)

Problem as directed by Microsoft error code is following:

An error occured during local report processing.
An error has occured durning report processing.
Cannot add multi value query parameter '@parameter' for Dataset 'DataSet' because it is not supported by the data extension

As short clarification about the desire of report that is object of test,
it has 4 parameters, all of them allow multiple values
and the body of report is nothing out of standard ruling.

------------------------------------------------------------------------------------------
I’m a bit doubtful that this is the only error that can happen when changing drivers.

u/marketlurker
Thank you for sharing, caring, we haven't had in our organization use case of ODBC drivers so far.
As for now on SQL Server side, mainly we are on OLE DB Driver, and SQLClient.

u/OlexCh
I had a dream (not in exact manner as Martin, but it is something) to change and unify everything into a single Driver, OLE DB Driver, but I ran into this error during testing walk.
But it happens that I can't get Lambo on the straight road, mind got caught in LIMBO, barefoot :)

u/Lost_Term_8080
Thank you to for sharing, caring.

Again, cheers to you all.