crystal reports XI with ascii file

hello CR users,
i'am nearly completely new in the CR field, so sorry for my question...

i have a big ascii file about 300mb. how can i use this file within CR?
is there any way to convert this ascii file into a excel file ore wathever so i can use it.
smaller pieces of this file i can convert into a 'comma separately' csv file.
but there is no well formatet column separation...

i would be very happy if there is somebody out there how wuold post a short solution for this...
thanks HagenSo do you want to show the Ascii values in the report?

crystal reports CD image

What would be the name of a crystal reports 8.5 CD image file. This is required for installing a decryption patch.Search here
www.businessobjects.com

Crystal Reports 8.5 question

Can anybody point me in the right direction for using a flat file to feed Crystal Reports?If I understand correctly, a flat file is basically a text file that contains your data?

Whether I understand correctly or not, this may help you...

Crystal Data Objects (CDO) - You populate an array with your data and pass the array to Crystal in the same way you would pass a recordset.

Look at my post here for an explanation of how to use CDO:

http://www.dev-archive.com/forum/showthread.php?s=&threadid=281658&highlight=cdo

It contains the VB code you need as well as a link to Crystals website to an article that tells you how to setup the report.

Hope that helps!

crystal reports 11

hi
i got a problem in installing crystal reports 11 it request a file called keycode.dll ?
can u help me ?[ Moved thread ]

Crystal Report XI Help

Hi every one,

I am a new with crystal report and i am try to make a project under which i am to use crystal report external report file i.e. .rpt file in my project but i don't know how to use it and what is the command if we wants to use external rpt file in our project. how to open external rpt file in a project.

Can any one please help me i am in need of that urgently.U didn't mentioned on what platform u r doing project.
Lots of threads based on VB & VB.net is available regarding ur query, just go through them.|||Hi Buddy sorry for that but i work with VB 6.

And i need help for that.

I don't Find any help i had search that before posting.

Thanks and hope you can solve my problem.|||Dim conn As ADODB.Connection 'CONNECTION TO BROKER QUERIES
Dim rs As ADODB.Recordset 'HOLDS ALL DATA RETURNED FROM QUERY
Dim crystal As CRAXDRT.Application 'LOADS REPORT FROM FILE
Dim Report As CRAXDRT.Report 'HOLDS REPORT

Set conn = New ADODB.Connection
conn.Open "Provider=MSDAORA.1;User ID=scott;Data Source=qb;Persist Security Info=False", "scott", "tiger" Set rs = New ADODB.Recordset
rs.Open sql, conn, adOpenStatic, adLockReadOnly

Set crystal = New CRAXDRT.Application 'MANAGES REPORTS

Set Report = crystal.OpenReport(App.Path & "\report1.rpt") 'OPEN OUR REPORT

Report.DiscardSavedData 'CLEARS REPORT SO WE WORK FROM RECORDSET
Report.Database.SetDataSource rs 'LINK REPORT TO RECORDSET
CRViewer1.ReportSource = Report 'LINK VIEWER TO REPORT
CRViewer1.ViewReport 'SHOW REPORT

Crystal Report with XSD DataSource

Hi,
Can anyone tell me how do we use Crystal Reports with ASP with XML as DataSource. I have an XML and an XSD file which I want to use as DataSource. PLease tell me a URL where I can find any samples. Or if anyone do have any sample of using them, please let me know.Hi,

I am also using an XML-File as Data Source (in CR 10). It is included via the CR-Designer as ADO.NET (XML) Datasource, as we didn't want to create DSN-Entries on every Client-Machine. We change the Path to the XML-File during runtime:

dtsData.ReadXml(pstrReportXml);

foreach (CrystalDecisions.CrystalReports.Engine.Table tbl in cr.Database.Tables)
{
if (tbl.Name[0]=='YourCrTable')
{
tbl.SetDataSource(dtsData);
}
}

Hope this helps.

A Problem we have: CR does not seem to interpret the XSD-File. It is linked in the XML-File via

<dataroot xmlns:od="urn:schemas-microsoft-com:officedata"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="001.xsd">
------------------

Does anyone know a workaround?

Crystal Report parameter dialog box...please help!

Hi,
This is what i am doing:-

ReportDocument rdReport = new ReportDocument();

rdReport.Load("ReportLocation"); //ReportLocation is the file path.

rdReport.SetDataSource(dtsReportData); //dtsReportData is a DataSet that is populated at runtime.

crv.ReportSource = rdReport; //crv is a CrystalReportViewer on the win form.

I developed my app in VS 2003 and it was all running very smoothly. I recently migrated it to VS2005 and then I started getting this problem.
Although I dont think this is a VS 2005 issue; but something with CR
itself.

I'll try to explain my problem in detail.

I am using Crystal Reports XI; VS 2005; SQL Server 2000;

For all my reports, the reports' datasource is a Stored Procedure. And
in most cases than not, these are paramaterised SP's.

In my application, I have a listbox with a list of available reports.
The user then selects to view one report. This then loads up a
dynamically generated form with a tabpage for each of the parameters
that the Stored Procedure needs. The user then enters values for each
of the parameters. I then create a SQL statement( something like
...execute MyStoredProc value1 value2) where value1 etc are the values
the user entered for the parameters on the dynamyically generated form.
The resultant recordset is then stored into a DataSet object.

I then load the report into a ReportDocument object ie
rdReport.Load("ReportLocation"); assign the DataSet as the
ReportDocuments' Datasource ie rdReport.SetDataSource(dtsReportData);
and finally assign the ReportDocument to the CrystalReportViewer.

As i mentioned earlier, this was all working smoothly untill now...I am
getting the default CR "Enter Parameters" dialog and I havent got a
clue as to what has triggered this behaviour.

It is not possible for me to know how many parameters a stored
procedure for a report will contain and what those parameters will be
for reports designed in the future for the client.

I am pretty new to the world of reporting so excuse my
explanation...if you need any further information to understand my
problem, please let me know. I will really appreciate any help that you
can provide.

Thanks,
Mounil.You need to supply the parameters in front end application and set EnablePopup menu property to false

Crystal Report File View

Hi,
I'm using Crystal Report 8.5 version for report viewing in my application developed in VB6.
Usually in my application it will contain 10 to 15 pages in report to view, which is viewed by clicking on the next page arrow. I just want to know whether this is possible to view the pages by scrolling down the mouse.
ie, i want to view all the pages just like MS word page viewing. Is that possible?? How to do that if possible?

Thanks n Regards,

Binjose
Binjose is online now Add to Binjose's Reputation Edit/Delete MessageNo it is not possible. You have to click next page

Crystal Report Factors

hi guys!
i just want to ask my problem about my exporting file under vb code applications...
when i click the export button it doesnt work... nothing happen...
i wonder if you can give an idea how to fix this problems...
ASAP!
thank you very much!
benjzMake sure you have the correct dlls installed on the machine you want to Export from. In Crystal Reports 8.5, there's a file called runtime.hlp that tells you what files are required and whee to put them.|||do i need to install those dll in every client that are using the application? i thought its automatically deploy by setup app...

is it ok if you can give me the list of this dll's?

thankz a lot!

benjz|||Depending on what app you're using to create your setup file, you may have to specify that you want Export capabilities included.

See my post here (http://www.dev-archive.com/forum/showthread.php?t=318504) for a list of the Export dlls required (for CR 8.5).

Crystal Report and picture

Hi,
I have a question to ask.
Is it possible to load all the picture from a file to crysatl report automatically?
DOes anyone has idea on this?I tried that already but you must put all the filename in the database. If im sure, it works only crystal 11. I also save my picture inmy databse as a blogs.

I hope thismay help.

Crystal Report

I am using VB 6 with MS Access as Back End. I saved a path name of a text file in a field of Access MDB. I am using Crystal report 8 for creating reports. Will anybody help me to print the contents of the file stored in the field in the crystal report? (For eg the field contains the value "c:\project\test.txt" How to print the contents in the "detail" portion of the crystal report. When I select the field, the file name comes not the contents). Pl. help me.
Meenakshi.RMeenakshi,
I dont think there is a way to do exactly you want. But you can use heperlink option. Right Click on any field; Goto Format Field and Select HyperLink and File and Select the text file. When running the report, if you click that Field, then the text file will be opened.|||Madhi,
Each record has a different text file. With your suggestion, I have to make a permanent link to that text file. How to get different text file links? pl. guide.
Meenakshi.R|||Meenakshi,
If each record has to show different file, then you can use formula.
Do the same procedure that I told you except that instead of selecting the file, there is button labelled x-2 near text box. Click that and if the field it self represents the file name, then write this
{FieldName}|||Madhi,
I tried with your option. But when the report is run, the value stored in the field (ie) the file name comes without any hyperlink. No provision for clicking. Kindly guide me.

Meenakshi.R|||Which version of Crystal Report are you using?|||Sir,
The version of the crystal report is 8.0
Meenakshi.R|||Meenakshi,
I dont know where it goes wrong
Refer this (http://support.businessobjects.com/library/kbase/articles/c2006151.asp)|||Madhi,
Referred the article. Done as per the instructions. But still I am getting the field value only without the hyperlink. Any other solution?

Meenakshi.R|||I have a report where each record brings back a field with the path of a different image file. Each record in the details section prints out the word "Image" as a link, which I have set up as follows:

1. Created a formula which has nothing more in it than the word "Image". Placed into details section of report.
2. Click Format Field on this formula, go to Hyperlink tab. Choose 'A Website on the Internet', then open the formula box for Website Address.
3. In here, place the field from the database.

My images are available via a http server, but you may choose to use one of the other options there instead (eg 'A File' instead of 'A Website on the Internet'.|||Hai,
Created a formula. Placed in the detail section. Using format option, I have made a hyperlink by choosing the option Hyperlink from a file. With the formula button (hyperlink screen), I specified the field value. During run time, the formula name comes (but without hyperlink option). What to do?|||Should work, try debugging. I'd suggest copying the formula you are using to create the hyperlink into a regular formula and seeing what comes out, ie what it is trying to use to create this hyperlink. You might find that it has an invalid path, or is coming back blank, etc...|||Tried tried. I saved the report with field in the detail section by choosing "a file" from the hyperlink option, run the report, the field value stored in the field comes without hyperlink option. When viewing the report in design view, the hyperlink option shows 'a website on the internet'. I don't know why? pl. explain in detail.
Meenakshi.R|||My suggestion is that your file path is invalid. Test to see what CR thinks is in that field, for starters.

Ie, if you have a url stored in your database field and http:// already exists, you could end up with something like http://http://google.com

In my report, I can click on the field to open a file, provided that file path is correct. I typed C:\temp\test.txt into the File Name box. However, changing it to C:\temp\test1.txt simply does nothing as this file does not exist.

Also note that the field may be a hyperlink but will appear to be just a regular field until you mouse over. (ie, if you want it to appear as a hyperlink should then you will have to underline and colour it yourself).|||Sir,
I have created a fresh report and do all the things. When I click the preview button in Crystal report screen, I am able to click the hyperlink, and the corresponding file stored in the field gets opened. When this report is accessed via a VB program coding, simply the file name is displayed and I could not click the hyperlink. Pl. help me.

Meenakshi.R

Crystal Error

HI ,

I'm trying to print a rpt. file ( C.R. 8.5) from a VB.net program
code :

Dim Reporte As New crAlmacen
Dim x As String = Reporte.FilePath()
Dim x1 As String = Reporte.ResourceName
Reporte.SetDatabaseLogon("termi", "termi", "SERVIDOR1", "mestres")
Reporte.Refresh()
' Reporte.PrintOptions.PrinterName = "Lexmark Optra S 2455"

Reporte.PrintToPrinter(1, False, 1, 1)

An unhandled exception of type 'CrystalDecisions.CrystalReports.Engine.InvalidArgumentException' occurred in crystaldecisions.crystalreports.engine.dll

Additional information: Error in File C:\DOCUME~1\ADMINI~1\CONFIG~1\Temp\temp_50488d2a-21be-4a5a-a4df-ad83112d6274.rpt:
Invalid printer specified.

thanks a lotHI ,

I HAVE SOLVED THE PROBLEM

Dim Reporte As New crAlmacen
Dim x As String = Reporte.FilePath()
Dim x1 As String = Reporte.ResourceName
Reporte.SetDatabaseLogon("termi", "termi", "SERVIDOR1", "mestres")
Reporte.Refresh()

NEW CODE LINE
---------------------
Reporte.PrintOptions.PaperSource = CrystalDecisions.[Shared].PaperSource.Auto
---------------------
' Reporte.PrintOptions.PrinterName = "Lexmark Optra S 2455"
Reporte.PrintToPrinter(1, False, 1, 1)

AND NOW GO RIGHT

BEST REGARDS|||Glad that's sorted :D