Problem Viewing Reports On Server
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
ADVERTISEMENT
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
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
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
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
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
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
Jan 13, 2007
This is a new problem to me, I have been running SQL Server 2000 with VS 2003 and last summer upgraded to SQL Server 2005 with VS 2005 - (both evaluation copies) all was fine
I bought the full upgrade of VS 2005 and SQL server dev edition in Dec 2006 and recently I have started to get a total system fallover dreadful noise followed by black screen and reboot.
This happens only when I view the Table Data "Show Table Data" in "Server Explorer" in VS2005, viewing design is OK, stored prcredures OK
I suspect this is either a hardware impending failure or software conflict but I would like some pointers please
I am using XP Pro sp2 with 1GB ram, F Secure Internet security, the Database is hosted externaly
View 5 Replies
View Related
Mar 8, 2004
I have a stored proc that has several parameters. (using SQL server)
i call this proc and add the parameters etc and execute it etc
the problem is that how can i see the string that is being passed to the db? eg the calling command?
cheers
View 2 Replies
View Related
Jun 29, 2007
I have a project were I will have it so that users can sign in and change information on an SQL server. The catch is that this site will be from a different domain name and from a different hosting company then where the SQL database is located. Sorry if this is a dumb question but how can I utilize asp.net to change and view an SQL database that is located else-where.
For example: a user logs into www.something.com and he/she can view and edit SQL tables from www.somethingelse.com's database.
Thanks in advance.
View 2 Replies
View Related
Aug 9, 2000
Any idea on how I do this?
Any advice welcome.........
View 1 Replies
View Related
Aug 22, 2006
Hello,I'm trying to follow some sql sentences that my system send to SQL 2005express and I don't have a deep knowlegde of databases. I know thatthere's a transactions log that keeps all sentences that go intodatabase motor. Is it correct? in case yes, is there a way to look atthis archived sentences?Thanks in advanceIgnacio
View 1 Replies
View Related
Mar 17, 2008
HI all, we have a table that has it's primary key data type Bigint. Isthere any way with Access to view this table? I find it hard tobelieve that two tools from MS don't play nice with each other, may beI should.SQL Server 2005Access 2003TIA
View 5 Replies
View Related
Dec 20, 2007
For some reason when I go to view any video on http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx
it doesn't run. Can someone help?
Thanks,
Mark
View 1 Replies
View Related
Sep 19, 2006
I saw a presentation last week where the speaker created some sorta sql server "watch window" (in Sql Server Management Studio I think) where he could watch all the commands being executed on his sql server database in real-time. For example he could navigate to web pages (that hit the database) and as he pressed buttons you could see the sql commands execute in this "watch window." If other users hit the database at the same time you could see those sql queries execute as well. I didn't think at the time to ask how he did it - does anyone know how to set this up? I have a problem with my sql server right now and it would be useful to see which sql queries (etc) are being executed when. Thanks in advance,J. Shane Kunklejkunkle@vt.edu
View 2 Replies
View Related
Dec 17, 2005
I need to live update my SQL-Server 2000 database from AS400 database.
I usually use Access 2002 database between the AS400 database and the SQL-Server 2000 database to reflect any live update.
I use the (Link Tables...) option when creating a new table in access and link it with the ODBC to connect with the AS400 database.
After that I work with the Access link table.
Is there any tool in SQL-Server 2000 to show the live transactions in AS400 databasee so I can work on it?
Please advise
View 1 Replies
View Related
Jul 5, 2006
I never noticed it before, but I am now using Management Studio to administer our sql databases and the issue became apparent. One of the databases located on a sql 2000 server, says "6.5 compatible", when viewed from Management Studio (but not from Enterprise Manager).
What are the step needed to upgrade the database? (I think I need to run the Sql 2005 Upgrade Advisor first, fix any errors found, then manually change compatibility mode (to 80) from the sql 2000 server where the database is located. )
TIA,
Barkingdog
View 1 Replies
View Related
Nov 30, 2006
We still have some Legacy 2000 DTS packages running on our 2005 Server. The DTS packages have been configed to save the logs on the 2005 SQL server. We can manually look at the logs in 'msdb.dbo.sysdtspackagelog' and 'msdb.dbo.sysdtssteplog' table but I am looking for some GUI tools so our tech support can view the package logs without writting a query.
In 2000 Enterprise Manager, you can right click on a DTS package and select 'Package Log...' and then a nice GUI window will show up for you to browse through all the dts logs. I just can't find this tool in 2005 Server Management Studio for Legacy DTS packages. If I right click on a Legacy DTS package, all the option I get are 'Open, Migrate, Export, Delete, Rename, Refresh'... Since the log tables are still the same, I am wondering if there is anyway I can use that 2000 DTS log viewer in 2005?
Thanks.
View 1 Replies
View Related
Mar 20, 2007
Hello,
Picture tells more then 100 words. I cant get any components there.
http://www.pixilive.com/uploads/20070320/report.jpg
How i can fix that?
View 10 Replies
View Related
Jul 13, 2007
I work with a large and complex reporting system with several hundred reports: the Programmability; Stored Procedures node of the object explorer has become very difficult to navigate.
Is there any metadata that can be embedded in the stored procs that would create subfolders like the existing System Stored Procedures node in this node of the object explorer?
I suspect that the correct answers are:
Rename all your queries with a rational naming convention;
Cull the deadwood;
Assign them to categories then export them to separate databases.
Unfortunately, one of these has already been done, and the other two will break several hundred dependent processes - the recoding and retesting is neither economical nor desirable.
Still, all advice is welcome. Pitch your answers at a banking geek who does intermediate to advanced stored procedures and triggers, but isn't allowed to play with sharp things (like sys objects) - but I can probably get help from a grown-up on the sysadmin team: I have discovered that the rumours about human sacrifice are baseless, and they will perform favours in return for beer.
This is also a good time to ask: just how many stored procs and functions are you allowed in SQL Server 2005?
Nile.
View 5 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
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
