Using VWD I am trying to use the report viewer to display a report that i have on my sql 2005 report server.
I AM Able get to the report server page by going to the site's ipaddress\reports
the report i want to display is in a folder
so when adding the report to the reportviewer control in VWD i put
ipaddress\reports for the server url
then I put foldername\reportname for the report path
the report never shows up in design mode and when i try to view the page in a browser
I keep getting
Well for one you have your slash backwards.
It should behttp://myserver/reportserver
Not '\'
|||How I wish my problem was that simple, but i just mistyped it here. I really do have the correct / in my data.|||Just an idea, but try using the hostname of the server instead of the IP address. If you can type in a browser,
http://myserver/ReportServer
and get a response, your control will work.
|||I don't have a host name set up for this site, hence why i am using the ip.Have you used report server with VWD and report viewer?
Any other ideas...|||If you typehttp://ipaddress/reportserver into a web browser, do you get anything?|||
yes first it prompts me for user name and password right now i enter the local server username and password
after i do that i get the folders on the site like below do i need to pass the username and password to the report server some how?
Thanks for your help!
Thursday, September 28, 2006 11:10 AM <dir>Data Sources Thursday, September 28, 2006 11:10 AM <dir>Models Tuesday, October 03, 2006 7:37 AM <dir>Report Project1 Thursday, September 28, 2006 8:19 AM <dir>SMCReports
Microsoft SQL Server Reporting Services Version 9.00.2047.00
|||So the url you're using is:
http://192.168.0.238:81/reportserver?%2fSMCReports%2fReportName
Right?
|||This may or may not help:http://www.dezel.com/articles/ReportingServicesRendering.html|||I got it it was a combination of things for one i was not using a / in the report path
i just had smcreports/reportname instead of /smcreports/reportname.
I also did not have the proper permissions set up in report manager
I changed them according to this post
thanks for the help!!!
http://groups.google.com/group/microsoft.public.crm/browse_thread/thread/3b65374f40d44b12/a556ebab49a7b562?lnk=st&q=The+permissions+granted+to+user+%27NT+AUTHORITY%5CNETWORK+SERVICE%27+are+insufficient+for+performing+this+operation.+(rsAccessDenied)+&rnum=2&hl=en#a556ebab49a7b562
NOTE: At this point you should be able to use Internet Explorer and browse
the reports and reportserver virtual folders. Test this by going to
http://SBSserverName/reports andhttp://SBSserverName/reportserver. You
should be able to do this without receiving an error. If you receive an
error please stop here and send us the error you get.
4. Publish reports by opening a command prompt and going to:
c:\program files\microsoft crm\reports
Then run the following: publishreports.exe "company name"
"Domain\ReportingGroup {GUID}"
5. Give reports correct permissions
a. From the default website where SRS is installed browse the
reports directory (http://SBSserverName/reports)
b. Click Properties then click Your_Org_Name_mscrm folder
c. click the Security tab
d. The following groups should be added:
BUILTIN\Administrators with a role ofContent Manager
DOMAINNAME\ReportingGroup
{ec70ac7b-a091-4d00-b038-75fd6ea0e84c} with a role of Browser for Microsoft
CRM
NT AUTHORITY\NETWORK SERVICE with a role of Publisher for
Microsoft CRM
NOTE: If any of the above groups are missing you will need to
add them.
6. You may also have to do the steps on page 15-6 in the Microsoft CRM 3.0
Implementation Guide
http://www.microsoft.com/downloads/details.aspx?FamilyID=1FF067F8-4F7...
AE9C-68ADA7D4F16A&displaylang=en
No comments:
Post a Comment