mcrmg
asked on
open an reporting server report
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
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
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).
ASKER
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
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
ASKER
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 :)
when it try says loading and stay there for more then 10 secs. click cancel. it sometimes does that :)
ASKER
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
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
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...
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...
ASKER
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
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
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.
ASKER
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
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
ASKER
Please have a look at the screenshot, mine does not have that.. :( thanks
ee.jpg
ee.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
by any chance do you know if I could add more points? (I know you could do that before)thanks
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...
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...
ASKER
no, I dont see it...Can you please increase that to 500? thanks
ASKER
thank you, and thank you for your help, it works!!!
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!
And good to hear you got this to work btw! Have a nice day!
ASKER
thank you