Does anyone have any ideas how to shift up the remaining fields after suppressing? I am suppressing a numeric field in the footer of a report and would like to shift up the remaining fields below it so it doesn't look 'blank'. Any and all help appreciated! JFV ...
How do I insert a page break in Crystal Reports. Using VB.Net, not in the report definition? ...
Hi guys. How to get average of a column in terms of another column and put this value in a third column, and this value will be evaluated for each retrieved record? "How to perform an opertaion on two columns in a report and insert the result in a third column?" FYI: I'm using CrystalReport Designer embedded with VisualStudio.NET 2005...
If a business needed to connect to a various database and generate PDF mostly reports, what are some good tools. Commercial or Opensource. Non technical users should also be able to generate various reports with good looking charts and tabular data through a report designer tool. As well, we should be able to deploy these charts on ...
Is there a way or a DLL using which we an extract an embedded query from crystal reports. I was able to do the same using CRAXDRT in windows based application, but when i try to do the same thing in ASP.net, entire application hangs. ...
I'm trying to export a crystal report to pdf and then email it, but every time I get to the export command, I get a ParameterFieldCurrentValue exception. I've traced the values of the Parameter collection in the ReportDocument and the values are being set there. Also, all four parameters are strings. The first one is set to allow more t...
I use Crystal Reports XI with C# Visual Studio 2005. I am trying to create a subreport from a summary dataset. A simple example would be Company listing with Employees. I load the Company dataset (with CompanyId). I want to create a subreport which is linked by CompanyId whereby the dataset is loaded (obviously) on demand. I can create ...
There are hints of the answer to this question here and there on this site, but I'm asking a slightly different answer. Where does Crystal Reports document that this syntax does not work? Trim({PatientProfile.First}) + " " + Trim(Iif( IsNull({PatientProfile.Middle}) , Trim({PatientProfile.Middle}) + " " , "...
Anyone know if there is a way to merge several fields (they have the same possible values) in Crystal so they can be used together in a chart? For example: Field1, Field2 and Field3 all have values of only a 1 or 2. I want to merge all the values from these 3 fields together to show a total of how many 1s there are vs 2s combined. Any ...
Please could you provide some guidance for me? I am currently evaluating Crystal Reports 2008 for use within a major enterprise project. I have successfully used Crystal Reports Basic within Visual Studio, but we want a bit more functionality this time. Reports will be produced based on ADO.NET Xml datasets and will be saved to a SQL S...
I have a static list of user names as a parameter in CR2008. I want to be able to use CR syntax to add database values to the users selected and query using that. For instance, if the report runner selects Doe, John from my list of parameters, I need to query the database using something like If {?prmUsers} = "Doe, John" then variable...
I'm trying to send faxes with a .NET (C#) program using Crystal Reports and Unimessage Pro (or any other fax program). My problem is that Unimessage Pro (and other fax programs) uses printer fonts for the fax commands. Since .NET doesn't support printer fonts the fax commands in the report are converted to Courier New. The result of thi...
Hi all. I'd like to call a Stored Procedure from a crystal report and assign retrieved value to a field in report? Any suggestions? ...
Hi all. Is there a way to load an image dynamically to a report based on image path. The image file name is stored in database. FYI. I'm using CrystalReport designer embedded with VS.NET 2005. ...
How to remove or hide the main tab section in Crystal Report Viewer (C#). ...
I upgraded my ASP.Net app from .net 1.1 to .net 2.0. All of the webpages work fine but the crystal reports won't load. Stack trace: Load report failed. StackTrace: at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename...
Using Crystal Reports 10.2 (built in to VS2005), I could use this code: const CLSID CLSID_Application = {0x2b78e518,0xe7d0,0x49bf,{0x8f,0x16,0xcf,0xd6,0x32,0x4d,0xb3,0x07}}; const CLSID CLSID_ReportObjects = {0x2b78e4f5,0xe7d0,0x49bf,{0x8f,0x16,0xcf,0xd6,0x32,0x4d,0xb3,0x07}}; const IID IID_IApplication = {0xaf376830,0x6120,0x4e28,{0x96...
I am trying to convert a VB6 Data Report (.dsr file) to a Crystal Report through the migration process within Visual Studio. I have read articles that reference adding a Data Report to a Project from Visual Studio 2005/2008 and that it will convert the Data Report to a Crystal Report, but I have not been successful in doing so. Does the ...
I am using CR 9. Sorry about that. I have never used Crystal Reports; however, my boss has asked me to provide him the "logic" used in a report generated for one of our customers. The report was created several years ago and the customer contact is new. He wants to know what information we use to calculate the data reported in each c...
I'm having difficulty getting crystal report to load data from a MySQL DB. I am using the Connector/NET and have a DataSet in the project which can access the data just fine. I am able to set the report data source to a DataTable from the DataSet. Crystal reports seems to know all about the column information, as I can create fields etc....