I have a AdHoc reporting environment in Report Builder 1.0 (SSRS). I am trying to retrieve data from different entities that do not have a relational integrity but the AdHoc Report environment is not allowing me to map the fields from the two entities. Is there any way I can do this in AdHoc Reporting or do I have to change the mapping in my database and redesign my database? Any help is approciated
The role of a reporting app is to render reports, not to relate/map unrelated data from multiple data sources.
If that's your task, then that's an separate ETL project where you have to identify your sources, your targets, how the multiple sources are mapped (i.e. do values need to change), quality needs (aka is your data clean enough), etc. etc.