Solved

ADHoc Reporting, REport Builder 1.0

Posted on 2013-11-22
3
699 Views
Last Modified: 2014-01-17
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
0
Comment
Question by:Rdichpally
3 Comments
 
LVL 65

Expert Comment

by:Jim Horn
ID: 39668857
>I am trying to retrieve data from different entities that do not have a relational integrity
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.
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39676989
From your wording I can deduce that you are using the Report Model functionality.  I've never used that, and never actually saw the benefit of it.  Also, it no longer exists in SSRS 2012 so it might be interesting to investigate a bit how reports are build without the model functionality.

You could then just use a fairly simple SELECT statement that joins your two entities together on their primary/foreign key fields, or even on a string if that's all you've got available.

I'd also recomment to download the newest Report Builder: Microsoft® SQL Server® 2012 Report Builder

As long as you don't use any functionality not supported by 2008 I believe this should work fine.

Here's a tutorial to help you get started: Report Builder 3.0: Creating a Basic Report
0
 

Author Closing Comment

by:Rdichpally
ID: 39789369
Thanks.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question