Problem Viewing Reports
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
ADVERTISEMENT
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
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
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
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
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 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
Nov 5, 2007
Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
Hal1490
Hal9000
View 4 Replies
View Related
Mar 18, 2008
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
View 2 Replies
View Related
Mar 18, 2008
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
View 1 Replies
View Related
Jan 23, 2007
Hi does anyone know how to do the above with out going through reportserver url?
Preferably by using a cmd tool ? such rs.exe
or through the backend in the reportserver DB?
Thanks
Dave
View 2 Replies
View Related
Apr 2, 2008
Hi all,
I'm very new to SQL Server having previously worked with Oracle 10g for the last couple of years.
Anyway, in Oracle there is a view called V$SQL that provides information about SQL that is or has recently been executed. I'm trying to find a similar sort of functionality in SQL Server.
Basically, what I'd like to do is list all of the SQL statements that are running at a given moment. Or even better would be a way of listing all statements that have run in the last 10 minutes.
Appreciate any help for a newbie.
We're on SQL Server 2000 8.00.194
Cheers
Kloid
View 8 Replies
View Related
Feb 13, 2008
Hi Friends,
Could I migrate the reports which are developed on SQL 2000 to SQL 2005. If Yes then How ...
Could anyone explain me. How it works.
Thanks
sqlferns
View 2 Replies
View Related
Mar 27, 2008
My issue is with converting multi-value parameters:
In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).
As an example:
I have a database table with a column called ID.
I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".
With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data:
1 - 50
60 - 80
150 - 127
This will only return results within those ranges.
Does anyone know if SSRS provides this kind of functionality?
Thanks,
Patrick Conway
View 9 Replies
View Related
Aug 7, 2007
Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.
The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.
Is there a way to do this?
Thanks for your help.
View 3 Replies
View Related
Aug 17, 2006
Is there any way, in enterprise manager or otherwise, for me to view the last few SQL statements executed against my sql server?Thanks
View 1 Replies
View Related
Dec 9, 2003
I just installed SQL Server on my 2003 box. Up till now I've been using MS Access for all my database needs. When I wanted to work on fields in a table, all I had to do was open Access and there you go. How do I view and modify Fields in SQL?
Chill
View 2 Replies
View Related
Dec 4, 2000
Is it possible to view the transaction log to identify events run against a database.
I know that I could create a trace file to log events.
But what I really want to know is whether there is any way to actually view the live .ldf transaction log file and make sense of it.
It is possible to do something similar in Informix.
View 2 Replies
View Related
Aug 17, 1999
How can I view the transaction log for a particular database. We are trying to track down when a delete occurred and wanted to look there to find it, unless there is a better place to look.
Thanks
View 4 Replies
View Related
Jun 28, 1999
Can any one tell me how you view the transaction log records since we don't have a syslogs anymore?
View 1 Replies
View Related
Apr 30, 1999
How can I view the contents of a transaction log? Is there a better way to determine who deleted a record and when?
View 1 Replies
View Related
Dec 13, 2004
Holy MOLY I've been banging my head up against the wall on this matter for months now. I have two databases and I need to be able to see the tables from different different databases. Usually I create a view like this
LicensingActions.dbo.License_Suspensions
But it wasnt working kept telling me that the License_Suspensions table didnt exsist and at the time the name was in all caps. So I decided to change the name, and low and BEHOLD IT WORKS. The funny was that I wasnt having that problem any of the other tables just that one. Well live and learn. Just thought I'd share that with you guys
View 4 Replies
View Related
Aug 22, 2005
I just got some great code from this site for viewing constraints, but I can't find the equivalent for indexes (and I couldn't modify the constraint sql), any suggestions?
View 2 Replies
View Related
Jun 17, 2007
why can't i see SQL server 2005 the same way i see Visual Basic 2005 Express edition. i'm able to see VB by going under the all Programs menu and select it, when i try to find SQL 2005, i see configuration tools and some submenu of configuration tools. is that the way it is? if not, how do i get SQL 2005 to open up like VB so i can play with it. Also, at home i do not have a server, do i have to have a home server to play with SQL
hens
View 5 Replies
View Related
Feb 17, 2006
I am trying to view a "View" that is in one of my databases, and I am having a problem seeing the scripting that is inside of it. In sql2000 all I needed to do to view a "View" is double click on it. If I double click on a "View" in sql2005 it will open more folders showing the layout, but I want to see the scripting. If I right click on it and then click open view, sql2005 returns the values that the view would bring across. Does anybody know how to view the scripting of a "View" for sql2005?
Also if I select Modify, sql2005 returns scripting but it does not look right.
Thanks for the help!
View 7 Replies
View Related
