I am currently evaluating StimulReports as the potential future platform for my company's reporting products.
So far I am very impressed with the power and functionality; however I seem to have run into a fairly critical problem which must be resolved in order for us to move to StimulReports.
My company supports both Oracle and SQL Server, and as such we need to be able to write a report once and be able to run it on either database platform.
Working in Designer, I can set up the oledb connection connecting to say a SQL Server database, define a simply query with no parameters as the datasource, and preview the report - the results display fine.
However if I then change the connection string of the oledb connection to an Oracle provider, with no changing the data source or anything else, the preview shows nothing.
Interestingly if I try the "View Data" option on the datasource after changing the connection string, I can see the data fine.
So the preview has got an issue I think.
This happens whether I start with an Oracle oledb connection or if I start with SQL Server connection, and then try switch the connection string.
I have also tried using a wrapper program to dynamically set the database connection, with the same result when I try using a different database.
I used this code found in the documentation:
Code: Select all
rep.Dictionary.Databases.Clear();
rep.Dictionary.Databases.Add(new StiOleDbDatabase("oleDBConnection", connString));