1
VarChar to Numeric in SSRS
I am trying to convert from a varchar to numeric format using the “Expression” in Visual Studio. =FormatNumber(Fields!wo_udf8.Value) This seems to change the format of the numbers shown, however, when I try to “Sum” the column, I get this error message: Warning [[rsAggregateOfNonNumericData] The Value expression for the textrun ‘wo_udf81.Paragraphs[0].TextRuns[0]’ uses a numeric aggregate function [...]
Answer Question
| May 14, 2013 3:25 PM
SSRS 2008, SSRS reports
I am trying to convert from a varchar to numeric format using the “Expression” in Visual Studio. =FormatNumber(Fields!wo_udf8.Value) This seems to change the format of the numbers shown, however, when I try to “Sum” the column, I get this error message: Warning [[rsAggregateOfNonNumericData] The Value expression for the textrun ‘wo_udf81.Paragraphs[0].TextRuns[0]’ uses a numeric aggregate function [...]
Answer Question
| May 14, 2013 3:25 PM
SSRS 2008, SSRS reports
Automate SSRS report
I have a monthly task where I have to run an SSRS report for each contractid we service and export each one to excel. The problem is that there are over 800 contracts and the tool only allows me to enter 1 at a time. I would like to somehow enter maybe 50 contractid’s and [...]
Answer Question
| December 8, 2011 4:17 PM
SSRS reports, Visual Studio
I have a monthly task where I have to run an SSRS report for each contractid we service and export each one to excel. The problem is that there are over 800 contracts and the tool only allows me to enter 1 at a time. I would like to somehow enter maybe 50 contractid’s and [...]
Answer Question
| December 8, 2011 4:17 PM
SSRS reports, Visual Studio
SQL query working differently in sql plus and SSSR
I wrote down a sql query for creating a SSRS report. The query is fetching different no of rows and data in SQLPlus and SSRS. I am worried how same query can fetch different results in different environments. Please help me.
Answer Question
| March 31, 2012 8:34 AM
SQL Query, SQL Server, SQL Server Query, SSRS reports
I wrote down a sql query for creating a SSRS report. The query is fetching different no of rows and data in SQLPlus and SSRS. I am worried how same query can fetch different results in different environments. Please help me.
Answer Question
| March 31, 2012 8:34 AM
SQL Query, SQL Server, SQL Server Query, SSRS reports
How to make a graph always visible when there is no data?
Hi, I am currently creating a report in SSRS which contains many tables including a graph on one page. The formatting is nice generally, but when there is no data in the graph, everything will be different. So, I am trying to keep the graph always visible to keep the formatting. Is that possible? Thanks, [...]
Answer Question
| October 5, 2010 8:52 AM
SQL Server Reporting Services, SSRS, SSRS Performance, SSRS reports
Hi, I am currently creating a report in SSRS which contains many tables including a graph on one page. The formatting is nice generally, but when there is no data in the graph, everything will be different. So, I am trying to keep the graph always visible to keep the formatting. Is that possible? Thanks, [...]
Answer Question
| October 5, 2010 8:52 AM
SQL Server Reporting Services, SSRS, SSRS Performance, SSRS reports
SQL Server Reporting Services (SSRS) Reports 2005
How to include to Input parameters in the report, so as to help users identify the parameters on which the report was run.
Answer Question
| October 4, 2010 12:06 PM
input parameters, Parameters, SQL Server, SQL Server reporting, SQL Server Reporting Services, SSRS, SSRS reports, SSRS Reports 2005
How to include to Input parameters in the report, so as to help users identify the parameters on which the report was run.
Answer Question
| October 4, 2010 12:06 PM
input parameters, Parameters, SQL Server, SQL Server reporting, SQL Server Reporting Services, SSRS, SSRS reports, SSRS Reports 2005
SSRS Dynamic Report Parms
I am desiging a report to use several parameters. The first parm is report type. I need the other parameters to show or hide depending on the selection made to the first parameter. Can anyone help? Thanks
Answer Question
| September 1, 2010 4:14 PM
SQL, SQL Parameters, SQL Server, SQL Server 2008, SSRS, SSRS reports
I am desiging a report to use several parameters. The first parm is report type. I need the other parameters to show or hide depending on the selection made to the first parameter. Can anyone help? Thanks
Answer Question
| September 1, 2010 4:14 PM
SQL, SQL Parameters, SQL Server, SQL Server 2008, SSRS, SSRS reports
Exporting to Excel – Sort doesn’t work due to merged cells
How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.
Answer Question
| August 6, 2010 9:40 PM
excel, Excel import/export, SSRS, SSRS Migration, SSRS reports
How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.
Answer Question
| August 6, 2010 9:40 PM
excel, Excel import/export, SSRS, SSRS Migration, SSRS reports
SSRS blank columns
am having a problem with SSRS dropping columns from the datasource if the cell in the first row is blank. Is there a configuration setting that causes this? I don’t want to crete a dummy first row that has something in every column in order for the reports to work. The data is coming in [...]
Answer Question
| May 12, 2010 5:43 PM
SSRS 2005, SSRS reports, XML
am having a problem with SSRS dropping columns from the datasource if the cell in the first row is blank. Is there a configuration setting that causes this? I don’t want to crete a dummy first row that has something in every column in order for the reports to work. The data is coming in [...]
Answer Question
| May 12, 2010 5:43 PM
SSRS 2005, SSRS reports, XML
SQL Server Reporting services
I am trying to add a field that has different values.I need to add them to get a total number .Example: Lesson num field contains value 1245,3467,6754,9987,4089 I need to add them to get a total of 5.
Answer Question
| April 8, 2010 1:32 AM
SQL Server, SQL Server 2005 administration, SSRS 2005, SSRS reports
I am trying to add a field that has different values.I need to add them to get a total number .Example: Lesson num field contains value 1245,3467,6754,9987,4089 I need to add them to get a total of 5.
Answer Question
| April 8, 2010 1:32 AM
SQL Server, SQL Server 2005 administration, SSRS 2005, SSRS reports
how to give report name dynamically – SSRS 2005
I created report in ssrs 2005. i added ms report viewer in c# windows application and from smart tag i gave the report name. It display the report but how to give name dynamically, for example i want to put the report name through textbox and want to show the report at runtime.
Answer Question
| February 26, 2010 10:54 AM
C#, SSRS 2005, SSRS reports
I created report in ssrs 2005. i added ms report viewer in c# windows application and from smart tag i gave the report name. It display the report but how to give name dynamically, for example i want to put the report name through textbox and want to show the report at runtime.
Answer Question
| February 26, 2010 10:54 AM
C#, SSRS 2005, SSRS reports
Trigger SSRS report when particular table is updated in the database
Hi, I need Trigger or run the SSRS report automaticallty and deliver to my email when some updates happens in particular table. Is that Data driven subscriptions is solution for the above or any other methods to be done. Looking forward you answer quickly Thanks
Answer Question
| December 18, 2009 2:39 PM
SQL Server Reporting Services, SSRS, SSRS reports
Hi, I need Trigger or run the SSRS report automaticallty and deliver to my email when some updates happens in particular table. Is that Data driven subscriptions is solution for the above or any other methods to be done. Looking forward you answer quickly Thanks
Answer Question
| December 18, 2009 2:39 PM
SQL Server Reporting Services, SSRS, SSRS reports
Refresh Reporting Services to view newly added sproc fields
How do I refresh reporting services fields after I have added new fields to my stored procedure? The new felds do not show up in Report Data window. I have tried rebuild and refresh. Neither sem to work. I am using SSRS 2008
Answer Question
| November 8, 2009 4:27 PM
SQL Server Reporting Services, SSRS, SSRS 2008, SSRS reports
How do I refresh reporting services fields after I have added new fields to my stored procedure? The new felds do not show up in Report Data window. I have tried rebuild and refresh. Neither sem to work. I am using SSRS 2008
Answer Question
| November 8, 2009 4:27 PM
SQL Server Reporting Services, SSRS, SSRS 2008, SSRS reports
Exporting SSRS Report in Simple Excel sheet(not formatted)
Hi All, when I export and ssrs report in excel, it gets exported in excel but in a fancy format. I want to export the data in a simple excel sheet format so that I could apply filters or formulaes. If any one of you are aware of this do let me know please. Avhilash.
Answer Question
| August 5, 2009 10:11 AM
Export SSRS Report to Excel, SQL Server Reporting Services, SSRS, SSRS 2005, SSRS reports
Hi All, when I export and ssrs report in excel, it gets exported in excel but in a fancy format. I want to export the data in a simple excel sheet format so that I could apply filters or formulaes. If any one of you are aware of this do let me know please. Avhilash.
Answer Question
| August 5, 2009 10:11 AM
Export SSRS Report to Excel, SQL Server Reporting Services, SSRS, SSRS 2005, SSRS reports
Pagination in SSRS 2005 Reports
I have several reports in SSRS 2005 that consist of a “report header” area with various textboxes (note this is in the body of the report, not a page header) and then a table — sometimes a very long table (and then a “report footer” area with some more textboxes, and also a bona fide [...]
Answer Question
| March 2, 2011 5:09 PM
SSRS 2005, SSRS reports
I have several reports in SSRS 2005 that consist of a “report header” area with various textboxes (note this is in the body of the report, not a page header) and then a table — sometimes a very long table (and then a “report footer” area with some more textboxes, and also a bona fide [...]
Answer Question
| March 2, 2011 5:09 PM
SSRS 2005, SSRS reports
Rename Sheet when report exported to excel
hi, When i export SSRS report to excel, each new page comes with new sheet. The sheet names are default names (sheet1, sheet2.. sheetn). Is there a way to rename these sheet names while exporting. Thanks in Advance, Rachitha.
Answer Question
| November 23, 2009 6:55 AM
Exporting SSRS to Excel, SSRS, SSRS reports
hi, When i export SSRS report to excel, each new page comes with new sheet. The sheet names are default names (sheet1, sheet2.. sheetn). Is there a way to rename these sheet names while exporting. Thanks in Advance, Rachitha.
Answer Question
| November 23, 2009 6:55 AM
Exporting SSRS to Excel, SSRS, SSRS reports
ReportServerService restarting after app domain cant unload
SQL Server Reporting Services (MSSQLSERVER) service terminated unexpectedly. We are rs2005 Version 9.00.3239.00. What is causing this error to happen when in the ReportServerService_Main log there are 11 attempts to unload the app domain from 14:16:18 to 14:19:04 and then this error => e ERROR: Unable to unload app domain, terminating process and the ReportServerService [...]
Answer Question
| November 20, 2008 9:14 PM
Reporting Services 2005, SQL Server 2005, SSRS 2005, SSRS reports
SQL Server Reporting Services (MSSQLSERVER) service terminated unexpectedly. We are rs2005 Version 9.00.3239.00. What is causing this error to happen when in the ReportServerService_Main log there are 11 attempts to unload the app domain from 14:16:18 to 14:19:04 and then this error => e ERROR: Unable to unload app domain, terminating process and the ReportServerService [...]
Answer Question
| November 20, 2008 9:14 PM
Reporting Services 2005, SQL Server 2005, SSRS 2005, SSRS reports
SSRS Memory Performance
Microsoft SQL Server Reporting Services Version 9.00.3239.00 We are experiencing problems with memory and other performance related issues. This is a scaled out deployment with ssrs installed on 2 server web farm (used to be 3) with windows 2003 sp2, 32GB RAM. Customers run 100s of subscriptions (some quite long running) and we are running [...]
Answer Question
| December 2, 2008 9:03 PM
Microsoft SQL Reporting Services, Reporting Services 2005, SQL Server 2005, SSRS 2005, SSRS Errors, SSRS Performance, SSRS reports
Microsoft SQL Server Reporting Services Version 9.00.3239.00 We are experiencing problems with memory and other performance related issues. This is a scaled out deployment with ssrs installed on 2 server web farm (used to be 3) with windows 2003 sp2, 32GB RAM. Customers run 100s of subscriptions (some quite long running) and we are running [...]
Answer Question
| December 2, 2008 9:03 PM
Microsoft SQL Reporting Services, Reporting Services 2005, SQL Server 2005, SSRS 2005, SSRS Errors, SSRS Performance, SSRS reports
Connection issue from analysis to reporting
I have a report pulling the data from analysis services and reporting in SSRS reports. when i try to render the report I can view the report in the local server.when I try to access the same link remotely, I am unable to access the data and I am getting the below error. An error [...]
Answer Question
| September 28, 2008 8:29 PM
JBSReport database, Reporting Services, SSRS, SSRS reports
I have a report pulling the data from analysis services and reporting in SSRS reports. when i try to render the report I can view the report in the local server.when I try to access the same link remotely, I am unable to access the data and I am getting the below error. An error [...]
Answer Question
| September 28, 2008 8:29 PM
JBSReport database, Reporting Services, SSRS, SSRS reports
1
