Hello All,
Is it possible to test a report if I dont have accesss to data souce of the package that is used by the report?
Can you tell me please how to do it?
I believe no.
The connection between the package and the data source must be established in creating/executing reports.
You can explain your current situation, what you have/ don't have, how are you doing things and what are your expected output. There must be something we can work around.
I would like to test new report. But I don't have access to data source of the report. DB server is offline now.
Of course I can wait until the DB come back online.
But I thought if it is possible to test without the connection to the datasource then better to test the report instead of waiting ...
what kind of test are you aiming?
Theoretically, you cannot runt the report if the datasource connection of the package is not established.
The package alone does not store actual data. It has the metadata and the structure. When you run the report, it will base the data structure to your model and then will connect to the database using the database connection specified in the admin. Therefore, your report will not fetch any data.
If you have an available copy of the datasource you can specify in your package to use that. That will work if all the objects exists in that db. Other than that, I'm not sure if it would work if you have a prior report output/saved version.
you can change the connection to connect to another datasource like in DEV.... just to test...
...unless you are trying to do something fishy