Solved

SSRS Reports - AdHoc Reporting

Posted on 2014-04-03
3
630 Views
1 Endorsement
Last Modified: 2014-05-09
I am working on AdHoc reporting (Report Builder 1.0) and I Built a smdl file from my views and tables. When I deploy the file on the report server and access the tables, I see vague table names and synonyms created through the Build of the SMDL file.

I need some help on how I can build the smdl files with meaning names for the tables that show up on the AdHoc reporting.

Any help on this is appreciated.
1
Comment
Question by:Rdichpally
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
Comment Utility
If you are using SQL 2008 as I see listed under Topics I suggest you to rather use Report Builder 3.0

http://www.microsoft.com/en-ca/download/details.aspx?id=6116
0
 

Author Closing Comment

by:Rdichpally
Comment Utility
Thanks.
0
 

Author Comment

by:Rdichpally
Comment Utility
Thanks.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now