-
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.
-
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 how to...
Last updated: -
Hi, I have exported my SSRS report to Excel. Everything seems to be fine regarding the alignment of columns etc. However, additional row or two appears colored below the complete table of the report. Can you please help me on removing this?
Last updated: -
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.
-
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 page footer...
Last updated: -
Is there anyway to turn off Wrap Text formating on report rows/colimns as it is exported to EXCEL from Reporting Services 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?
-
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.
Last updated: -
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 of 2008 (with...
-
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 as an XML...
Last updated: -
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.
Last updated: -
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.
Last updated: -
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...
Last updated: -
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
Last updated: -
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?
Last updated: -
Using Oracle 10g Stored proc in SSRS 2005
I'm trying to create a dataset from an oracle stored proc.The stored proc takes in parameters and generate multiple rows through a OUT ref cursor. BUT when I create a dataset and run it I get ONLY one single row. My reports need to show data for multiple persons(multiple rows).Some times when I run...
-
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...
-
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
Last updated: -
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?
Last updated: -
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
Last updated: