Problem Viewing Reports In Report Builder
Feb 8, 2006
Hi.
I get a problem when I want to preview a report in Report Builder. I just launch Report Builder by the url [1] (RS is on a server, and I work on a laptop). Then I choose a model and create a simple report. When I press "Run Report", I get an error message saying: "The permissions granted to user 'mydomainmyusername' are insufficient for performing this operation. (rsAccessDenied)". But my user are assigned to content manager...
If I then save the report to the Report Server, I can access the report through e.g. the Report Manager without any problems.
Why doesn't the preview functionality work for me? Are there some settings I need to set, or is it a bug in Report Builder?
Regards, Tomsi
[1] http://<servername>/reportserver/reportbuilder/reportbuilderlocalintranet.application
View 5 Replies
ADVERTISEMENT
Nov 24, 2006
Using the report builder, I created a simple report based on a report model. This report runs ok in the report builder.
I proceeded to save the report to the report server, but when I want to view this report in Report Manager, I get the following error:
An error has occurred during report processing.
Query execution failed for data set 'dataSet'.
Incorrect syntax near '<'. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xsi' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xsi' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xsi' has already been declared. Label names must be unique within a query batch or stored procedure.
View 6 Replies
View Related
May 14, 2008
I'm having a strange problem with SSRS 2005 that I'm hoping someone might be able to help with. I've reinstalled SSRS (multiple times) and even reinstalled IIS hoping to resolve the problem, but it still exists.
The problem is that trying to view a report via Report Manager is failing. All other operations within Report Manager work fine (browsing folders and report lists, viewing folder and report properties, changing properties, setting permissions, etc.) Only trying to view reports fails. Whenever I try to view a report, I get the following error:
The request failed with HTTP status 401: Access Denied.
I can view reports via other methods just fine. For example, if I browse to the http://localhost/reportserver URL directly, I can view any report just fine. And if I connect to SSRS via SSMS, I can view reports there as well. I believe that both of those methods use a direct reportserver URL versus using the http://localhost/Reports/Pages/Report.aspx page within the Report Manager virtual directory.
Here's a bit of configuration information that may or may not be helpful to someone:
1. This is on a laptop running Windows XP SP2 (32-bit). SSRS (and all SQL Server components) are installed as default instances and SQL Server SP2 has been applied to everything.
2. All of the latest updates and fixes for Windows, SQL Server, Office, etc. have been installed via Windows Update.
3. This laptop is a member of a domain, but I am typically not connected to the domain (not in the office very often). I am, however, logging into the laptop using a domain account (with cached credentials). Local user accounts are frowned on by the domain and IT administrators involved (except for running local services). My domain account has full admin permissions within Windows and within SQL everywhere.
4. As far as I can tell, everything with regards to IIS, asp.net, and SSRS are configured correctly (ASPNET account seems to be set up correctly, all SQL services including the SSRS service are running under a local account with admin permissions, the Reports and ReportServer virtual directories in IIS are set to use Integrated Security, etc.)
I'm not an expert on SSRS, so this one has me stumped. I've reviewed all of the config files that I can think of looking at for SSRS and I've looked at the SSRS logs. Nothing really jumps out at me in terms of changes that might be required (and the SSRS logs don't really say much other than repeating the error). For example, I see the following lines in the ReportServerWebApp__xxx.log file:
aspnet_wp!ui!8!5/14/2008-13:00:17:: e ERROR: The request failed with HTTP status 401: Access Denied.
aspnet_wp!ui!8!5/14/2008-13:00:17:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 401: Access Denied.
Anyone have any ideas? I've searched Google for quite a while trying to find something that would help me figure this out, but thus far I've not been able to come up with anything. Any help (or pointers to something on teh web somewhere that I might have missed) would be appreciated!!
Dave Fackler
View 5 Replies
View Related
Apr 30, 2008
Here is one scenario. There is Department X which has subdepartments A,B,C,D. A has 5 members and B has some 7 products, C 5 members and D has some 12 members. My problem is I need create a Report model where is if we select X
all the list of subdepartments and their members should be displayed. I.e if we select X then
A
1
2
3
4
5
B
1
2
3
4
5
C and so on..........every thing should be displayed that are under department, i.e subdepartments under that department and the members under each subdepartment of that Department.
The problem here is all those departments and subdepartments are in same table which has columns like,
"DeptId" and "Dept Reporting to" and "EmplID.
When we select "Dept Reporting to" = X, we need to get the result as I specified above
Can anyone please help me out to create a Report Model to generate ad hoc reports
View 4 Replies
View Related
Oct 6, 2006
Hi!
We have a "folder hiriarchy" in reporting services with permission for different users to only create reports in their own folder. However, it would be nice if they (in report builder) could open eachothers reports, modify them and then save them in theri own folder. In this case, if they find a useful report that someone else has created, they could just make their own small modifications and save it in their own folder.
The problem is that I cant't seem to find a securitysetting that allow this. Either they can create/modify/delete the reports in a "folder" or they can't even open them in report builder...
Is there a solution to my problem?
regards Andreas
View 1 Replies
View Related
Apr 9, 2007
Hello -
I know that you can build a Report Designer report and add URL navigation from a field. I am trying to figure out how to do this with report BUILDER. I haven't been able to do it using the UI and editing the RDL directly to match what I see in a similar report Designer report is being ignored (if I did it right).
I can put the URL into the DSV & Model as a field/attribute, but displaying the a field with a URL in it doesn't make it "clickable".
Does anyone have a trick for this? Or know that there is definately no way to do it?
Thanks in advance,
Toni Fielder
View 1 Replies
View Related
Jun 22, 2007
I have a development server setup with Report Builder that our users have been testing out. They have a number of reports that they have created on this dev server.
We now have our live environment all setup and I'd like to move their Report Builder reports to the new server for them so they don't have to recreate them.
Is this possible? If so, how?
Thanks.
View 1 Replies
View Related
Jan 11, 2008
I have a very simple report model with two tables in it but having millions of rows.
I have developed a report on this report model, which will return atleast half million rows.
I have published this report to report server and trying to access the report through the report manager. It never returns the result. Fails with tme out expired error. I have 64 bit machine and 2 GB RAM. The report is expected to return atleast 500 MB data. As per the SSRS documentation it the memory should be three times to process the report. It does not work.
If I develop the same report using the report designer, I get the results returnd within a minute.
If I use the above mentioned Report Model as my data source, again I get the results within less than minute.
So what is it the report builder report is doing additional? It is strange that the same report model when used as data source returns the same number of rows within less than minute and the report developed and uploaded to report manager using report builder fails with time out expired error?
What is that the Report builder doing internally? Can I change some configuration for report builder report to work for large reports? I have already changed the memory settings in the report config and machine config files.
Your early response is appreciated.
Virendra
View 7 Replies
View Related
Mar 15, 2007
Is it possible to create cascading parameters with in Report Builder? I have done this with Report Designer but i need a solution with Report Builder.
(I need the structure: First the user selects the state, afer the postpack the cirties of the state are listed in another dropdownlist for selection).
Thanks in advance
View 1 Replies
View Related
Mar 5, 2007
Hi,
I need to create letter type reports using the report builder, is this possible?. I am trying to create a letter that embeds some variable fields, i.e,. name, address, contact number. I can't seem to find a way to create page headers, and embed report data fields within text. Is this not possible within the report builder? it seems that the only thing you can do within the report builder is add fields to their predesignated areas. I am being forced to use the report builder instead of the report designer in order to give the end user the ability to make modifications to the report/letter. This is very frustrating. not being able to allow the user to edit report designer files, and then having force them to use report builder which doesn't seem to support some simple features..
Any suggestions would be appreciated...
View 2 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
Apr 4, 2007
Hello - I am having difficulty enabling the automatic click-through functionality for my model. I have two entities - Customer & Incident. Incident is a role/FK/OptionalMany relationship to customer.
I've read through earlier postings on this subject (below) and have verified that the #Incidents attribute in my incident entity has the EnableDrillThrough=true.
My test report is simple - Customer Name (from customer) and #Incidents (from incident). When I run it, the click-through option is not available (the cursor stays as an arrow and doesn't change to a finger).
Are there other properties or settings that I need to be working with? I have SP2 (9.0.3042) installed on our Standard edition of SQL 2005. I know Infinite Click-Through is not in Std edition, but a few levels should be, correct?
Thanks in Advance,
Toni
Other related postings -
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1260819&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=657279&SiteID=1
View 4 Replies
View Related
Aug 20, 2015
I am using Report Builder 3.0 and i have report which has a drill down group. The report opens in a collapsed form.This report has interactive sorting on a column. But,when we drill down and sort the column, the group collapses and the details disappear.
In some posts, i have seen that instead of interactive sorting, people recommended a parameter. But i have to do interactive sorting only.
View 3 Replies
View Related
Nov 5, 2007
Hi all,
I'm trying to get empty cells from an OLAP cube to display in a report designed using the Report Builder. Of the three report types, only the Table report shows the empty cells. Is there any option/setting that I need to enable to get this to work for the Matrix or Chart reports? Something like the "Show Empty Cells" option that is available in the pivot table used by BI Dev Studio?
Any help appreciated.
View 2 Replies
View Related
Nov 8, 2007
Hi
Does any body know that creating free form rports using Report Builder is possible?
Free-form report - in the sense - that user should be able to drag the fields from the leftside fields pane and drop on body as we do in report designer using BI studio.
I could not figure out a way to do so. Is this a limitation?
Thanks
Raj Yennam
View 5 Replies
View Related
Nov 20, 2015
I run these stored procedure to build the report and I am able successfully to build the report but I need some prompts to in the report to get the specific data .
ALTER
PROCEDURE [dbo].[Sharepoint_Ticket_Report]
@StartDate
DATETIME,
@EndDate
[Code] ....
And for prompts how to create created_by and message_type dropdowns as shown in picture.
View 7 Replies
View Related
Feb 6, 2008
Hi,
When i select datasource in Report Builder, i am able to see all the available DataSources.
Eg: I have selected one datasource from the list and which has 3 tables(table1, table2, table3) associated to that datasource.
when i drag and drop table1 fields to report, i am not able to see the other 2 tables(table2 & table3)
Is there any property or relationship do i need to maintain?
Thanks,
SR.
View 5 Replies
View Related
Sep 20, 2006
I have been using Microsoft Business Intelligence for 1st time. This software has been able to create my reports based on a table I have. But note, this report is built using Business Intelligence (Visual Studio). Now, the Report pulls data from a database. I also have a C# application that interfaces with this same database. What I would like to do is to display the content of this report in my C# application. How do I go about doing this?
View 4 Replies
View Related
May 2, 2008
Hello all.
I have an ASP.NET application which allows the selection of various reporting services created reports to be selected via a drop-down. Until recently this has worked no problem at all, however now a strange error has surfaced.
When the user selects to view a report, the first selection shows the report correctly. However when a second report is selected, instead of displaying the second report, the screen simply posts back but doesnt actually display the second report.
Any idea people?
View 1 Replies
View Related
Mar 21, 2007
I have created a report, in SQL RS 2000, using My Windows Credentials.
ie under the datasource tab, I chose the "credentials stored securely in report server" OPTION. There I specified my user NT Credentials.
However, when I view the report, it gives me err
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source xxx. (rsErrorOpeningConnection) Get Online Help
Login failed for user xxxx
Pl advise.
Thanks.
View 1 Replies
View Related
Aug 8, 2007
Hi everybody,
first i am having problem viewing the reports, when i go to http://localhost/ReportServer/ i get a list of files and folders as follow:
[To Parent Directory]
01 يوليو, 2007 11:14 ص <dir> bin
06 سبتمبر, 2005 01:12 ص 488278 Catalog.sql
06 سبتمبر, 2005 01:12 ص 14738 CatalogTempDB.sql04 يوليو, 2007 05:26 م 76 global.asax 04 يوليو, 2007 05:38 م 10540 rsreportserver.config
13 يونيو, 2005 02:07 م 11845 rssrvpolicy.config
01 يوليو, 2007 11:14 ص <dir> Styles
08 اغسطس, 2007 09:58 ص 2776 web.config
and when i try to open any folder it shows its content, then i select any report and click on it, it gives me the following error:An internal error occurred on the report server. See the error log for more details. (rsInternalError) Invalid object name 'ReportServerTempDB.dbo.PersistedStream'.could anyone help me please?? thanks in advance....
View 1 Replies
View Related
May 10, 2007
Hi,
Does anyone know how to browse a report in a new browser window?
regards
Josh
View 1 Replies
View Related
Dec 20, 2006
I've made some reports using the Report Designer. When i run them in the Report Designer everything is correct. Then in my webpage i have links to launch the same reports. The viewer is launching the report using the HTML4.0 format parameter in the URL.
In the viewer my report is so ugly. Some textbox doesn't have the same height, other are not align correctly. What i don't understand is if i tried to print the report or export it in PDF or in TIFF everything is ok. I only have the problem when i tried to view the report using the viewer with the HTML4.0 parameter.
So is this a problem with the viewer ? Is there something i can do to correct this problem ?
Thanks !
View 1 Replies
View Related
Jan 23, 2007
Hello, we're having a bit of an issue getting Report Server to display reports. We've published via the web-interface and Visual Studio. After we publish, it gives an error and it looks as if it's trying to find the data source that we used to create the report. We've changed the datasource names to match that of the local machine too. Here's the error...
An error has occurred during report processing.
Cannot create a connection to data source 'LocalDataSourceName'.
Keyword not supported: 'driver'.
Any help would be greatly appreciated. Thank you!
View 3 Replies
View Related
Mar 25, 2008
We have sql 2005 setup pulling sharepoint list data and we have created a report from this data. We can view this report through sharepoint internally however when we try to view the report externally we cant view it?
Has anyone else had the same problem?
Any help would be much appreciated, thank you.
View 7 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
Aug 31, 2007
How do you stop anyone from the outside world from viewing the report manager?
From typing eg( www.mywebaspreportapp.com/Reports) and directly accessing the report manager?
Is there a security step i missed somewhere?
View 2 Replies
View Related
Jan 8, 2007
I have built the reports that I need using Visual Studio and the SQL 2005 Reporting Server, but now I need a way to view the reports via a web browser.
I am not much of a web/programming expert, so any help that could walk me through the process of publishing the .rdl files that I have created via a web browser would be much, much appreciated. Again, I am a novice in the the web arena, so the more straight forward the steps the better.
Thanks!
View 2 Replies
View Related
Jan 10, 2008
I have an interesting problem to report that I'm hoping someone will be able to assist in solving.
I have a report that contains a table inside of a list. When I view this report on my local machine via Visual Studio, everything appears normal, the columns are all the correct size. However, as soon as I publish this report to the report server and attempt to view it via Report Manager, one of the columns expands horizontally!
From all of the documentation I have read, I understand that Reporting Services does not provide the ability for columns to expand horizontally, only vertically. Can anyone help explain why this is happening or a possible solution to turn this automatic expanding off?
Many thanks,
canuck81
View 4 Replies
View Related
Apr 17, 2007
We are using Reporting Services 2000.
The print button that is present in the browser is working just fine for some users.
But some users are complaining that on clicking the print button their system restarts.
Some other users are also getting the error "An error occurred during printing. (0x80004005)"
However on closing the browser and opening the report in it again this issue is resolved.
So, the main concern is "Restart of the machine on click of the PRINT icon in reports viewed in some application browser."
Please help!!
View 2 Replies
View Related
Apr 30, 2007
Hello Friends,
I have created few reports in SSRS 2005 on Windows 2003 Standard. Previouly I was not able to view reports from my .ASPX page which contained a ReportViewer, after going throuhg some other threads I was able to create a snap-shot for my reports . But still I'm not able to view reports, each time I try to view the page I get a message box with a error as : "Unable to locate control SSRS 2005: oReportCell" the same error is displayed when i try to access my reports from "http://localhost/reports.....".
But the funny thing is I'm able to view the reports when I use the following URL: "http://localhost/reportserver/pages/reportviewer.aspx?/<report>". I have applied all the Hotfixes & installed the latest Service packs. Any suggestions ???????
View 1 Replies
View Related
Sep 9, 2015
I just created a report builder. I have a main report and i wanted to create a sub report. why i cant or i cant view the path or the folder of my .rdl file to be use as my sub report.
View 5 Replies
View Related
Jun 30, 2006
After I use the report builder to create a generic report, how do I actually get that report into the report designer so that I can modify it more effectivly?
The issue that I have now is that the file on the report server is not a .rdl file and if I simply save it as one and then bring it into VS to modify it the code file is a html structure rater than a XML file type.
Any suggestions would be appreciated. Thanks
View 3 Replies
View Related
