Crystal reports to SQL Server Reports

Hi
Present we are using Crystal reports 9.0 in application.
we like to convert crystal reports to SQL server reports.
Do we need to rewrite all crystal reports into SQl reports again
Would you appreciate if any one give suggestion for hot toconverting
crystal reports to SQL Server Reports .
Regards
VenuI do not know of a conversion tool. We just went through same and re-wrote
our reports. It was fun! RS is a powerful reporting tool and out-classes
crystal.
good luck
--
U. Tokklas
"venu gopal" wrote:
> Hi
> Present we are using Crystal reports 9.0 in application.
> we like to convert crystal reports to SQL server reports.
> Do we need to rewrite all crystal reports into SQl reports again
> Would you appreciate if any one give suggestion for hot toconverting
> crystal reports to SQL Server Reports .
> Regards
> Venu

Crystal Reports Schedulers

Can anyone recommend a good, reasonably low-priced (say, $500 or below) Crystal reports scheduling application that would be compatible with Crystal Reports version 8.0.1.0, running reports that are using Fox Pro tables (in native form) as their data source?

I need to run 16 or so sets of the same 18 reports on a monthly basis.

All help and ideas would be greatly appreciated.

Thanks!Do a google searchsql

Crystal Reports on Web Host

Hi There,

I've built an asp.net application with visual studio 2003. The asp.net application has three crystal reports, they all work fine when i run them on the development machine(my computer) but when I run my program thats on the web I recieve a "Cannot find KeyCodev2.dll or invalid keycode error". Anyway my question is this, the webhost obviously has the .net framework installed, will it ever be possible for my crystal reports to work on the web? Do I need to get my webhost to somehow install crystal reports on the web in order for my reports to work?

Your help would be greatly appreciated.

Thanks.

SimonTry registering that dll and check

Crystal Reports LIcensing

Hi.

I am trying to establish which version of Crystal Reports I need to use.

I wish to use Crystal Reports within a Visual Basic 6 application. The report(s) will be viewed and printable from the application. I also need to distribute the VB6 application for 5 users.

I understand that in one version, the licensing for runtime requirements changed. I am trying to find out at which version it changed.

I really need to be able to do this with no runtime licensing requirements for the distributable DLLs, OCXs etc.

I have an inclination that it's either version 7, 8 or 8.5 ??

Can anyone please help and advise me as to which version I should be using?

Thanks in advance,
Darren

email: darren@.darrenbrook.fsnet.co.ukIn my Crystal Reports 8.5 book (one I bought from the bookstore, not the users manual), it said something about new licensing in version 8.5. I don't have the book with me right now, but from what I remember, it only involves paying royalties to Crystal if you use the embeddable designer that allows the user to create reports at runtime. I'm also pretty sure that you need to purchase the developer edition in order to distribute it to you clients.

Please keep in mind that this infomation may not be completely accurate, it's just what I remember reading. Your best bet is to contact Crystal and ask them.

Here's Crystal's website:
http://support.businessobjects.com

Crystal Reports for VS 2005

Hi, currently I am using Visual Studio 2005 to create a Crystal reports for my application, when i choose the data source from a list of driver, normally we will use OLE DB Provider for SQL Server,

but I saw other provider in the list, which is SQL Native Client, can I use this instead of OLE DB?Hi johnlim,

Yes, you can use the SQL Native client, but it does involved extra supporting files being inlcuded in your setup project. Basically, I would not use it unless you specifically need to access the SQL MDF/LDF data files directly. This is not normally the case with reporting.
I use the ADO provider. It works well and is supported on lots of forums, like this one.
cheers,
Mark Chimes

Quote:

Originally Posted by johnlim20088

Hi, currently I am using Visual Studio 2005 to create a Crystal reports for my application, when i choose the data source from a list of driver, normally we will use OLE DB Provider for SQL Server,

but I saw other provider in the list, which is SQL Native Client, can I use this instead of OLE DB?

crystal reports and recordset

Hello I have done an application that show the records of an access database in a viewer that have movefirst and movelast. I want to create reports of The recordset that match an sql sentence. I have created a report linked to my database and I call it in a form. This report has all the records I want to show in a single page but when I call the report from a recordset selection I want to view all the records in diferent pages in the crystal viewer and print all the pages.
How can I do this? Please help me!you need to increate the height of the details section
or
Goto section expert of Details section
Next to New page After there is button x-2 click that and write this

RecordNumber mod 10 = 0

Crystal reports and page breaks

I have a requirement from our users that they want to add page breaks into the middle of a text field in our application.

This text is being printed in a Crystal report, so they would have the facility then to split text over 1 or more pages without coding needed to be done.

Is it possible to type in (use of varous keys e.g. Ctrl + Shift + A) a special character in the text field which Crystal Reports will process as a new page?

Any assistance would be gratefully received.you can use chr(13). Create new formula having this code

left({field},100)+chr(13)+mid({field},101,len({Feidl})

and set can grow propery to true

Crystal Reports 8.5/ASP 3.0 - report not shown in browser

Hi

I am trying to run a web application which is done using asp 3.0 which uses crystal reports 8.5 for reporting. I am not able to view the report in the browser, it is just showing the Crystal reports viewer control.

Please help me in trobleshooting this...

Thanks,
R.K.T. AshokaAnybody can answer this ?

Hi

I am trying to run a web application which is done using asp 3.0 which uses crystal reports 8.5 for reporting. I am not able to view the report in the browser, it is just showing the Crystal reports viewer control.

Please help me in trobleshooting this...

Thanks,
R.K.T. Ashokasql

Crystal Reports 8 application mapping issue...

When running CR 8 with IIS 4, there were no problems.

Our developers installed IIS 5 and then installed CR 8 but the installation failed to properly setup application mapping so that when you click a link to an .RPT file, you get the actual file without it being processed into a webpage by IIS.

I know I can custom config IIS with extension and executable path to use the proper .rpt and .cri dll's, but I was wondering if there was an explanation for the problem?

Does CR 8 have compatibility problems with IIS 5? or is it something else?

Thanx,

CWTurns out it's not the mapping... everything should be configured to work right but still not converting .rpt to html...

any ideas at all?

crystal reports 7.0 with vb6.0

hello

How i run vb application using a crystal report on any other machine on which crytsal report isn ot installed ?

how can we embedd crystal report in visual basic to make trake ur reports.. ?

Is it possible that we make a crystal report in Crystal report and direct call it on the setup time when other computer not contain crystal report..?

What is the run Time dll required for crystal Report in our application....???

please help me .. if some one know about the process , please alos let me know... thank you

ankur bhatnagarIf you have referenced the crytal reports in your project, then just make a setup of the project and install it in other systems that do not have crystal reports.

The setup will take care of installing the DLLs and OCXs required for crytal reports to run on the system.

Crystl32.OCX is the OCX file for the crystal report control
crviewer.dll is the dll for crystal viewer

Crystal Reports 4.6 not working in XP

My application uses Crystal Reports 4.6 & Visual Basic 6.0. The database is in MS Access 97.

It works on Windows 95, 98, NT 4.0, 2000. My users just upgraded to Windows XP.
But, in Windows XP the report is not shown and no error with .PrintReport(). When I tried with .Action = 1, it shows 2 errors.

1)
Runtime error '5':
Invalid procedure call or argument

2)
Error Number: 20535
Unable to connect: incorrect session parameters.

And the application terminates!

This is the code.

With crwReport
.Destination = crptToWindow
.WindowTitle = "Bill"
.WindowState = crptMaximized
.ReportFileName = "D:\reports\Bill.rpt"
.DataFiles(0) = "D:\client.mdb"
.Action = 1
End With

I have tried creating setup from Package & Deployment Wizard and Visual Studio Installer 1.1 but neither work for Crystal Reports...

I tried to install Crystal Reports 4.6 on user's machine but still it is not working!

The only ultimate solution I got is to install Visual Studio 6.0 on user's machine. Heck, thats a lame way... and my client can't afford it.

Isn't there any other better way??i had the same problem and i was able to get it to work by doing this: download the update here: http://www.randem.com/support.html
Automatic OS Updater for MDAC/JET/DCOM

this is the update that the computer needs for access runtime files and vb files... i installed this on the other xp computer and it fixxed the errors i was havin openin the reports... i stuggld with this for a long time
hope this works...

Crystal Reports +Selection of a particular section

Hi
I am new to .NET and my first assignment is to make to develop Crystal Reports for an applicaiton.This is a pure windows based application.
I have different types of data to be printed based on the selection in a check box.

Can I make a section added by me "visible" based on the data that i checked to be pritned.If so ,please help me with some sampel code.Visible I mean ,the checked data should be shown after I run the application

Hope to hear from some one soon.I spent the whole day searching for some tips!!!Hi,

At first create one Project and add one form into the project...... add option controls to it and add 1 button control to it and name it as generate report..in Generate report click event add this code.....Don't forget to get Crystal Report Viewer on to the form....

Declaration section.........

Public ReportType As String
Public FAErlangs As New FA_ErlangProjections
Public FARProjections As New FA_RadiosProjection
Public FATProjections As New FA_TimeslotsProjection

in button click event......

If optTrafficProjections.Checked = True Then
CrystalReportViewer1.ReportSource = FAErlangs
CrystalReportViewer1.EnableDrillDown = False
ElseIf optFARProj.Checked = True Then
CrystalReportViewer1.ReportSource = FARProjections
CrystalReportViewer1.EnableDrillDown = False
ElseIf optFATProj.Checked = True Then
CrystalReportViewer1.ReportSource = FATProjections
CrystalReportViewer1.EnableDrillDown = False
End If

hope this works for you...... if you have any questions mail me at garlapati76@.yahoo.com.

Thanks.sql

crystal reports (urgent)

Public crxapplication As CRAXDRT.Application
Public crxreport As CRAXDRT.Report

Dim strReportName As String
Dim Fltr
crxapplication = New CRAXDRT.Application

'Pass the reportname to string variable
strReportName = "CITIES"

'Get the Report Location
Dim strReportPath As String = "C:\ReportViwer\ReportViwer" & "\" & strReportName & ".rpt"
'Check file exists
If Not IO.File.Exists(strReportPath) Then
Throw (New Exception("Unable to locate report file:" & vbCrLf & strReportPath))
End If
crxreport = crxapplication.OpenReport(strReportPath)
crxreport.DiscardSavedData()

'Delete all the original parameter values from the parameter picklist.
'If you want to keep the orginal parameter values in the parameter picklist, comment out this loop.
Do Until crxreport.ParameterFields(1).NumberOfDefaultValues = 0
crxreport.ParameterFields(1).DeleteNthDefaultValue(1)
Loop
crxreport.Database.Tables(1).SetDataSource(RS, 3)
' Read the records to force the parameter box to appear before sending data to the viewer
crxreport.ReadRecords()
Fltr = "{CITY_CITIES.COUNTRY_NO}={?COUNTRY_NO}"
' Get the value the user enters in the parameter box then send that text to the formula field (that ' the report is grouped on)
crxreport.RecordSelectionFormula = Fltr
' View the report
AxCrystalActiveXReportViewer1.ViewReport()
End Sub

The error I am getting is An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in axinterop.crystalactivexreportviewerlib10.dll

Additional information: Unspecified error

Can I have your help please.Which line are you getting the error?

crystal reports (the coder way) ?

Hi

I have a .NET application that needs to obtain the details of the parameters for a crystal report.

I have written some code, that opens a report into the crystal viewer and the gets the parameter info and displays it in a msgbox.

However, the viewer prompts for the parameters, before i get a chance to get the information and display it.:(

My question is, does anyone know of a way that i can get the parameter information from a report, without the user being prompted for the parameters ?

Thanks in anticipation[Moved thread]|||YOu need to populate the parameters to the report before viewing it the viewer or printing it to the printer.

here is a sample from VB on how to populate parameters and formulas.

Dim crFormula As CRAXDRT.FormulaFieldDefinition
Dim crParam As CRAXDRT.ParameterFieldDefinition

crReport.DiscardSavedData

For Each crParam In crReport.ParameterFields
Select Case crParam.Name
Case "{?SortType}"
crParam.AddCurrentValue m_strSortType

End Select
Next crParam


For Each crFormula In crReport.FormulaFields
Select Case crFormula.Name
Case "{@.StartDate}"
crFormula.Text = "DATE( 2001, 01, 01)"
Case "{@.EndDate}"
crFormula.Text = "DATE( 2002, 03, 30)"
crFormula.Text = """All Offices"""
Case "{@.DetailOrSummaryFlag}"
crFormula.Text = """" & m_strSummaryDetailFlag & """"
Case "{@.Seperate}"
crFormula.Text = """FALSE"""
Case "{@.SetShowWarning}"
crFormula.Text = """FALSE"""
Case Else
'do nothing
End Select
Next crFormula|||Hi

I have a .NET application that needs to obtain the details of the parameters for a crystal report.

I have written some code, that opens a report into the crystal viewer and the gets the parameter info and displays it in a msgbox.

However, the viewer prompts for the parameters, before i get a chance to get the information and display it.:(

My question is, does anyone know of a way that i can get the parameter information from a report, without the user being prompted for the parameters ?

Thanks in anticipation

Dim APP As New CRAXDRT.Application
Dim REPORT As CRAXDRT.Report
REPORT = APP.OpenReport("C:\SHIPMENT_SCHEDULE\REPORTS\XL.rpt")

REPORT.EnableParameterPrompting = False
(this is the one you should include...disabling the parameter prompting)

crystal reports

how can i design the crystal reports in windows application using C#.
what code i should write to get all the fields in a report format which should be generated into a crystal report.Visit www.VBCity.com and search in Crystal Reports section|||As you specified on that topic, Doevents would do that. You need to write it twice or thrice

Doevents
Doevents
Doevents

crystal report.. on network application

i m using crystal report with vb...

i have designed a report with a table on it..
the table creates when user click on the preview button on the form..
named tmpAccountLedger..

but when 2 or more users click at the same time..with the different account specifie.d...
the report shows the same for all users..

what should i do..
plz suggest..
regards.What's the underlying database? Can you use a session table? Can you use some sort of id to uniquely name each table creation? I assume you drop it at the end somehow?|||For MSSQL, I use global temporary tables for such purposes. When developing a report, I create a normal "dummy" table with prefix "_tmp_" that can be used for building report. At runtime, I create global temporary table like "##SF93DXU2" with same structure, and replace the name of original dummy table with the name of actual temporary table. Works fine. You can even forget to drop the table afterwards and SQL will clean it up for you. In fact, there are situations where you can't drop the table yourself (for example, if temporary table is used in a subreport at the end of the report, then it is not queried immediately but only when the user reaches the page that contains subreport).

Crystal Report. new with web services

Hi everybody

I want to publish my reports as a web service and then consume them from a web application. However all the reports should be exportable to excel, word, pdf format. I tried to write my web service on my own and couldnt succeed. Web service only returns xml schema and how do i get the final report from web services. Publishing them as a web service individually doesnt work because then i cant use the report engine object model which eliminates my success in exporting

Any ideas? Please helpHope u r using CR 9. There are two ways to publish ur reports in web and u may download sample applications from their web site

Click Here for RAS Samples (http://support.businessobjects.com/communityCS/TechnicalPapers/apps_ras.pdf.asp)

Click Here For RDC Samples (http://support.businessobjects.com/communityCS/FilesAndUpdates/aspxmps9.exe.asp)

Hope this will help!|||I am using crystal reports .net version coming with visual studio .net. I think i am missing an important detail. All of those applications are with report application servers. Do i have to have a report application server?|||Hope you might have

Search their product documentation. u'll get everything

Crystal REport run time error 6 over flow

In win98 se..i get run time error 6 over flow..when i try to open crystal report through a vb application on the client machine...i try to isolate the problem..what i found is that while displaying images..there is no problem..integers no problem but when data in string format (for example product name) is put onto the report..it prompts this error...the applicaiton works fine on xp..i dont know how to fix this problem..could any one please help meCheck if there are any viruses on that system
What does that string look like?
Does it have special characters?

Crystal Report Performence Issue

Hi All,

I am new in Crystal Report.net2005.
I have used VB.net Application, Access 2003 as back end database.
I am using dataset for viewing crystal report.

My prob is that:

For th first time my reports are taking too much time to show.
But the next time it's not taking so much time.

It's happening every time when i exit the application.

Please give solution

Thank in Advance

Mayukh.What happens if you run the Crystal generated SQL directly in Access? Is it slow the first time and quicker next time?|||First time to make connection and pull data it takes sometime. But next time it would be faster as connection is already there until you refresh the report

Crystal Report high time taking to load:

In my application , crystal report taking too much time. My Report have more than 50,000 records to display. Report not showing first page untill it receives data of total 50000 records. After reciving total records from database then it is showing first page. It is taking more than 10 mins time. How to solve this problem?Hi. . .

I too have the same problem. My report contains more than 100 pages and it's taking quite a long time to display the report.

Is there any way we can start displaying the report as soon page1 gets filled with the required data??

Any hep pls!!

Thank you all.|||I'm not sure I have the answer but here area couple of things you can check.
Are you using page number or page N of M? If you are using N of M the first page can not be displayed until the last page has been calculated so it can display the total number of pages in N of M.

Are you using indexed fields for your table joins?

Do you have "perform grouping on Server" and "use indexes on server for speed" checked in the oprtions?

Does the SQL for your report have a where clause? If not, the processing can not be pushed to the server.

Good luck and I hope this helps a little.