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...

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?

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...

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.

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...

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.

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...

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?

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.

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...

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...

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

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy