Hi Guys! I'm trying to work with the class from JosephStyons but I do get an "Invalid Index" Error on the line where the "User ID" should get set. FRpt.Database.Tables[i].ConnectionProperties.Item['User ID'] := edUserName.Text; Here's my environment: WinXP Sp3, Crystal Reports Developer XI Rel.2 SP4, Delphi 5 Update Pack 1 Any help...
Is it possible to change the datasource type on a crystal reports file without having to rebuild the entire report? I know that I can go to Database / Set Datasource Location and change some datasource definitions like servername, login, password, but what do I have to do to change from an ODBC (RDO) datasource type to OLEDB? I already...
I have a .NET Winforms app (created in VS2005) that I deploy using ClickOnce. On one of the forms I have a Crystal Reports viewer control for the user to view the reports, but in order to use that in the app I have to include the the Crystal Reports XI Release 2 prereq which they install prior to installing the app. This basically instal...
Hi, I'm looking to implement SQL Server Reporting Services as our standard reporting platform in our company. We were trialing Crystal Reports, but atlas it seems to be plauged by issues. SQL Server reporting services looks to be a great product, but I have a concern or two. I have some existing web apps in coldfusion, and the backend...
Using Crystal Report 8.5 How to give time and Date format in Crystal Report Time - HH:MM:SS Date – 2009/08/07 Am using VB 6.0 and access database, Date and Time is Separate column, Data type for date and Time column field are memo in my database. How to write a formula for Date Format and Time Format for the Memo data types fields....
Am New to Crystal Report 8.5 How to print the string value in a date Format? Example: dd/mm/yyyy Where i have to type a formula in the crystal report? Need Date Separator Formula for String value? How to create a fromula in crystal report 8.5? ...
How to display a report by Department wise Using Crystal Report 8.5 ID Name Department 001 raja IT 002 Vijay IT 003 Ram CSE So on... Display an Each Page by Department wise. Once IT Department is completed then go to new page and display CSE Department, like that I need. How to make in crystal report? ...
Using Crystal Report 8.5 How to skip blank pages? I want to skip blank pages or blank field? Need Formula Help. ...
I'm thinking that I'm going to have to run monthly reports in Crystal Reports. I've read that you can automate this with COM/ActiveX but I'm not that advanced to understand what this is or what you can even do with it. I'm fairly familiar with Python and it looks like from what I've read, I might be able to open the report, maybe cha...
I have sub report linked with EmployeeID. But for some employees I don't have data so report get suppressed. And I get record at wrong place. I want to avoid this so what can I do ? ...
Hi! I have the following setup: Delphi 5 Enterprise Update 1 Crystal Reports Developer XI Rel2 (RDC 11.5) After long hours of trial&error I can now set the logon stuff as asked earlier but when I try to set crystalparameters by code - it does not work and I get an empty report. I've written a small app for testing (here's just a sn...
Hey all I'm new to Crystal Reports and was interested in finding out what books would be most helpful. I'm planning on using the Designer as well as integrating Crystal Reports with a .NET C# application. Anybody have any idea which are the best books for this purpose? ...
Hi, I am able to create a crystal report for a single table call from C#.\ But I have to call generic stored procedure or a single stored procedure. How can I do this? Do we can acheive this using XML files also? I mean .. the details abt which table the SP is referring to and if I want to dump the data to excel sheet, which cells the...
I am working with CrystalDecisions.CrystalReports.Engine.ReportDocument in WinForms in Visual Studio 2008. Right now when the users click the export button the dialog defaults to saving the report as a CrystalReports formatted file. It's possible to change the selector to PDF, but the specific request that I've been given -- and I've sea...
how can i use css with crystal report.there is no sheet to write the css.where can i write the css ...
I'm maintaining a multi-project solution in ASP.NET + C#. We've decided to upgrade to .NET Framework 3.5 and ASP.NET 2.0. One of the last issues with the upgrade is with Crystal Reports. I'm getting the following error: Method 'ISCREditableRTFExportFormatOptions_reserved5' on type 'CrystalDecisions.ReportAppServer.ReportDefModel.Editab...
I have created a crystal report called 'Order Details'. I used visual studio 2005 (crystal ver 10). The order details report uses a stored procedure to populate itself. It contains a subreport called 'ChildAssets' which calls a seperate stored procedure, the sub report needs a parameter. The parameter it needs is actually a field from ...
When printing a report, the user sometime have the following error: CrystalDecisions.CrystalReports.Engine.LogOnException: Error in File C:\DOCUME~1\carolec\LOCALS~1\Temp\temp_b117cc2e-c184-4556-a493-e04e6d4126fb {388C2B55-114E-4087-A22D-9289902AFDEB}.rpt: Unable to connect: incorrect log on parameters. ---> System.Runtime.InteropSe...
Hi all, I'm trying to export the reportsource of a crystal report viewer in .Net 1.1 onto disk as a PDF using CrystalDecisions.CrystalReports.Engine.ReportDocument cr = (CrystalDecisions.CrystalReports.Engine.ReportDocument)crvView.ReportSource; cr.ExportToDisk(CrystalDecisions.[Shared].ExportFormatType.PortableDocFormat, @"C:\Temp\Tem...
I'm trying to deploy an aap using Crystal reports, asp.net 3.5 developing in Vs2008. On my dev boxes, I have CrystalDecisions.Shared 11.5.3300 and 11.5.3700. the only reference I can add in is to verison 11.5.3300, but the only version deployed on my QA server is 11.5.3700. I keep getting the following error: System.IO.FileNotFoundEx...