I am running crystal reports 11 and in the main report is a subreport which calculates the balance. In the subreport balance, I have the formula named balancetotal which manually sums the running total of the tarinvoice.balance field. WhileReadingRecords; global numbervar balancetotal; balancetotal := balancetotal + {tarInvoice.Balan...
We are updating a Crystal Report to connect to SQL server (the database was moved from Oracle), and we are trying to make it connect to SQL server using an active directory account. I was able to get this working on my local machine using my own account, but when I deploy it to the Crystal Enterprise server, the connection fails. It appe...
I have a report made with Crystal Reports 2008 that I need to deploy a production system which means that I need to be able to change the database connection at runtime. The database is PostgreSQL 8.3.0 and the connection I use for creating the initial report is an ODBC connection. I have found various ways to change the database conne...
how to create oracle reports in indian languages? ...
Hi I have designed a crystal report which has only two sub reports to be displayed and no fields on the main report. I have created those two subreports and placed them on the main report's Report Header Section A and Section B respectively. But the problem is when I execute the report, data is getting displayed properly from Second p...
Hi all. I'm trying to retrieve a BLOB field from Oracle and show it in a crystal report. While viewing the report, I've that error: Failed to open a rowset. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for oracle Description: Unspecified error I use a View as report datasource, its script SELECT COMPANY_ID, COMPANY_...
I have an application developed in vb using .net framework. We are using Crystal Reports XI runtime to run reports from this application. When I view the reports in Crystal, they are properly centered on the page, however, when we view the report on screen it all looks correct, however, when we send it to the printer, the report is hig...
Hi, I have a webapplication in asp.net 2.0 on that application i am using crystal report to display image from oracle database. on that report i am using dataset xsd with storedprocedure to display data in crystal report. But the problem is when i am using stored procedure the image is not display in the report in case if i am us...
I have a system that builds up reports on incedents. This allows the users to fill in multiple web forms and upload PDF documents, jpeg images and tiff images. I have a cystal report that prints of all the form data related to the incedent but cannot find a quick method of printing off all the data and the pdf documents with one click....
I am finalizing an application that will soon be submitted for Windows Logo Program validation. One of the requirements is x64 compatibility. Specifically, Crystal Reports 2008 must work under x64. My problem is that Crystal Reports basic 2008 (the one packaged with Visual Studio 2008) has no merge modules and must be installed using ...
Report design, generation and maintenance isn't hard, but it is dull. We have a number of legacy (to quite different degrees of legacy) reports in Crystal Reports XI. These are designed for A4/PDF - not necessarily printed, but to be of a predictable layout and there's no possibility of us retiring them any time soon. All connect to ex...
Hi there, I really want to know your experience at working with ADO.Net datasets (calling StoreProcedures from SQL) and Crystal Reports, I know about the 2-4 seconds to CrystalDecisions.CrystalReports.Engine.ReportDocument document = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); document.Load(file); but what about the ...
hi I have datetime var that I show him in Crystal report I whant to see in short format (dd/mm/yyyy) - but I see him in Long (dd/mm/yyy hh:mm:ss) what can i do ? ...
I would like to extract the SQL queries from Crystal Report .rpt files, is there a way to do this? I don't have any of the Crystal Reports products, just the .rpt files. ...
Hi all, I was using Microsoft Office Web Components in my .NET desktop application to show tabular data and reports. But Microsoft has stopped shipping Web Components with later versions of Microsoft Office and also I want to remove this dependency from my application. Is there any other good and efficient method to show reports and ta...
I have a legacy app that can display crystal reports to the user, using the crystal component current at the time it was developed. Sadly, the version at that time was 8.5. If I try to open an XI report in the old app, then I get an exception about not being able to open the report. I'd like to show a Crystal XI report in that applica...
I have a report which displays rows of data from a stored procedure. On the top of the report I would like to display information about which parameters were used to produce the report. My issue is that several of the parameters are IDs for a foreign key relationship, but on the report I want to display a description instead of the ID. T...
This is in C#, Visual Studio 2008, crystal reports that came with VS2008 I've got a crystal report viewer form that resides in a DLL. The DLL is responsible for loading the crystal report (based on report filename), and displaying the report on the form. When I'm done with the crystal report, i call dispose on the loaded reportdocum...
I don't have much experience managing reports, but I work on an application that works like this: There is an interface for the users to select a report they want to view from a list of reports. This list is populated by a reports table in the database which holds info like the report name, the file name, and which parameters the report...
I have some Crystal Reports (V10) in an application (.NET 1.1) I inherited that is deployed in four "identical" environments. In three of the environments, they are working fine. In the fourth, the chart graphics are not visible in the web viewer. They are visible if you export the reports. The IT guys swear everything is exactly the sa...