ssrs-reports

Anyone know of a tool to convert SSRS (RDL) reports to Crystal Reports (RPT)?

I'm looking for a tool that will assist in the conversion from SSRS to Crystal. I've found numerous tools that will go the other way (From Crystal to SSRS), but none that will work for my specific need. ...

How to get the value of multivalued parameter in textbox in SSRS

when the multivalued parameter is selcted how to get the valu in textbox? eg my dropdown box is having select all, success,failure i want to display the above values in textbox..so i have selected the value for text box as Parameters!value.Value(0) it works if we select only succes or only failure in the drop down box but when we sel...

Cognos to SSRS Migration

Hello All, is there any steps/tool to migrate Cognos report to SSRS report? Any guideline will be helpful. Thanks for help, Jaydeep Kadam ...

ssrs repeat column

I was wondering if its possible/how to make a ssrs report so that a column will increment down the page until the end and then continue in the next column Time Weight Size CONTINUED 1:00 110 14 4:00 113 10 2:00 114 16 5:00 115 13 3:00 112 11 6:00 117 15 End of page ...

How do I hide the left-most column in an SSRS 2008 matrix?

I have a matrix in an SSRS 2008 report. The rows are grouped on the Time field, and the columns are grouped on the FieldName field. Pretty standard stuff, you can see the designer view of it below. This works pretty well, except that in some instances I need to hide the "time" column (highlighted in the image). I've tried setting the...

Best practice to develop SSRS reports using remote server

Hi All, We are having an SSRS server configured over a live IP. Before I can start building reports, I want to know What are best practice for developing reports that are easy to deploy How can I maintain SVN copies of my reports I was suggested to create shared data sources, what are they and what are benifits? What are security rela...

How to pass multi-valued parameters in stored procedure in SSRS

Hi All, I have a question and I am trying to find it from the different websites I am not getting the right answer. My question is: How to pass multi-valued parameters in stored procedure in SSRS. (Query or steps) Thanks in Advance. ...

Drill -up in SSRS

Hi All, What is Drill-up, Drill-down and Drill- through in SSRS. Any steps how to implement in SSRS means in report wizard. Thanks in Advance. ...

SSRS 2008 - Last page is empty and data is missing.

I have a very complex report. I found out, that several rendered report instances of the same report (as PDF) showed an empty last page (only the header and footer was visible). Problem is, there should be data on the last page which is not shown (i.e. the page is empty - although the data is available). I was able to make the data vis...

A data source instance has not been supplied for the data source

I'm currently trying to dynamically send an rdl report to my ReportViewer .net object. I keep getting the error when I do it: A data source instance has not been supplied for the data source "blah" I'm trying to define "blah" in my code behind at runtime. ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Loc...

Is it possible to create a row that spans all columns of a Matrix in SSRS 2008?

Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a person, and each column is a field in a form for that person. The fields themselves are dynamic (and implemented as column groups on the matr...

On demand drilldown report in SSRS 2008

We can implement drilldown report using grouping feature of SSRS 2008, where we just give SSRS filtered data and group expression and rest is doen by SSRS, great. Our problem is that we have very larg data even after giving filter, so it takes lot of time for SSRS to get data and group it. What can be ideal situation is that we have oppr...

export to PDF problem

Hi, I have an ssrs 2005 report, the report has two groups and one nested table inside of a group, the report is displayed correctly in VS as two pages, but when trying to export it to PDF i get 17 page and the only correct pages i get are in the end of the PDF file, so anyone b4 faces such issue? Thanks ...