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
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
Passing parameters to report viewer
Hi Kindly excuse me if I appear a bit ignorant on this subject as I am relatively new to SSRS. I have managed to create a report that has 3 parameters (ie. Start Date,End Date,Drop down list) which I have successfully deployed to Report Server. The report basically uses a stored procedure which has the [...]
Answer Question
| April 19, 2013 11:52 AM
C, C# .NET, Parameters, SSRS
Hi Kindly excuse me if I appear a bit ignorant on this subject as I am relatively new to SSRS. I have managed to create a report that has 3 parameters (ie. Start Date,End Date,Drop down list) which I have successfully deployed to Report Server. The report basically uses a stored procedure which has the [...]
Answer Question
| April 19, 2013 11:52 AM
C, C# .NET, Parameters, SSRS
Export Oracle data to Excel
Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks
Answer Question
| September 29, 2009 6:16 PM
Oracle, Oracle export, SQL, SSRS
Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks
Answer Question
| September 29, 2009 6:16 PM
Oracle, Oracle export, SQL, SSRS
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
Accessing SSRS from a Web server
We have a Web server at our collocation site with public access. On the server, there is a simple menu with links that call SQL Server Reporting Services. We also have another server — with SQL Server 2005 — that contains our database and reporting services. This one is only on the internal network — [...]
Answer Question
| July 9, 2009 3:22 PM
SQL Server 2005, SQL Server Reporting Services, SSRS, SSRS Access from a Web Server, VPN
We have a Web server at our collocation site with public access. On the server, there is a simple menu with links that call SQL Server Reporting Services. We also have another server — with SQL Server 2005 — that contains our database and reporting services. This one is only on the internal network — [...]
Answer Question
| July 9, 2009 3:22 PM
SQL Server 2005, SQL Server Reporting Services, SSRS, SSRS Access from a Web Server, VPN
Insert Word document into SSRS
How can I import/insert a word document into a report in SSRS?
Answer Question
| June 23, 2009 5:48 PM
Microsoft Word, SQL Server Reporting Services, SSRS
How can I import/insert a word document into a report in SSRS?
Answer Question
| June 23, 2009 5:48 PM
Microsoft Word, SQL Server Reporting Services, SSRS
SSRS 2000 Support Ending Date
Is there a data set when SSRS 2000 will no longer be supported?
Answer Question
| June 16, 2009 4:03 PM
SQL Server Reporting Services, SSRS, SSRS 2000, SSRS Support
Is there a data set when SSRS 2000 will no longer be supported?
Answer Question
| June 16, 2009 4:03 PM
SQL Server Reporting Services, SSRS, SSRS 2000, SSRS Support
ssrs interview questions and answers
ssrs interview questions and answers
Answer Question
| May 19, 2011 2:43 PM
Careers, SSRS, SSRS Careers
ssrs interview questions and answers
Answer Question
| May 19, 2011 2:43 PM
Careers, SSRS, SSRS Careers
Export SSRS Report to Microsoft Excel
Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.
Answer Question
| June 10, 2009 4:19 AM
Microsoft Excel import/export, SQL Server Reporting Services, SSRS
Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.
Answer Question
| June 10, 2009 4:19 AM
Microsoft Excel import/export, SQL Server Reporting Services, SSRS
Integrate MOSS with SQL Server 2008
Can someone provide a step-by-step or point me to a guide for integrating MOSS with SQL Server 2008? Thank you very much. Moderator Note: This is a submitted question
Answer Question
| April 10, 2009 8:20 PM
MOSS, MOSS interoperability, SQL Server 2008 interoperability, SQL Server 2008 Reporting Services, SQL Server Reporting Services, SSRS, Visual Studio 2008
Can someone provide a step-by-step or point me to a guide for integrating MOSS with SQL Server 2008? Thank you very much. Moderator Note: This is a submitted question
Answer Question
| April 10, 2009 8:20 PM
MOSS, MOSS interoperability, SQL Server 2008 interoperability, SQL Server 2008 Reporting Services, SQL Server Reporting Services, SSRS, Visual Studio 2008
Possible to deploy 2005 report to sql 2000 RS?
I’ve never needed to do this before, but I need to know if I can deploy a report built with VS 2005 to a SQL 2000 Reporting Services box. I don’t have an environment at the moment to test it on. Does anyone know if this is possible? Thank you in advance, tley
Answer Question
| March 16, 2009 4:41 PM
SQL Server 2000, SQL Server Reports, SSRS, SSRS 2000, Visual Studio, Visual Studio 2005, VS 2005
I’ve never needed to do this before, but I need to know if I can deploy a report built with VS 2005 to a SQL 2000 Reporting Services box. I don’t have an environment at the moment to test it on. Does anyone know if this is possible? Thank you in advance, tley
Answer Question
| March 16, 2009 4:41 PM
SQL Server 2000, SQL Server Reports, SSRS, SSRS 2000, Visual Studio, Visual Studio 2005, VS 2005
Auto filter of distinct values on columns in SQL Server Reporting Services?
Is there a way to have an auto filter of distinct values on columns in SQL Server Reporting Services?
Answer Question
| March 25, 2009 6:13 PM
SQL Server Reporting Services, SSRS
Is there a way to have an auto filter of distinct values on columns in SQL Server Reporting Services?
Answer Question
| March 25, 2009 6:13 PM
SQL Server Reporting Services, SSRS
Predefine a named range for an exported SQL Server Reporting Services report
How can you predefine a named range for an SQL Server Reporting Services report exported to Excel? In particular, the named range must have a specific name, along with referring to a set of cells with specific columns for all rows rendered for the given table control. I am running SQL Server 2005 SP3 with [...]
Answer Question
| February 11, 2009 9:05 PM
Excel 2003, Microsoft Excel, Microsoft Excel 2003, SQL Server Reporting Services, SSRS
How can you predefine a named range for an SQL Server Reporting Services report exported to Excel? In particular, the named range must have a specific name, along with referring to a set of cells with specific columns for all rows rendered for the given table control. I am running SQL Server 2005 SP3 with [...]
Answer Question
| February 11, 2009 9:05 PM
Excel 2003, Microsoft Excel, Microsoft Excel 2003, SQL Server Reporting Services, SSRS
Date Parameters in SSRS – showing total by day as well as by total by parameter chosen
I have a date range parameter set up in SSRS. I need to show the total for each day chosen in the data range parameter as well as the grand total of the entire filtered selection. Is this possible?
Answer Question
| February 2, 2009 9:56 PM
SSRS, SSRS 2005
I have a date range parameter set up in SSRS. I need to show the total for each day chosen in the data range parameter as well as the grand total of the entire filtered selection. Is this possible?
Answer Question
| February 2, 2009 9:56 PM
SSRS, SSRS 2005
Field data in Footer SSRS 2005
I need to put field data in the footer of a report so it repeats on ever page of the report. How do I get be Header/Footer constraints.
Answer Question
| March 26, 2009 10:37 PM
Reporting Services 2005, SQL Server 2005 Reporting Services, SQL Server Reporting Services, SSRS, SSRS 2005, SSRS 2005 header and footer, SSRS 2005 report formatting
I need to put field data in the footer of a report so it repeats on ever page of the report. How do I get be Header/Footer constraints.
Answer Question
| March 26, 2009 10:37 PM
Reporting Services 2005, SQL Server 2005 Reporting Services, SQL Server Reporting Services, SSRS, SSRS 2005, SSRS 2005 header and footer, SSRS 2005 report formatting
Transposing a table using SQL Server Reporting Services in VB.NET
How can I transpose a table using SQL Server Reporting Services in VB.NET?
Answer Question
| January 21, 2009 6:18 PM
SQL Server Reporting Services, SQL Server tables, SSRS, SSRS Table Transposing, VB.NET
How can I transpose a table using SQL Server Reporting Services in VB.NET?
Answer Question
| January 21, 2009 6:18 PM
SQL Server Reporting Services, SQL Server tables, SSRS, SSRS Table Transposing, VB.NET
