crystal-reports

Why my computer opens Crytal Reports 8.5 file within about 20 seconds?

Hi I have installed Crystal Reports 8.5 on my computer recently. But When I open an existing file (.rpt), it takes about 20 seconds! The system O/s is : Win XP SP2. any help is appreciated... ...

crystal report grouping two tables based on primary key of one table

i have 2 tables 1.product fields are prod_no(primary key),prod_name 2.sales fields are sal_no,sal_date,cust,prod1(foreign key ie prod_no),prod2(foreign key ie prod_no),fst_qty,snd_qty i want to sort my report based on prod_no ex: product prod_no prod_name 1 printer 2 paper 3 catridge sales sal_no sa...

View data in report in Address form.

I've started a directory project in C#.NET where I'm editing an xml file and using a dataset. There are 5 fields in the xml file to make up an Address. I want to display the address, like on an envelope, in a report and put 10 addresses on a page. I've been using Crystal Reports. If Crystal Reports is not the way to go with this, what re...

How to fix: Fonts corrupt when I export a crystal report 8.5 to PDF?

hi all I have created a sample report using Crystal report 8.5 and vb6.0 Every thing goes normal till I try to export the report to Pdf format by its export icon. As soon as I do that, the report texts are damaged and nothing could be readable. How to fix it? Thank you ...

Crystal reports - PUSH blob data, image doesn't display

I've a crystal report that I'm trying to get a dynamic image displayed. This is the CRBasic 2008 version that comes with VS 2008, so i can't use the method where we link out to the file, it has to come from the data source. I'm pushing a strongly typed dataset to the report, which contains a byte[] field. This dataset is being populat...

Is there a way to load a Crystal Report 9.0 file from a stream?

Hi. I am working with Delphi and Crystal Reports 9.0 ActiveX objects. I know that I can load a report from a file like this: crApplication.OpenReport(AFileName) However, I would like to store my report in memory and open it from memory instead of file. I don't want to create any temporary files on my disk. Any ideas? Thanks for you...

Crystal Reports in Visual Studio - Can margins be dynamically changed?

I have a report where the first page has a certain top and bottom margin. Every page after that will have a different margin from the first. Is there a way to do this in Crystal Reports in Visual Studio 2008? ...

DataGridView checkbox column - value and functionality

Here is a reference the old SO question. http://stackoverflow.com/questions/1237829/datagridview-checkbox-column-value-and-functionality/1395215#1395215 I need to know, how would I get the information from a specific cell, so that i may further make the crystal report of the checked rows of datagridview. Thanks. -nav ...

How do I add a field in to a report (Crystal Reports in Visual Studio)

I have an existing report (Crystal Report) in my Visual Studio project that is based off of an SQL Server View. using an OLE DB (ADO) connection. I've updated the View since the report was created. I've changed some field names and added a field. How can I updated the fields on the report to point at the new fields in the view? How can...

Crystal Reports XI - convert csv input string parameter to number array for use in record selection formula

I have a report which I'm working on which has an input parameter (strSchoolIds) that is a string of comma separated list of unique schoolIds. I'd like to convert this string into a number array which can then be used in the record selection formula. Here is what I've come up with so far. But whenever I view the report just the first sch...

Override the Refresh Crystal Report that brings up their criteria page

I have a vb.net winforms application. I have created a criteria form that populates parameters in a Crystal Report. These parameters are pretty simple, IE customerId, StartDate, EndDate, etc... This works fine, but if the user presses the crystal reports "Refresh" button on the CrystalReportViewer control then the CrystalReports criter...

Logon failed, Crystal Reports 9, VB6 , sql server, sqlncli

Hello there, i'm trying to build a setup package for a legacy vb6 software. the software itself connects to a sql server via sqlncli (native client). i've packaged all the dependencies and deploy them to a new machine running winxp and office2003. now, from the target machine i can connect to the database (ms sqlserver 2005) that is ru...

Crystal Reports Multiple Pages

I have a very simple Crystal report document which pulls data from a db and one of these fields may in some cases be larger than the space available in the page..in these cases the print out cuts out the information that doesn't fit. Is there a way to make the text to into a new page when it doesn't fit? ...

CrystalReportSource binding

Hello I have a crystalReportViewer and CrystalReportSource on a web form. I need to be able to bind the reportSource at run time to different report files. I have the file data stored in a blob in a DB. The mechanism I am using now is to save the blob to a file and then this.CrystalReportSource1.Report.FileName = myFileName; The is...

Strange Crystal Report formatting problem

I am using Crystal Reports v10.0.x on Windows Server 2003 SP2. I have an .rpt file that gets exported into a PDF format using the Crystal Reports Engine thingy. new CrystalDecisions.CrystalReports.Engine.ReportDocument().ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, fullExportFileName); I have this report on...

How to use CrystalReportViewer Control in MFC application?

How can I view crystal report (use CrystalReportViewer control) in Visual C++ .NET MFC-application? I know I can use it in managed C++ application, but I already have a MFC project. ...

Dynamically change the connection of a Crystal Report

Hello, I am using CrystalReportViewer and CrystalReportSource to load and display an .rpt file in my application. The situation I have is this: Say a person created a crystal report outside of my application and set its datasource to database A. then I use that .rpt file in my application but I need to bind it to a different db(ident...

Crystal reports group properties

Ok this is a really specific question, but I can't seem to find the setting i need. I'm doing crystal reports inside of vs.net 2005, and i need a page header, and report header, but i need the page header to come BEFORE the report header. Is this possible? Basically i have two areas that I want at the top of the first page, A, followed...

Visual Studio Crystal Report More Data Sources Selection not available

Why is it that there is no available selection when i select More Data Sources to connect my crystal report. I am trying to create a report using crystal in visual studio and assigning its data source with a Field Definition file (.ttx file). When I select More Data Sources, there's no available list in there. How could i create a ttx fi...

Cross Tab Report - How to Control Row Order?

I'm using a Cross Tab Report with rows with names like 'Q1', 'Q2', 'Q7', 'Q10' etc. However, they're in alphabetical order such as: Q1 Q10 Q2 Q7 However, I want: Q1 Q2 Q7 Q10 Is there any way to specify the order of rows? ...