Showing posts with label ssrs. Show all posts
Showing posts with label ssrs. Show all posts

Monday, March 26, 2012

Is this possible with SSRS?

Hi. We currently have about a 100 Crystal Reports with embedded images and text in the *.rpt files. If we were to switch to SSRS 2005,
Can we do a global search-and-replace of images and text within the SSRS reports? We have some letterheads that have names of people who might change every year or two.
Are there any tools to convert Crystal Reports *.rpt files to SSRS reports? These 100 reports would be time-consuming trying to convert to SSRS.
Thank you much
Alex

1. Yes.

2.

I’ve been asked many times if Microsoft provide a tool for converting legacy Crystal Reports to SQL Server Reporting Services. The answer is no. However I do know someone who does.

Hitachi Consulting has an RDL generator that will generate RDL from Crystal Report formats. They’re in the States but I’m sure they’ll be able to help UK customers.

You can find a link to their site from this list of all our Reporting Services consulting partners: http://www.microsoft.com/sql/reporting/partners/consulting.asp[/quote]

http://blogs.technet.com/mat_stephen/archive/2005/02/01/convert-crystal-reports-to-sql-server-reporting-services.aspx

|||

1. Unlike Crystal, SSRS has an open XML-based report definition language. So, you can either use a file utility to search and replace or programaitcally load the report definition, e.g. in XMLDOM, with more involved requirements.

2. To my understanding, Business Objects doesn't currently let third-party vendors to offer migration tools. Instead, most companies do this as a service where you pay the company to convert the reports for you. This is actually a good possibility for outsourcing. Greg provided links to some vendors.

Is this possible at all for Parameters in SSRS 2000 version

Ihave 2 parameters in a report, but when i run the report would like to hide one parameter and show just one parameter on reports.

I can use the folloiwng rc:Parameters=false, but it will hide all the parameters.

I want to hode just one parameter and show the other one.

I am using sql server reporting services 2000.

Thank you very much for the information.

Try removing the string for the prompt for the one you want to hide.

Wednesday, March 7, 2012

Is there any way to embed VB OCX control in SSRS ?

Is there any way to embed VB OCX control in SSRS. I have custom OCX control build in VB6 and want to deploy in SSRS. Can any one throw some light on it
Thanks

I have read some articles and learnt that, at present, there is no support for custom controls. If anybody know any information on this please provide here.

Monday, February 20, 2012

Is there an option of adding style sheet for the SSRS application.

I want's to define my custom style for my report project.It should also be consistent.

I doesn't want to set it globally but on the project basis.

Is there any option of defining a style sheet for Sql server reporting services like we do for our web application.

No, there is no way to have a stylesheet for a set of reports in your report project.

You can only modify the style of the report manager by accessing the ReportingServices.css which is usually available in C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportManager\Styles.

Shyam

|||

I have edited the reportingservices.css and then add a new report in my project but nothing happened.

I don't want to edit the style of the report manager .What I want is to edit the report style. [mean the rendering style of the actual report]

Suppose I have to set borderwidth of table =.25pt

bordercolor of table,all of it's cell to silver.

Borderstyle to be windowsinset.

Backgroundcolor of the full layout to be black

How Can I do that ?

|||

As I said earlier, it is not possible.

Shyam