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
Error trying to get a store produce to work from AS 400 to SSRS
I have made a store procedure that runs fine but when I try to Call it into SSRS I am getting an error. The Error says SP_Convert_Date_MMDDYYY_to_CYYMMDD in *N type *N not found. Is there anyway of getting it to find my file in the AS 400 and what would I have to do?
Answer Question
| December 2, 2010 7:14 PM
AS/400, SSRS, SSRS 2005, SSRS 2005 errors
I have made a store procedure that runs fine but when I try to Call it into SSRS I am getting an error. The Error says SP_Convert_Date_MMDDYYY_to_CYYMMDD in *N type *N not found. Is there anyway of getting it to find my file in the AS 400 and what would I have to do?
Answer Question
| December 2, 2010 7:14 PM
AS/400, SSRS, SSRS 2005, SSRS 2005 errors
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
Converting 2008 RDL to 2005 version
Dear All, 2008 RDL can be converted to 2005 version easily through a software. Please visit: applybi.com Thanks & Regards, Amar Sale
Answer Question
| October 22, 2012 2:08 PM
Database reporting, Microsoft Business Reporting Service, RDL, Report Server, SSRS 2005, SSRS 2008
Dear All, 2008 RDL can be converted to 2005 version easily through a software. Please visit: applybi.com Thanks & Regards, Amar Sale
Answer Question
| October 22, 2012 2:08 PM
Database reporting, Microsoft Business Reporting Service, RDL, Report Server, SSRS 2005, SSRS 2008
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
Reporting Services 2005
Hello, I am running reporting services 2005. I created a subscrition for a report named “paid_claims” that will auto generate an excel file into a shared folder on the network. The “paid_claims” report has a link to another report named “sub_paid_claims” in the same folder. We recently renamed our server from MEDI01a to MEDI01, when [...]
Answer Question
| January 13, 2010 4:23 PM
Reporting, Reporting Services, Reporting Services 2005, SSRS, SSRS 2005
Hello, I am running reporting services 2005. I created a subscrition for a report named “paid_claims” that will auto generate an excel file into a shared folder on the network. The “paid_claims” report has a link to another report named “sub_paid_claims” in the same folder. We recently renamed our server from MEDI01a to MEDI01, when [...]
Answer Question
| January 13, 2010 4:23 PM
Reporting, Reporting Services, Reporting Services 2005, SSRS, SSRS 2005
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
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
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
Configuration of Report Server – no errors but Window Service Identity shows not configured
Using Vista SP 2 and SSRS 2005. When in the Windows Service Identity, I only see the Local Systems in the Built-in Accounts. I have read in a few documents that normally there are 3 options, (Local System, Network Service, Local Service). Can someone tell me where this list gets it’s values? I think the [...]
Answer Question
| July 10, 2009 3:53 PM
Report Server, SQL Server Reporting Services, SSRS 2005, Vista
Using Vista SP 2 and SSRS 2005. When in the Windows Service Identity, I only see the Local Systems in the Built-in Accounts. I have read in a few documents that normally there are 3 options, (Local System, Network Service, Local Service). Can someone tell me where this list gets it’s values? I think the [...]
Answer Question
| July 10, 2009 3:53 PM
Report Server, SQL Server Reporting Services, SSRS 2005, Vista
How to delete spaces in charts
Hi All I am facing some problems with charts in ssrs 2005. i have inserted 5 graphs in report.Each graph is set by filter.When i run the report ,it is giving some blank spaces if chart doesnt have any values.So how can i solve my problem. Any help would be appreciated . Regards, Anitha
Answer Question
| July 6, 2009 1:29 AM
SQL Server Reporting Services, SSRS 2005, SSRS 2005 report formatting
Hi All I am facing some problems with charts in ssrs 2005. i have inserted 5 graphs in report.Each graph is set by filter.When i run the report ,it is giving some blank spaces if chart doesnt have any values.So how can i solve my problem. Any help would be appreciated . Regards, Anitha
Answer Question
| July 6, 2009 1:29 AM
SQL Server Reporting Services, SSRS 2005, SSRS 2005 report formatting
SSRS Excel Reports
Hi, I have exported my ssrs report to excel.Everything seems to be fine regarding the alginment of columns etc. However, additional row or two appears colored below the complete table of the report. Can u please help me on removing this??
Answer Question
| June 17, 2009 5:18 AM
Microsoft Excel, SQL Server Reporting Services, SSRS 2005
Hi, I have exported my ssrs report to excel.Everything seems to be fine regarding the alginment of columns etc. However, additional row or two appears colored below the complete table of the report. Can u please help me on removing this??
Answer Question
| June 17, 2009 5:18 AM
Microsoft Excel, SQL Server Reporting Services, SSRS 2005
How do you add Name and mail to Address fields to a grouped report.
How do you add Name and Address fields to the body of a Grouped table report?
Answer Question
| June 8, 2009 2:53 PM
SQL Server Reporting Services, SSRS 2005
How do you add Name and Address fields to the body of a Grouped table report?
Answer Question
| June 8, 2009 2:53 PM
SQL Server Reporting Services, SSRS 2005
Create report using Reportingservice, from a selected record from Datagrid
Is it posible to bind the data from a record to a report, by clicking on that record in a Datagridview. Please some example code. Thanks, Matthew
Answer Question
| May 4, 2009 4:29 PM
DataGridView, Reporting Services 2005, SSRS 2005
Is it posible to bind the data from a record to a report, by clicking on that record in a Datagridview. Please some example code. Thanks, Matthew
Answer Question
| May 4, 2009 4:29 PM
DataGridView, Reporting Services 2005, SSRS 2005
Migrating SQL Reporting Services 2000 Reports to SRS 2005?
We are in the process of upgrading our SQL Reporting services 2000 to 2005. We have installed SQL Server, etc on a difference box. We now need to move the reports (i assume RDL files) from our SRS 2000 box to our new SRS 2005 box. Is there any documentation, step by step instructions on [...]
Answer Question
| April 30, 2009 9:01 PM
SQL Server Reporting Services, SSRS 2000, SSRS 2005, SSRS Migration
We are in the process of upgrading our SQL Reporting services 2000 to 2005. We have installed SQL Server, etc on a difference box. We now need to move the reports (i assume RDL files) from our SRS 2000 box to our new SRS 2005 box. Is there any documentation, step by step instructions on [...]
Answer Question
| April 30, 2009 9:01 PM
SQL Server Reporting Services, SSRS 2000, SSRS 2005, SSRS Migration
MSSQL Reporting services
Can a single report show more than one graph? Consider I have 4 queries to show graphs for and I’d like to have all of them in one single report, is this possible?
Answer Question
| April 13, 2009 8:34 AM
SQL Server Reporting Services, SSRS 2005, SSRS 2005 report formatting
Can a single report show more than one graph? Consider I have 4 queries to show graphs for and I’d like to have all of them in one single report, is this possible?
Answer Question
| April 13, 2009 8:34 AM
SQL Server Reporting Services, SSRS 2005, SSRS 2005 report formatting
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
