asked on ADHoc Reporting, REport Builder 1.0
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
Microsoft SQL ServerMicrosoft SQL Server 2008SSRS
Last Comment
Rdichpally
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks.
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.