SSRS 2008 R2 Trendlines
I cannot find out how to add trendlines to my SSRS 2008 R2 report. TechNet http://technet.microsoft.com/en-us/library/dd207034.aspx refers to a ‘Values’ area and an option to ‘Add Calculated Series’. The ‘Values’ area I see does nothing on a “Right-click” and the option to “Add Calculated Series” I cannot find anywhere.
Answer Question
| October 25, 2011 8:19 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008
I cannot find out how to add trendlines to my SSRS 2008 R2 report. TechNet http://technet.microsoft.com/en-us/library/dd207034.aspx refers to a ‘Values’ area and an option to ‘Add Calculated Series’. The ‘Values’ area I see does nothing on a “Right-click” and the option to “Add Calculated Series” I cannot find anywhere.
Answer Question
| October 25, 2011 8:19 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008
How to configure parameters display in SSRS 2008?
Hi, I know it wasn’t possible in ssrs 2005 to have parameters displayed into more than 2 columns. My question is has it be solved in ssrs 2008r2 ? If yes, how can I do it ? If no, is there a possibility to walk around this issue ? Many thanks, Sonia
Answer Question
| March 31, 2012 11:29 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2008
Hi, I know it wasn’t possible in ssrs 2005 to have parameters displayed into more than 2 columns. My question is has it be solved in ssrs 2008r2 ? If yes, how can I do it ? If no, is there a possibility to walk around this issue ? Many thanks, Sonia
Answer Question
| March 31, 2012 11:29 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2008
Using the PIVOT function
Hi there, I’m pretty new to SQL and I’m trying to use the PIVOT function in Sequel Server 2008 R2. I’ve followed a whole bunch of examples and tutorials but just can’t quite get my syntax right. I have a database of applications. Fields include ApplicationID, Status Description and StatusID, and the date each status [...]
Answer Question
| March 31, 2012 9:13 AM
PIVOT, SQL Server 2008, SQL Server 2008 Reporting Services, SQL Server Reporting Services
Hi there, I’m pretty new to SQL and I’m trying to use the PIVOT function in Sequel Server 2008 R2. I’ve followed a whole bunch of examples and tutorials but just can’t quite get my syntax right. I have a database of applications. Fields include ApplicationID, Status Description and StatusID, and the date each status [...]
Answer Question
| March 31, 2012 9:13 AM
PIVOT, SQL Server 2008, SQL Server 2008 Reporting Services, SQL Server Reporting Services
SQL Report Help
Hi I’m dave and I’m new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return [...]
Answer Question
| June 1, 2011 11:35 PM
Reporting, SQL, SQL Reports, SQL Server Reporting Services, SQL Server Reports, SSRS
Hi I’m dave and I’m new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return [...]
Answer Question
| June 1, 2011 11:35 PM
Reporting, SQL, SQL Reports, SQL Server Reporting Services, SQL Server Reports, SSRS
SSRS Report switch for Operational DB to DWH
We currently are running a large report off of the operational DB but in turn used this report to create a DWH in order to get this report to run faster. Before we used a stored procedure with many smaller queries that summed our numbers. Since we have the DWH that stores all this needed [...]
Answer Question
| February 16, 2011 2:43 PM
SQL Server data warehousing/business intelligence, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008
We currently are running a large report off of the operational DB but in turn used this report to create a DWH in order to get this report to run faster. Before we used a stored procedure with many smaller queries that summed our numbers. Since we have the DWH that stores all this needed [...]
Answer Question
| February 16, 2011 2:43 PM
SQL Server data warehousing/business intelligence, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008
SRS 2005 Export to EXCEL
Is there anyway to turn off Wrap Text formating on report rows/colimns as it is exported to EXCEL from Reporting Services 2005
Answer Question
| January 11, 2011 1:20 PM
SQL Export to Excel, SQL Server 2005, SQL Server Reporting Services, SSRS 2005
Is there anyway to turn off Wrap Text formating on report rows/colimns as it is exported to EXCEL from Reporting Services 2005
Answer Question
| January 11, 2011 1:20 PM
SQL Export to Excel, SQL Server 2005, SQL Server Reporting Services, SSRS 2005
SSRS Report Export to Excel
When exported to Excel, some data is hidden from view by the row heigth. Rows must be expanded to view. Please suggest me a nice solution so that if the data is more than the single line, it has to expand the row height.
Answer Question
| November 22, 2010 7:14 AM
excel, SQL Server, SQL Server Reporting Services, SSRS, SSRS 2005
When exported to Excel, some data is hidden from view by the row heigth. Rows must be expanded to view. Please suggest me a nice solution so that if the data is more than the single line, it has to expand the row height.
Answer Question
| November 22, 2010 7:14 AM
excel, SQL Server, SQL Server Reporting Services, SSRS, SSRS 2005
SSRS 2008 from SSRS 2005, Authentication
Currently I am running a 2005 SSRS Website, and 7/9 of my reports are done in 2005, and when I try access the 2 reports in 2008, it prompts me to enter my user name and password again, with this converter, will it solve this issue? I need a solution to get around the authentication [...]
Answer Question
| October 21, 2010 10:32 AM
SQL Server, SQL Server authentication, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2005, SSRS 2008
Currently I am running a 2005 SSRS Website, and 7/9 of my reports are done in 2005, and when I try access the 2 reports in 2008, it prompts me to enter my user name and password again, with this converter, will it solve this issue? I need a solution to get around the authentication [...]
Answer Question
| October 21, 2010 10:32 AM
SQL Server, SQL Server authentication, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2005, SSRS 2008
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
SQL Server Business INtelligence
While creating a report, is it ok to create data set using stored procedure by calling an existing one from the database, or, by creating a stored procedure within BIDS and imeplement it? Please, explain. Thanx in advance.
Answer Question
| April 25, 2010 9:16 AM
SQL Server 2005, SQL Server Reporting Services, SQL Server stored procedures
While creating a report, is it ok to create data set using stored procedure by calling an existing one from the database, or, by creating a stored procedure within BIDS and imeplement it? Please, explain. Thanx in advance.
Answer Question
| April 25, 2010 9:16 AM
SQL Server 2005, SQL Server Reporting Services, SQL Server stored procedures
SSRS statistics
Hi, I new to SSRS. I have a table grouped by a category. I need to make a statistics about number of rows of particular item and sum of few columns in each of the group. I can make those statistics inside the tablix. But I need to have those statistics outside of the tablix [...]
Answer Question
| December 21, 2009 1:50 AM
SQL Server 2008, SQL Server Reporting Services, SSRS
Hi, I new to SSRS. I have a table grouped by a category. I need to make a statistics about number of rows of particular item and sum of few columns in each of the group. I can make those statistics inside the tablix. But I need to have those statistics outside of the tablix [...]
Answer Question
| December 21, 2009 1:50 AM
SQL Server 2008, SQL Server Reporting Services, SSRS
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
Transposing a table in SQL Server Reporting Services Layout.
Hi Eveyone, Can anybody tell me that [strong]How to Transpose a table in SQL Server Reporting Services Layout?[/strong] I am having my data displayed in a [strong]Table[/strong] inn SSRS 2005; Please help… Thanks, Swapnil
Answer Question
| December 17, 2009 11:06 AM
SQL Server Reporting Services, SSRS, SSRS 2005, SSRS Table Transposing
Hi Eveyone, Can anybody tell me that [strong]How to Transpose a table in SQL Server Reporting Services Layout?[/strong] I am having my data displayed in a [strong]Table[/strong] inn SSRS 2005; Please help… Thanks, Swapnil
Answer Question
| December 17, 2009 11:06 AM
SQL Server Reporting Services, SSRS, SSRS 2005, SSRS Table Transposing
(rsErrorOpeningConnection) Could not obtain information about Windows NT
I am trying to deploy a report to the Reporting Services Server 2008 but keep running up against this error:
Answer Question
| December 8, 2009 6:41 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2008, Windows NT
I am trying to deploy a report to the Reporting Services Server 2008 but keep running up against this error:
Answer Question
| December 8, 2009 6:41 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2008, Windows NT
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
Reordering the Table position in SSRS
Is there any provision to reorder the table position in a rdl? I have two tables, say A and B where A is placed after B at design time. Can I reposition them with B coming first and then A at run time?
Answer Question
| October 5, 2009 5:10 AM
SQL Server Reporting Services, SSRS, SSRS 2005
Is there any provision to reorder the table position in a rdl? I have two tables, say A and B where A is placed after B at design time. Can I reposition them with B coming first and then A at run time?
Answer Question
| October 5, 2009 5:10 AM
SQL Server Reporting Services, SSRS, SSRS 2005
SSRS – SQL runs in 1 minute but Reporting Services tuns for 30 minutes
I have a report whose dataset query that takes approximately 1 minute to run in SQL Management Server. That same query in a Reporting Services report takes aver 30 minutes to run. And it is inconsistent in its behavior since sometimes it will never finish running and error out. When it does run and it is [...]
Answer Question
| September 16, 2009 4:15 PM
SQL, SQL performance, SQL Server Reporting Services, SSRS
I have a report whose dataset query that takes approximately 1 minute to run in SQL Management Server. That same query in a Reporting Services report takes aver 30 minutes to run. And it is inconsistent in its behavior since sometimes it will never finish running and error out. When it does run and it is [...]
Answer Question
| September 16, 2009 4:15 PM
SQL, SQL performance, SQL Server Reporting Services, SSRS
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
Crystal Reports to SSRS
There is a proposal to migrate existing CR(11) application to SSRS for speed of execution as well as more flexibilty. WE have JPEG2000 images in the database and these are neither getting rendered in Crystal Reports nor in SSRS. Any suggestions on how I can make these JPEG2000 images render in the reports ? Also [...]
Answer Question
| July 18, 2010 4:44 PM
Crystal Reports, Crystal Reports XI, SQL Server Reporting Services, SSRS
There is a proposal to migrate existing CR(11) application to SSRS for speed of execution as well as more flexibilty. WE have JPEG2000 images in the database and these are neither getting rendered in Crystal Reports nor in SSRS. Any suggestions on how I can make these JPEG2000 images render in the reports ? Also [...]
Answer Question
| July 18, 2010 4:44 PM
Crystal Reports, Crystal Reports XI, SQL Server Reporting Services, SSRS
