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...
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 ...
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) ...
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 ...
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...
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 ...
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...
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...
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? ...
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. ...
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... ...
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...
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...
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? 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? ...
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})))/...
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...
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...
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. ...
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 ...