.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Crystal Reports to SSRS conversion ?

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server
 

HI

Best practices converting Crystal Reports to SSRS Reports ?

It would  highly be appreciated if you can share some issues u did faced while converting Crystal reports to SSRS Reports right from the bottom scratch ?

Thanks .


Rajkumar Yelugu


View Complete Post


More Related Resource Links

Converting crystal reports to ssrs reports

  
Hi, I need a documentation which helps me to convert crystel reports to ssrs. if any one having the procedural documentation you can email to my below mentioned email address that will be helpful to me in my new starting project. naveenjustlikethat@hotmail.com

Migrating from Crystal Reports to SSRS

  
Hi, we are currently evaluating SSRS and its features for making a decision on migrating from Crystal. I have read up on SSRS a bit and just need some confirmation on some of my findings. My company develops Windows applications, distributable via MSI files. The backend is SQL Server 2008. We are currently using Crystal Reports to display reports to the end user using the Crystal .NET viewer control. Crystal Reports are saved as .rpt files and contained in the msi file, therefore deployed to the clients. As we are considering migrating away from Crystal, I had a look at SSRS. It is my understanding that there are two ways of using reports: First, in local mode, which is similar to the way Crystal works: Client-side deployed report files. However, unlike Crystal, the application has to retrieve the data for the report from the database and pass a dataset to the viewer control whereas in Crystal, you just point the report viewer to the database you want to use and it pulls the data itself. The other mode, remote or server mode, has the reports stored in the report server (i.e. SQL Server). The viewer control will be set to the URL of the report, and the report then pulls the data from the SQL database. I am unsure to how you could deploy reports onto the Report Server using a MSI package; it sounds like quite a bit of work as the only way I have found by now is to consume webs

differences between ssrs reports and crystal reports

  

hi....
as u all know about ssrs reports...
now i'm using the crystal reports 
and i want to go through ssrs reports
can anyone answer the following question. 
1)what is the need of ssrs...

differences between ssrs reports and crystal reports

  
hi....

as u all know about ssrs reports...

now i'm using the crystal reports 
and i want to go through ssrs reports

can anyone answer the following question. 
1)what is the need of ssrs...
2)and why we should use ssrs..,
3)what are the advantages
4)what are the disadvantages
5)how it will on work  webapplication..
6)how much loadtime it will take by server
7)whether it is a lightweight application or heavyweight..
8)what the problem that we face in future..

please help me  it'll be very helpfull for me

differences between ssrs reports and crystal reports

  
hi....

as u all know about ssrs reports...

now i'm using the crystal reports 
and i want to go through ssrs reports

can anyone answer the following question. 
1)what is the need of ssrs...
2)and why we should use ssrs..,
3)what are the advantages
4)what are the disadvantages
5)how it will on work  webapplication..
6)how much loadtime it will take by server
7)whether it is a lightweight application or heavyweight..
8)what the problem that we face in future..

please help me  it'll be very helpfull for me

differences between ssrs reports and crystal reports

  
hi....

as u all know about ssrs reports...

now i'm using the crystal reports 
and i want to go through ssrs reports

can anyone answer the following question. 
1)what is the need of ssrs...
2)and why we should use ssrs..,
3)what are the advantages
4)what are the disadvantages
5)how it will on work  webapplication..
6)how much loadtime it will take by server
7)whether it is a lightweight application or heavyweight..
8)what the problem that we face in future..

please help me  it'll be very helpfull for me

crystal reports on mvc 2 vs2008

  

hi, i'm a new user of mvc 2, so, i need to use crystal reports on mvc 2, actually, i'm developing on visual studio 2008, but i can´t run my reports. it's posible run my reports???


thank you very much.


Session with Crystal Reports on IE 8

  

All,

Having a very wierd problem.  I have an application that uses Crystal Reports and it uses what I have found to be a common scenario (I am not a CR expert in any way).  I have an ASPX page that gathers options for the report, and then it goes and gets the data and if there is some, a button appears for them to launch the report.  On clicking that button, the code sets some values in the HttpResponse.Context area, then performs a Server.Transfer to another ASPX page that is our Report Template.  This page contains the CR stuff and it generates a PDF version of the report.  It then does the following code:

 With HttpContext.Current.Response
            .ClearContent()
            .ClearHeaders()
            .ContentType = "application/pdf"
            .AddHeader("Content-Disposition", "inline; filename=Report.pdf")
            .BinaryWrite(s.ToArray)
            .End()
        E

dynamically change column names in Crystal reports

  

I need to develop 3 pages.

On the first page user defines atmost 7 column names to be displayed on the report. I'm saving these names in a Sql DB table 'Columns' with Column_Nm and Column_ID as Table columns.

On the second page I'm retrieving column_Nm from the table and displaying them on the page so that the user enters the data. This data is saved in another table 'Summary' with the Columns column1 through column7.

on the 3rd page I need to show a report of 'Summary' table.

How do I dynamically replace column1 through column7 names with that of 'Column_Nm' on the report?

Any help/suggestions would be appreciated.

 


Desperately need help with crystal reports

  

Hi All,

 I am new to .Net and And I have absoutely no idea about crystal reports. Can anyone please let me know a step by step process of how to design and generate a crystal report in vs2005

I need to ask for start date and endate.. when selected .. i should genarte a report using the existing stiored procedure and the connection string in my web config file..

Please  help.........

Your help willbe very much appreciated..

 


Crystal Reports: Add Professional Quality Reports to Your Application with Visual Studio .NET

  

Crystal Reports for Visual Studio .NET provides a comprehensive reporting solution for .NET developers that is thoroughly integrated with both the Visual Studio .NET IDE and the .NET Framework. Crystal Reports supports ADO.NET, XML Web Services, and ASP.NET server controls and caching. It also integrates seamlessly with the Visual Studio .NET Server Explorer, toolbox, and design environment. It has a rich programming model and flexible options for customizing and deploying reports. These major features and others covered here take the drudge work out of data representation in your own applications.

Andrew Brust

MSDN Magazine May 2002


Crystal Reports can grow fields with large amounts of text layout problem

  

A can grow field in the details section of a crystal report may have so much text that the section will be larger than the remaining space available on the page (the space below the previous record).  The section has vertical lines on it with Extend to bottom of section when printing set to true.  The section starts on a new page (and may continue on the following one).  I want it to start on the page where the last record was laid out, and continue to the new page without leaving a gap with vertical lines on it.  I'm using Crystal Reports 9 and I can't work out how to do it. Has anyone got a solution?


Problems connecting stored procedure to Crystal Reports

  

I am working on updating a reporting system that uses Crystal Reports.  All of the 250+ reports were created in CR 8 and I have been opening up the old files in Visual Studio 2005 and updating the database location.  All I have had to do with all connections to views and even a couple of stored procedures is create a new connection to the database and then update the old report's datasource location.  The reason I need to update the location is so that the .NET application will use the correct driver.  Everything has worked fine up until I got to one stored procedure.  The old version of the report works perfectly with the stored procedure, but when I try to run the report using VS 2005 I keep getting errors.

First I connected to the database using the Oracle OLE DB provider, then updated the location of the stored procedure in the report.  It then prompts me for the two parameter values for the stored procedure, both of which I keep as NULL so that the report parameters will be passed to the procedure.  Then I get the following error:

Query Engine Error: 'ADO Error Code: 0x
Source: OraOLEDB
Description: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'STORED_PROCEDURE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored'

The proce

Share Point integrated SSRS reports rendering when access from external site

  

Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

 
An unexpected error occurred while connecting to the report server. Verify that the report server is avai

SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft

  

HI,

Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.

Thanks.

John.

 


Crystal Reports in ASP.NET

  

I have been trying from the past two weeks to integrate crystal reports into my web application. The problem is "We created some reports using Crystal Reports 2008(Sp2) and we are trying to integrate those reports into webpage. Everything works fine on my local machine but when it is deployed to the production server i ran into a lot of problems..

Problem-1 : First time I load the report it comes to the screen where it prompts for DB  credentials and stucks up there..I mean those are non editable and doesn't go to next screen. On my local machine the report even didn't prompt for DB credentials. Why it prompts when moved to prod'n Box? How to avoid that?

Problem-2: How about the images on parameters screen?

 

Can somebody please help me out with this issue..Can some body have the code for doing all these stuff


ASP.NET MVC2 -- Linq to sql -- Crystal Reports

  

Hi,


I need to generate almost 73 reports using Crystal reports using SQL SERVER. I might get more data from XML so opted ASP.NET MVC2.

I have 2 questions:


1) I have a lot of tables to generate Data Context around 35 ( I was thinking to write more stored procedures). Any help with that?

2) Is it possible to create one Report viewer/Crystal report  to display these reports ( I just need to  Read data by querying on input No CRUD operations)


If somebody can explain me the best process to use. Thanks in Advance. 


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend