How do I set up dev and production sites in Cloud Reporting?
In a single Bold Reports® Cloud tenant, you can set up development, staging, and production environments and use a different data source (connection string) for each environment. Follow these steps:
Prepare categories and data sources for each environment
Before you set up environments, create one category and one shared data source each for development, staging, and production.
- Set up three different categories for development, staging, and production.
- Company_Dev
- Company_Staging
- Company_Live
- Create three different shared data sources for development, staging, and production.
How to change the data source for an existing dataset
You create a dataset for another environment by selecting Change Data source on an existing dataset and saving it with a new name and data source.
For all your existing datasets, change the data source and clone for use in different environments. Consider you have a dataset named “Employee_Dev” used for the development environment.

- Select Change Data source in the dataset’s actions menu.
- Enter Employee_Staging as the name.
- Choose the staging data source “Company_Staging”.
- Click Save.
- This will save the new dataset named “Employee_Staging” which is pointing to the staging environment.

Repeat the process for all your available datasets.
Follow the same procedure to create dataset with a production connection string.
How to change the dataset for a report
You move a report to another environment by copying it to that environment’s category and choosing that environment’s dataset.
For all your development reports, change the dataset and copy to the staging category.

- Select Copy in the report’s actions menu.
- Select the staging category.
- Select Overwrite to overwrite the existing report.
- Choose the staging dataset “Employee_Staging”.
- Click Copy.
- This will copy the report under staging category with the staging dataset.

Hence, the staging report will now render with the staging connection string. Repeat the process for all of your reports.
Follow the same procedure to copy the report to the production category with the corresponding dataset.
Frequently asked questions
Do I need a separate tenant for each environment?
No. You can keep development, staging, and production in one tenant by using a separate category and a separate shared data source for each environment.
How do I give a team access only to production reports?
Add a permission with the Reports in Category entity, choose the production category, and select the Read access mode. See Manage permissions.
What does the Overwrite option do when I copy a report?
The Overwrite option replaces the existing report with the same name in the target category. Select it when you update a staging or production report.