Setup is SQL2005 SP2 with Reporting Services installed local on Win2003 64bit. When users browse report manager on http://server/reports they get login dialog for every request, but only if they use IE7. In FireFox all works. The site is in "local intranet" zone on IE. It seems like it is a NTLM, I've tested reinstall, change permissio...
I see that in the SQL Server Reporting Services 2005 Report Manager there is the capability to schedule reports for specific times (i.e. every weekday at a particular time). What I would like though is more control -- i.e. every weekday, but only between certain dates of the year -- for example, getting sales figures every day starti...
Visual studio fails to deploy reports or data sources on remote MSRS instance. Error message is "Unable to connect to the remote server". The server is up and running and TargetServerURL property of the project points to correct url which works in the browser. I googled around but and found a few forum threads discussing the same issue ...
Details are as follows: Environment: SSRS 2008 Server, SQL Server 2008 for database, Report Developed in SQL Server Business Intelligence Devlopment Studio - Reporting Project Error Messages: "An error occurred during client rendering." "An error has occurred during report processing." "Query execution failed for dataset 'DataSource...
Hi, I have a SSRS report and using PL/SQL for the dataset creation. My report needs two tables 1 one gives detailed view.(dataset 1) 2 one below that gives a summary table (data should come from the calculations based on the data in 1 table) I am using a temporary table for the dataset one. What are the methods to get calculated ...
In a reporting application, Is it possible to abstract reporting logic and the database schema details? I have a Reporting Services application with a reasonably complex reporting logic, I am trying to migrate the application to some other databases. (Databases that are built for the same purpose but developed by different software-hou...
I have created a one-time subscription in SSRS report manager 2008. However I keep getting duplicate emails sent out by the subscription. The interval between each email is about 30 minutes. I have checked SQL agent job and it looks the SQL agent job is created correctly. It just runs once and after that the next run time is cleared. ...
I have an issue with SharePoint where my SSRS reports subscriptions are intermittently failing to email. 1) I'd love to get to the bottom of this issue... This was my original question 2) Each time this fails I have to manually refresh all the subscriptions (I change the time by 1 minute), this seems to work for a few days - to a few...
I'm using SSRS 2005 to produce a report and one of the columns in my report is a simple mean calculation. I don't want to divide by zero so for the textbox value I have put: =Switch(Fields!Count.Value=0,0,Fields!Count.Value>0,Fields!Sum.Value/Fields!Count.Value) This still evaluates the second expression. and so does: =IIF(Fields!...
Is there a way to disable or override the excel and pdf export function in SQL Server Reporting Services. I want to my own custom excel export. ...
I have two report parameters that were set up automatically when I created their associated datasets. They are ReportID and CompanyID. The user selects a Company Name from a list box and a Report Name from another list box. The standard SELECT ID, Name FROM TableName query was used to fill the respective list boxes. The report parameters...
I have a report created in Reporting Services that is using the UserSort properties on "headers" in a table. Everything works on my local machine and on our staging server. It sorts the column asc and desc. But when we do this in our production environment, the usersort stops working. Anyone have any similar problems? ...
I have a couple of inline SQL in many of our reports on the report manager. Now I need to do some code change for all of them, is there a way to list all those reports based on the inline SQL and not any SP? Thanks, D ...
Hi all, This is regarding SSRS engine. For my project we are not going to buy SQL server software. Instead of what I just want to know, is there any posibility to use only SSRS engine. So that I can have the ref. (DLL) And then I can use wherever I want. Please help on this. ...
Is it possible to use PowerShell to script out SQL Server Reporting Services rdl files in SQL Server 2008? If so, can someone provide a code example of doing this? This would be a useful replacement for using a 3rd party tool to script out RDL files created by business users outside of my Business Intelligence department. CLARIFICATIO...
I am trying to render a simple chart using SSRS. The data is in an Excel sheet. I have set up an user DSN and created a data source in SSRS using ODBC. I am able to query the excel in "Data" tab. However while trying to preview, I get the following error: error [hy000] [microsoft] [odbc excel driver] the connection for viewing your lin...
I am working on a SharePoint application where the data is kept in lists. For ease of reporting, we create views in SQL Server 2005 that link lists together, and our Reporting Services model is based on these views. As users add/modify/delete fields, our views become stale. When we recreate the views, some reports are no longer valid. ...
I'm a bit confused with this one. I have a Dataset with a BackupDate and a BackupTime as well as a BackupType. The BackupDate is comprised of 12 characters from the left of a datetime string within a table. The BackupTime is comprised of 8 characters from the right of that same datetime string. So for example: BackupDate would be 'D...
I am using MS reporting services and some of the reports are taking longer than it should. By default the report viewer displays a loading graphics in IE. However, this graphics is not visible in Firefox. It works fine in IE. How can I display the loading graphics in Firefox? Any help would be appreciated. Thanks in advance. Regards N...