Solved

open an reporting server report

Posted on 2014-02-06
20
438 Views
Last Modified: 2014-02-11
Hi,

I am trying to edit one of the reports from rs.  When I click on Report Builder and trying to open the report, I am getting this error:
Cannot open this item, no Report Builder model are available.  

I did not create this report, it was created back in 2010, after Sandy, we lost bunch of data.  Now, my boss asked me to see if this is still usable.  Please help..thx
0
Comment
Question by:mcrmg
  • 10
  • 7
  • 2
20 Comments
 
LVL 19

Expert Comment

by:Melih SARICA
ID: 39839456
Install Report builder 3.0 from microsoft download  and try to open it from that application. As i can see ur trying to open ur report directly from SSRS (reporting server).
0
 

Author Comment

by:mcrmg
ID: 39839483
thanks for the quick reply, do you think 3.0 will work with SQL 2008, not r2?

I tried to install it locally yesterday and try to connect to the server, I tried that for good 3 hours, no luck.  Although I could open the report in IE.  thx
0
 

Author Comment

by:mcrmg
ID: 39839795
There are 3 sets of reports, I have a project file for one of them, I can open them in VS without problem.

My question is, if I dont have a project file that used to build the reports, is there a way to edit the reports that are published to RS already?  thx
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 500 total points
ID: 39841159
You can always add existing reports to an SSRS project in BIDS (VS).  Just use the Report Manager to first download them, then use the Add Existing Item functionality in the Solution Explorer (VS).

Of course, if the report has any dependencies, like shared data sources, then you'll need to add those to the project as well.

The msg about Report Model could indicate that the report is based on a model.  So you'll need to recreate that too.  I'm not sure though if it can just be downloaded from the server, I never use them.  In fact, Report Models are deprecated in SSRS 2012.
0
 
LVL 19

Expert Comment

by:Melih SARICA
ID: 39841176
Its just used to manubulate rdl files. so its not important. u can open it with 3.0

when it try says loading and stay there for more then 10 secs. click cancel. it sometimes does that :)
0
 

Author Comment

by:mcrmg
ID: 39841606
Thanks for the reply.

How can I download them using Report Manager?

I tried to connect to the server using 3.0, but I had no luck.  The page opens fine in the browser.

I am using VS2008 and SQL2008 STD.  Sorry if the questions are too obvious, I dont have much experience in reporting services.  thanks
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39841624
How can I download them using Report Manager?

I tried to connect to the server using 3.0, but I had no luck.


I think you might be confusing Report Manager with Report Builder :)

The page opens fine in the browser.

What does the URL look like?

To open Report Manager you need an URL like http://YourServer/reports

That will give you an overview of all folders and reports that exist on the server.  Use the dropdown menu on a report and select Download... to download it.

Additional info: Report Manager

PS: no need to apologize, we all had to start from scratch some day in the past...
0
 

Author Comment

by:mcrmg
ID: 39841639
thanks

the url looks like this, http://data2008/Reports

yes, I was confused between both of them.  lol

When I am in the report manager, there is no dropdown nor download link available...thanks
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39846891
You need to hover the mouse pointer over a report, then the icon which you need to click appears to the right of the report.
0
 

Author Comment

by:mcrmg
ID: 39847122
Please bare with me.  sorry about that.

When I hover over a report, (before I click on it), there is a tag appear "item in <foldername>", there is no icon appear on the right side of the report..thanks
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39849477
This is what it should look like:

Report Manager - hover over report
0
 

Author Comment

by:mcrmg
ID: 39849902
Please have a look at the screenshot, mine does not have that..  :(   thanks
ee.jpg
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39850076
Ow right, you've got 2008 (not R2!).  In that case it works differently...

First you need to click the Show Details button on the right.  In the detail view you'll see an edit properties icon next to each report, click that.  Now you should have the report's properties in front of you, with the option to edit report definition.  Clicking that will allow you to download the .rdl.

BTW: your screenshot shows only folders, you'll need to go into a folder to see some reports.
0
 

Author Comment

by:mcrmg
ID: 39850219
by any chance do you know if I could add more points?  (I know you could do that before)thanks
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39850284
That option should be available next to the Post a Comment title: http://support.experts-exchange.com/customer/portal/articles/1021286

If you don't see this (I came across a recent bug complaint related to this) I can increase it for you if you want.  In that case just let me know what you'd like to set it to...
0
 

Author Comment

by:mcrmg
ID: 39850346
no, I dont see it...Can you please increase that to 500?  thanks
0
 

Author Comment

by:mcrmg
ID: 39850362
thank you, and thank you for your help, it works!!!
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39850379
Ow, that was your intention!  Cool!  Not that I was in desperate need of points but I appreciate the gesture nevertheless ;)

And good to hear you got this to work btw!  Have a nice day!
0
 

Author Comment

by:mcrmg
ID: 39850396
thank you
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

785 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