If I view the SSRS report and Preview the results, then chose to export the preview to PDF the export looks perfect(The fonts display correctly and are formatted nicely). When I deploy the report to IIS and go through the web report using IE and chose to export the results to PDF from inside IE the PDF is not formatted nicely. One perti...
I'm trying to show a tablix of data where the result of a sum changes in each row. I have the rows grouped by date and sorted in descending order such that the most recent date is first. What I want to do is compare each row's sum with the sum of the previous row, e.g. Date Sum PrevValue ---------- --- -------------- 2009-09...
Hi, I have created a dynamic subscribtion. All work well, but if I create the subscrbtion on any month say like July 09, and select that I get the report of previous month on monthly basis. Now In month of August I will receive the report for the data of July 09 which is correct but after that in September 09, I should Receive the repor...
I have a report that has a group row that shows a group name and sum details in certain columns. Then a details row within the group. I show the detail rows hidden to begin with and an expansion button. That part works. I also want to be able to sort on the group's aggregate data, not detail data. So when the detail rows are hidden, some...
I am using SSRS reports in MS Crm 4.0 I have two datetime parameters in my report. They are fine until someone type in an invalid format, e.g. 9/30/2008 or 40/09/2008 or random text. It logs an Error in the event log but my manager doesn’t want to see it. Now, just wondering how to do a client side validation and stop the report gets e...
I'm creating installer using InstallShield 2010 (basic MSI) that is having two features. First feature consists of: main .NET application compiled as x86, some native x86 third party dlls which are used by main application (x64 versions are unavailable). Second feature contains single component which is an extension for MS Reporting...
Hi, Have a project where were building custom business reports accessible via web browser. As we run SQL server I would like to use reporting services instead of writing custom reports in my application. Is there a way to publish a GUI for generating reports from reporting services on the web, or is there any convenient way to get the ...
Hi, Im trying to change the font of the text in my SSRS Report using the SSRS Expression language. e.g.: i have a textbox in my report and i set the Value property of it using the SSRS Expression language ="hello" is there a way to make the "hello" literal an underlined string. Thanks ...
Hello, we are currently using SQL Server Reporting Services and we would like to use Report Builder so our customers can create reports themselves. I have created a User on the server. I have added this user to the SQLServerMSSQLUser and SQLServerReportServerUser groups. I have given this User db_datareader access to the required databas...
Hi, I make use of a ReportView component in a VB.Net 2005 app. How can I disable the PDF export functionality, only keeping the MS Excel format? ...
Hello, A quick question for someone, hopefully! In my .rdl file source I can see the tag "< sorting >" Where abouts in the GUI (I'm using Visual Studio) can this property be set? Thanks in advance, Jim ...
I have a number of reports deployed to a SQL Server 2005 Reporting Services server. They were all developed using the same Report Model (SDML) that references the same Data Source View (DSV) that points to a test database filled with mostly dummy data. Now, I would like to make those reports pull data from the live database with our real...
Hi, I'm trying to set up SSRS 2008 on my desktop machine for development purposes. The following is working fine: Report deployment on local server Previewing the report in BIDS Access to htpp://localhost/Reports panel But when I point the ASP.NET Reportviewer to the Report URL, I get the following error: The permissions granted...
I'm new with SQL Reporting Services 2008 and cannot find out how to do something that should be simple. What I have is a single select parameter that is populated with a list of salesman from a query. This works great. And I have the dataset query responding to this parameter working well. So my reports for a single salesman are work...
I have a web service I need to call which is expecting a string Array. I'm using the standard VS SSRS and am having troubles setting up the Data Source in my project. I've setup DataSet parameters and tried a number of different options but it seems it will always pass the value as text. I get thrown the error (Expecting state 'Element...
I am trying to configure SQL Server Reporting Services to send email. The environment is: Windows Server 2008 Enterprise SQL Server 2008 Enterprise SSRS running in Native mode SMTP server via IIS7, configured as a restricted relay After a user configures a subscription for mail, when it's triggered the status changes to the following...
As a Newbie for Reporting Services, I have some confusion about setting up report services on my local dev machine. I'm using Sql-Server 2008 Developer Edition on Vista64 Home Premium. When I go to http://localhost/reports, I'm being asked for a login. When I enter an account that I have configured to be a local admin, I get to minima...
I'm trying to acheve the above in reporting services. Current month is fine but how can i add prev month to the table? The data is currently stored in a different dataset that has exactly the same fields. Using reporting services 2005. ...
I am encountering a problem when attempting to display Hebrew fonts in SQL Server Reporting Services. I see the fonts perfectly in the database, but when displaying the report all the Hebrew fonts displayed as ????? Any suggestions? ...
I have a table in a report and a textbox that changes its background color based on the value(s) in the table. Right now I have the background color expression for the textbox set to: =iif(Me.Value = ReportItems![NewValue].Value, "Yellow", "Transparent") "NewValue" is the name of one of the columns in the table. The above works fine ...