A New User Cannot View Reports
Nov 28, 2007
Hi,
i have a prob;lem while using report manager.when i login As "administrator" to the report manager i can see all the folders and i can check also reports. when i create new users with some role and i login as new user i can see the specified folder and report but when i click to see the report this message appear:
" Your browser does not support scripts or has been configured not to allow scripts".
Note that these same reports i can check them when i login as administrator
i am using sql server 2005
please it's important to resolve this problem as soos as possible
thx
labiba
View 3 Replies
ADVERTISEMENT
May 31, 2007
Ideally, I'd like to have the reports use windows authentication, ie grab current user/password so long as user does not have to enter it manually. If that is not possible, then how do I make it so user does not have to enter this info manually? My theory is that I have IIS set up incorrectly for doing this, but I'm not familiar enough with either reporting services or IIS to find out.
View 1 Replies
View Related
Feb 2, 2007
I can browse my subfolders containing reports in Home, but Internet Explorer displays error message when I press a report.
I can use Properties, History and the other tabs, but when I press "View" tab I can only see error message.
I have to use external IP address (217.x.x.x/Reports) so I tried to set this IP in ReportManagerRSWebAppConfig file:
<UI>
<ReportServerUrl>http://217.x.x.x/ReportServer</ReportServerUrl>
</UI>
But when I try to use local IP address (10.x.x.x/Reports) in my local net, I can't connect to the report server.
When I change this to <ReportServerUrl>http://10.x.x.x/ReportServer</ReportServerUrl>
I can't view my reports from external host using external IP (217.x.x.x/Reports) because local IP is used when I press "View" tab.
I don't know if there are other files that should be changed? Can somebody tell me how to solve this problem?
Best regards,
Chris
View 1 Replies
View Related
Jan 26, 2007
Hello colleagues,
I am trying to create some reports in VS.NET for our Microsoft CRM3.0.
I am using a SQL query like this:
SELECT CRMAF_Account.Name, CRMAF_Account.primarycontactidName, CRMAF_Account.address1_line1, CRMAF_Account.address1_line2, CRMAF_Account.address1_city, ActivityPointer.scheduledstart, ActivityPointer.subject, ActivityPointer.description
FROM ActivityPointer, FilteredAccount CRMAF_Account INNER JOIN FilteredSystemUser FSU ON CRMAF_Account.ownerid = FSU.systemuserid
WHERE ActivityPointer.regardingobjectid = CRMAF_Account.accountID AND FSU.Domainname = SYSTEM_USER
ORDER BY Datum DESC
When I run this query, I get the desired result (I am the database dbo), but when any user tries doing the same, they get an error
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set '[DatabaseName]'. (rsErrorExecutingCommand) Get Online Help
SELECT permission denied on object 'ActivityPointer', database '[DatabaseName]', owner 'dbo'.
I desperately need to know which user rights are missing and where are they missing - I do not suppose that the rights are expected to be assigned directly to the database tables
Any quick help would be highly appreciated. I would also appreciate any articles with examples how to use parameters, filters and subreports.
Thank you very much.
Marek Hlavac.
View 1 Replies
View Related
Apr 30, 2008
Hi,
This is regarding the SQL 2005 Report Manager (http://localhost/Reports) page. I have posted the reports, the reports run fine, buttons like new folder, new data source, etc... are visible (lets call this machine as A). The problem is when my machine is accessed from a nearby computer on the same network as http://machineA/Reports, the Report manager Home page appears with limited or no buttons. The reports are also not visible in the browser of machine B. How do I make the reports visible to users (grant permission) for them to run and view those reports?
In a nutshell, how the posted reports be accessed by users?
Thanks,
Raj
View 1 Replies
View Related
Sep 22, 2007
I'm able to preview my report in Visual Studio and once I'm deploying it, it is getting deployed also on the Local server but when I'm using browser and trying to view the report, it is showing me following error message:
Unable to connect to the remote server
The attempted operation is not supported for the type of object referenced
I'm using Win XP Pro with a developer edition of Sql Server 2005 and administrator of computer. Not able to understand why in browser I'm not able to view reports.
Kindly help.
View 4 Replies
View Related
Aug 29, 2007
Hello,
We recently did an "in place" upgrade of SQL Server and SSRS 2000 to 2005.
After the upgrade we cannot view the exisiting reports. (although we can publish new reports using the VS2005 Designer and they show up just fine.)
We have SP2 installed for SSRS2005 and all SPs for SQL are up to date.
When we navigate to an existing report via the reporting services website, the report acts like it is trying to run and then returns and error message:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
When we look at the logs we see that the report server cannot initialize the stream from the Catalog table.
aspnet_wp!library!1!08/28/2007-16:52:29:: Call to GetPropertiesAction(/Report Administration/All Process Dates, PathBased).
aspnet_wp!chunks!1!08/28/2007-16:52:29:: i INFO: Returning old chunk for: (fd690975-ec5b-4033-9664-81335e3990c0, 'CompiledDefinition', 0)
aspnet_wp!library!1!08/28/2007-16:52:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Could not initialize stream;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!chunks!1!08/28/2007-16:53:01:: e ERROR: ### SnapshotConverter(fd690975-ec5b-4033-9664-81335e3990c0, True), Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: Call to GetSystemPropertiesAction()
We welcome any suggestions.
View 4 Replies
View Related
Feb 15, 2007
How is it possible for others to browse to my localmachine and view the reports?
They tried browsing to http://machinename/reports
and http://10.1.3.123/reports
But the message the users get is: You are not authorized to view this page.
Then In my localmachine, I changed the IIS setting for the Reports and ReportServer to allow anonymous access. Then the users were able to see the Home page of the reports but not the reports themselves to click on for viewing. Any thoughts please?
Thanks
View 1 Replies
View Related
Dec 10, 2007
hello when i try to view reports in reports manage i get the following error
The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found
Source Error:
The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %>
or:
2) Add the following section to the configuration file of your application:
<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>
Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.
Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.
Stack Trace:
[InvalidConfigFileTypeException: The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found]
Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded() +212
Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.GetInstance() +17
Microsoft.Reporting.WebForms.LocalizationHelper.Microsoft.Reporting.WebForms.IReportViewerMessages.get_ProgressText() +42
Microsoft.Reporting.WebForms.WaitControl.CreateChildControls() +210
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +7248
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +213
System.Web.UI.Page.ProcessRequest() +86
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +18
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.pages_report_aspx.ProcessRequest(HttpContext context) +4
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +358
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
View 3 Replies
View Related
May 8, 2008
Hi All,
I am having multiple URL in multiple zones for my site.I am not able to view SSRS reports on Internet which is in Internet zone where as i can view the same reports on Intranet site having URL in default zone.
I m getting the following Error while accessing reports over internet:
" Unable to connect to the remote server.No connection to be made because target machine actively refused."
It would be great help if any one can solve this problem.
Thanks in Advance.
View 2 Replies
View Related
Nov 28, 2006
Hi
I have been asked to move our entire system over from SQL2000 to SQL2005, i eventually got our database and Cubes over to 2005 and converted all my reports to 2005 and deployed them successfully on RS2005
All the subscriptions have been made and they seem to work when i click to view them. Although when i create a DDS for all my reports to run then they fail. Now i've got over 5000 reports to build and i'm definately not going to create each report manually. My SQL Reports huild successfully, it just seems to be the MDX Reports with a problem, i;ve checked my stored procs and they seem fine, i've even seen the [Clients].&[All.Clients] difference from SQL2005 ---->&<------ that is not in SQL2000.
If someone has, or has had the same problem before would you please help me. Any advice or suggestions would be more than welcome.
Kind Regards
Eagle
View 1 Replies
View Related
May 6, 2008
Hi,
I would like to restrict users to allow to view related reports only...
like i have 2 users..with 4 reports
1 user can see only two reports
2 user can see only another two reports
how can i do this by SSRS???
Can i do by using Configure item-level role definitions in seetings link..
or is thr any another way to do this?
Pls reply back
Regards,
Maruthi..
View 4 Replies
View Related
Oct 31, 2007
Hi,
I have couple of Web pages linking to my RDLs using report viewer Web controls. I have no problem running and viewing them in VS2005 debug mode and report manager until I published them to local folder and set the local folder as an application on my IIS7. When running the published version of the Web pages, all my calendar image buttons (which happen to be part of the report parameter fields) turned to red 'X':
http://dyzimw.bay.livefilestore.com/y1pwxE9mLpX4JV7e438WA4DeGwu6YHQOkRoC20r_EhQ5uoXkt15dqs99LmiDSTauSvUCno9HnOwYKR34rPpFYA_lQ/ssrs.jpg
When clicking the View Report button, the animated progress icon not appearing at all. Before the occurance of this problem, I did face the problem whereby the 'NT AUTHORITYNETWORK SERVICE' does not have enough permission to view the report. After referring to some threads, I finally be able to get rid of this error by assigning Browser role to 'NT AUTHORITYNETWORK SERVICE' from the report manager. I wonder could this solution be related to the problem that I'm facing now. Any help would be appreciated.
Thank you.
Regards,
Antonio
View 1 Replies
View Related
Jun 8, 2015
I got a problem with my project on reporting services. I installed MS SQL Server 2014 (86x version), Report Builder 3.0 (for creating my reports) and Data Tools for my SQL Server.Now I created a report via Report Builder 3.0 with a SAP NetWeaver as a data source. I could create and view it in Report Builder 3.0.
But when I want to view it on my Report Server it doesn't work. I only get this error."An error has occurred during reporting processing. (Processing Aborted) An attempt has been made to use a data extension 'SAPBW' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)" ...
I found on the internet a few solutions. I installed the Data Tools for the 86x version of the SQL Server. Didn't work. And when I want to change some coding in "RSReportDesigner.config" it says that I'm not allowed to save the changes in this directory.
View 12 Replies
View Related
Aug 22, 2007
Hello Everyone,
I am trying to personalze my reports for each user, for example: Say I have a report which takes in userName as a parameter and then generates the report. Is it possible to use the same userName that the user used to login to the reporting services enviornment. This way the user don't have to enter their userName to see the report, it will be entered by default.
Thanks a lot,
-Rohit
View 5 Replies
View Related
Feb 11, 2008
Hi there,
Don't know if anyone has done this before -and I would really be wondered if not-:
I want to show a list of available reports to a user. Since we are working with SharePoint Portal Server 2003 the webparts can't be used (need MOSS 2007 or WSS 3.0), but I really need to be able to build a dynamically generated list and show it on a sharepoint page.
My first idea is to build a report (kind of menu). I am already this far:
to get a list of reports with the active directory groups and their mapped roles:
select u.UserName, c.Path, r.RoleName
from PolicyUserRole pur
left join Users u on pur.userID=u.userID
left join Roles r on pur.roleID=r.roleID
left join Catalog c on pur.policyID=c.policyID
order by u.UserName, c.Path, r.RoleName
I managed to link active directory via LDAP - linked server.
I even managed to get a list of users and groups. Unfortunately I cannot check whether a user belongs to a group (any idea?), since all of our security (on sql server) is managed by active directory groups this really is a problem.
Or am I completely wrong and is there another way to fetch a list of reports for a user?
Any help would be great!
Thanks,
Tom
View 1 Replies
View Related
Aug 17, 2007
My PC is in the domain group of SQL Server 2005 Reporting Service, so I can publish the reports. After the reports were published, I can viw the reports from ASP.NET application on the web server, but everyone else was prompted for login. Only my login can view the reports. What can I do to let others to open the reports with the same web application? Thanks.
DanYeung
View 1 Replies
View Related
Jan 22, 2008
Up to this point only two of use, both server administrators, have developed reports. Now we need to add two new report analysts to be able to develop reports in BIDS but limit their access to other server folders, etc. Our report source code is located at G:Visual Studio 2005 Source CodeProjects and all report folders, sln files, etc. are located under the Projects sub-folder. I have shared the Projects sub-folder and given read & execute / list folder contents / read / write / modify rights. They can see the report folders and sln files via BIDS or Explorer but get "access denied" when they attempt to execute one of them. Any thoughts on what I may be missing?
View 1 Replies
View Related
Oct 12, 2007
Hi Experts,
I'm using SSR5 2005. I have a set of Cubes. Any idea as how to created customized reports using SSRS. The end user should be able to create reports by himself. Please help or send me some links where I can get help in this regard.
Thanks & Regards,
Naveen J V
View 4 Replies
View Related
Jan 29, 2008
Hi
I'm new to SQL Reporting Services and I've been asked to create an online environment for a client where their customers can log on and view a report. The client wants to make sure that each customer can only see data that is relevant to them, and that other customer's information is hidden from whoever is logged on.
Can this be done through a username/password setup or is the solution more complex?
Thanks very much!
View 5 Replies
View Related
Jan 8, 2008
Hello,
I have some reports running CRM data. It's basically a sales dashboard that shows each user their pipeline values. Since each user has rights to see more than just the opportunities they own, I had a filter on the report in the SQL WHERE clause. It said
WHERE
@UserID = systemuser.DomainName.
The @UserID parameter's value was
=User!UserID, which brought back the logged-in user's domain name, which matched the field in my WHERE clause.
Now, in CRM 4.0, to eliminate the need for a VPN to access reports, everyone who accesses a report is logged in as NT Authority Network Service. Does anyone know if there's still a way to access the person's domain identity?
Thanks,
Andy
View 3 Replies
View Related
Aug 17, 2007
My PC is in the domain group of SQL Server 2005 Reporting Service, so I can publish the reports. After the reports were published, I can viw the reports from ASP.NET application on the web server, but everyone else was prompted for login. Only my login can view the reports. What can I do to let others to open the reports with the same web application? Thanks.
DanYeung
View 12 Replies
View Related
Oct 6, 2005
This is a pretty simple query that tracks 'yesterdays' apply clicks on our website.
SELECT MIN(A.hitDate) AS minDate, D.AffiliateName, B.ProdType, COUNT(DISTINCT A.ipAddress) AS TOTAL
FROM ArchiveApplyTracking A LEFT OUTER JOIN
Configuration.dbo.Affiliates D ON A.affiliateID = D.AffiliateID LEFT OUTER JOIN
Incoming C ON A.campaignID = C.ID LEFT OUTER JOIN
Configuration.dbo.ProductType B ON A.productTypeID = B.ProdNo
WHERE (A.hitDate >= DATEADD(d, DATEDIFF(d, 0, GETDATE() - 1), 0)) AND (A.hitDate < DATEADD(d, DATEDIFF(d, 0, GETDATE()), 0)) AND (A.deal = 1) AND
(A.ipAddress NOT IN
(SELECT ipAddress
FROM [Tracking].[dbo].ipTracking)) AND (B.ProdType NOT LIKE 'refused%') AND (D.AffiliateName LIKE 'ARROW%') AND
(B.ProdType NOT LIKE '%prequalify%')
GROUP BY D.AffiliateName, B.ProdType
ORDER BY D.AffiliateName
No problem there, that's fine.
But how can i put a simple date range interface on my published report so users can say "get me the stats from 04/09/2005 to 20/09/2005, which then runs the query?
Thanks for any help
View 1 Replies
View Related
Dec 13, 2006
Hi all,
I'm a beginner to Report Services, and have tons of questions.
Here's the first one:
if the reports are created based on the condition that the user selects, how can I create the reports with Report Services?
For example,
the user can select the fields that will be shown on the reports, as well as the group fields, the sort fields and restrict fields. So I would not be able to pre-create all possible reports and deploy them to the report server, and I think I should create the reports dynamicly based on what the user select.
Could someone tell me how to do it (create and deploy the reports)?
Thanks a million!
Jonee
View 1 Replies
View Related
Apr 24, 2007
Hi,
I have some sensitive and non-sensitive info/fields in one of my reports. Is there a way to hide/show the info based on the logged in user? or do I have to create separte reports for each type of info like one for sensitive and another one for non-sensitive info.
Thanks inadvace for your help!
View 3 Replies
View Related
Jan 2, 2007
I have created some reports using Report Builder however they autorun with default values when selected in report manager, cant think many people would want this to happen. Is there a way of getting rid of the default values in RB or preventing auto execute in RM?
View 1 Replies
View Related
Mar 14, 2007
I've seriously looked, but this simple concept eludes me. How do I go about viewing all the permissions granted to a database user? Like whether or not they can execute a stored procedure.
View 1 Replies
View Related
Aug 22, 2007
I've a view in which one of the fields were DATEDIFF(day,contract date,received) AS AgeOfAccount. I changed it to DATEDIFF(day, m.received, CASE WHEN m.clidlp > m.clidlc THEN m.clidlp ELSE m.clidlc END) * - 1 AS AgeOfAccount. When I execute the view I'm getting an error. But the results are getting displayed properly. That's what's puzzling me. Could someone tell me what the error is.
The following errors were encountered while parsing the contents of the sql pane.
Your entry cannot be converted to a valid date time value.
View 4 Replies
View Related
Mar 7, 2005
:confused: How can we determine which views in SQL-database is system or user, by making a query to any system tables?
Thanks in advance,
Jai
View 4 Replies
View Related
Oct 29, 2006
im using the Northwind database, i use T-SQL commands to create a view that restricts users from seeing the address, city for all employees.
i dont know how to assign the view to a user in the database using Enterprise manager.
pls help me, im really needing a answer.
thanks!
View 5 Replies
View Related
Apr 10, 2008
i have one grid view in a web page
then i want to set GRIDVIEW header value according to user input
how can i do this pls help me ....
Yaman
View 2 Replies
View Related
Apr 17, 2008
I create a user then I create a database and assign my newly created user as owner
When I login as this new user everything works fine BUT my newly created user can still see other database names even though he is not allowed to use them.
How can I prevent him from seeing other database names.
P.S. I use the GUI
Thank you
View 2 Replies
View Related
Dec 4, 2007
I have Developer's Edition of SQL Server installed on my PC. I want my users to run and view my new RS report from their PCs across the network without installing SS on their machines.
We experimented a little bit by asking one user to use these URLs...http://mymachine/reports$myinstance and http://mymachine/reportserver$myinstance) after giving her browse rights in report manager from my PC.
When she uses the first URL, she gets a popup asking for sign in info, but gets nowhere when typing in her windows sign in info. When she uses the second, she gets thru to the report choices but gets an error like...
* An error has occurred during report processing. (rsProcessingAborted)
* Cannot create a connection to data source 'xxxxx'. (rsErrorOpeningConnection)
* For more information about this error navigate to the report server on the local server machine, or enable remote errors
...after choosing my report. xxxxx is the name of the only datasource in the report.
Before we began, we also turned off 'enable anonymous access' and instead clicked 'integrated windows authentication' in IIS on my pc.
My user is on a different domain controller than I am. I asked a colleague who is on the same domain controller to try the URLs and he had no problems running my report from either. He wasnt given any explicit permissions/rights at either the reporting or db level.
Does anyone have a clue?
View 6 Replies
View Related
