crystal

Is there no ActiveX support for Crystal 2008 anymore?

We currently use Delphi 2005, and import Crystal 10 ActiveX controls as a Type Library to generate crystal reports. From what I've gathered, Crystal 2008 no longer supports ActiveX, so even if we upgrade to Delphi 2009/2010, it still won't be able to generate Crystal 2008 reports, is this correct? That is, there's no way for a Win32 ap...

SQL Expressions in Crystal Reports

I am not at all familiar with SQL expressions and was hoping to get some help I have this: "Reservations"."NY IT Services/Computer Presentation" which is a boolean How would i write this to say "If "Reservations"."NY IT Services/Computer Presentation" is a 1, then display, else do not display? I need to do this in Crystal Reports and ...

How to Assign 2 different PARAMETER in crystal report?

select (distributor_code+ '-' +master_dealer_code+ '-' +state_code+ '-' +dealer_code) as agent_code, agent_type, company,contact_person, status, created_date as date, (CASE WHEN contact_mobile_no IS NOT NULL THEN contact_mobile_no WHEN contact_mobile_no IS NULL and contact_office_no IS NOT NULL THEN contact_office_no ELSE NULL END) ...

ASP.NET Crystal Reports Export PDF to IE6 issue

Thank you for taking the time to read my post. All works fine in FireFox 3.5. I'm having a problem with my ASP.NET 3.5 web application. When I use the ReportDocument.ExportToHTTPResponse IE6 shows the following: %PDF-1.7 %âãÏÓ 1 0 obj << /Type /Catalog /Pages 2 0 R /PageMode /UseNone /ViewerPreferences << /FitWindow true ...

How can I insert page breaks between groups in Crystal Reports with two-sided printing?

In group expert options I have set Keep Group Together, which makes sure a new page is set. With two-sided printing enabled, how can I make sure that a new group always forms on a new sheet of paper? Can this be done in the formula expert? Is there some way of checking if the page I'm on is even or odd and insert a page from there? Just...

Is there a way to export Crystal reports formulas to a readable document?

I have a very complicated Crystal Reports XI rpt file with 30+ group header sections, each with its own suppress (No Drill-Down) formula. I would like to document this report in a separate ASCII txt file so I can get an overview of the report. Is there any tool or any way I can export Crystal Reports XI formulas without going through ...

Display array values in Crystal Report

Hi, I am generating and display crystal report from my asp.net application. In the code, i have a array of numbers that I want to be able to display in the report. so if in my code I have int[] {1,4,5,6,8,10 } I want to somehow pass this array to crystal report so that we have 6 rows in the details section of the report where each row is...

add extra column value to a column sum

Hi all, I have the following issue: I have a report that uses a Dataset as its datasource. The dataset has two tables, one would be the main table, say Employee, and the second table is EmployeePaycheck, so an employee can have several paychecks. I can compute the sum of a column in the second table, say paycheckValue, but what I can't s...

Why do My Reports load very slow in the first call ?

Hi every body I have converted one of my old solutions from .Net 1.1 to 2 via Visual Studio 2008. It's reports were conveted too and I embeded them in my solution. although they work properly,but their first load take such a long time. What can I do for this problem? ...

Crystal Server XI R2 Clean Up

How do I find statitics on how often certain reports are run from our Crystal XI R2 Server? How can I determine which reports are not being used? A Google search was fruitless. ...

SORT in CRYSTAL REPORT

hi there i have written a program in C# . i have a problem in crystal report . i wanna sort data in a report by clicking on a link in header . is it possible in crystal report? please help thanks... ...

Make a Crystal Report with data fetched from two differents tables

Hi, Im using vb.net and I need to fetch data from two different tables and display it in form of report. These are the schemas and data of my two tables: CREATE TABLE personal_details (staff_ID integer PRIMARY KEY, title varchar(10), fn varchar(250), ln varchar(250), mn varchar(250), dob varchar(50), hometown varchar(250), securityno...

Crystal Reports: "Failed to Save Document" after changing Datasource

I have about 15 .RPT files on my .NET 2.0 site, and I recently changed to a new database server. I successfully changed the Datasource on 14 of those .RPT files, but on one, after making the change, I get "Failed to Save Document" when I try to save the updated report. I can change the subreport's Datasource, and save it just fine, but...

Crystal Reports 2008

I am going to upgrade Visual Studio 2008 Professional to Visual Studio 2010 Preimum. I also have Crystal Reports 2008 installed. Will Crystal Reports cause any problems? And will Visual Studio 2010 Preimum recognize my Crystal Reports install alllowing usage of Crystall Reports 2008 in my applications? ...

Why Crystal php lib turns my non english latters into "?" signs? Is there a way around it?

Why Crystal php lib turns my non english latters into "?" signs? Is there a way around it? So it happens if I try to walidate something or just post into DB. =( I know - I can not to use Crystal at all but I want to! What can I do to solve such problem? ...

Crystal Reports -- displaying one decimal in my formula field

Hello I have the following in my formula field: toText(((Sum ({DataTable1.Ending_Value}, {DataTable1.Name})) - (Sum ({DataTable1.Starting_Value}, {DataTable1.Name})) - (Sum ({DataTable1.Investments}, {DataTable1.Name})) + (Sum ({DataTable1.Proceeds}, {DataTable1.Name})) + (Sum ({DataTable1.Interest_and_Dividends}, {DataTable1.Name})))/...

How to bind set of reports to report viwer ?

Hi all , I want to print a set of invoice for my application. So I need to display all invoices in report viewer before they print. are there any methods to bind multiple reports to same report viewer using crystal reports or rdlc. I try rdlc but I couldn't find any way to do that. please any one can provide code sample or instruction...

Crystal Reports format diagramm series axis

I'm using Crystal Reports Basic from Visual Studio. Now I want to create a 3D-Block Diagram but the series axis has the text from my columns of the dataset. Here is how my chart preview looks like and here is how it is configured in the diagram assistant All the texts on the series axis should be formatted like Monday, Tuesday, et...

external cr .rpt

Hi, Can someone tell me if it's possible to load external CrystalReports (2008) .rpt files? I now embed them so they're compiled with my core. It would be nice if i can make changes to a reports layout without having to recompile anything. Is that possible? Thanks. ...

Total Average Week using a Parameter

I have a crystal report that shows sales volumes called week to date volume. It shows current week, previous week, and average week. The report prompts for a date parameter and I extract the week number to get current week and previous week volumes. Did it this way because Mngmt wants to be able to run report whenever. My problem is for ...