Search results for query: *

Crystal XI I am setting up a parameter and the Static radio button is checked and I can see Dynamic but it is greyed out and I am unable to check it. How is this option enabled?

Crystal 10 Various datasources Task: Create a report that is an XML file Function sample: 'pat_fname="'+trim(replace({icacs.cs_fnam},"&","and"))+'"' This will put the cs_fnam field in the file preceded with the tag name and surrounded by quotees with the & characters changed to and...

Tools: Crystal 10 | ODBC data access to DBF files 2 files: Patient file and insurance file linked by pat # 1 record per patient 1+ records per patient with rank field identifying order Problem: I want to link on patient number and only include the primary insurance number. I...

CR 10; SQL Server 2000 Tables - HR = Patiets; OT = Orders Output desired - list of patients with primary order (rank=1) or patients with no orders Database setup - HR left outer join OT Record selection criteria - {hr.pat_stat} = 'Active' and {hr.pat_type} = 'Supplies Only' and...

Product: Crystal 10, ODBC access to foxpro files Problem: Total therapy days by delivery ticket and patient Files: 1. Ticket detail with ticket #, from and through date in each line item on the ticket. 2. Patient master linked to ticket file by patient number. Desired output: Group # 1 -...

This is really an OCBC performance issue question but I got there through Crystal. I am using Crystal reports 10.0 / SQL Server 2000 and an ODBC Connection with the SQL Server Driver. I am having a real performance problem. So I look at the SQL that it is sending to SQL Server and it is the...

I am using Crystal 10 against a SQL Server or DBF file using ODBC drivers. When I write reports I want to be able to put an image on the top and the image varies. I decided to store the image in an Access DB and access it via an ODBC driver as well. The end result might be 2-3 files that are...

When I am running a report, if my date range selection includes a lot of records (50,000), I get an Invalid Seek Address. This happens with SQL Databases as well as .dbf files. I use an ODBC driver to access them both; the sql driver and the Microsoft Visual Foxpro driver. With the .dbf file...

I am converting reports from 8.5 to 10.0. The data sources are xbase files. In 8.5 I reference them directly using the find file. In the 10.0 reports I want to change them to ODBC connections. How can I change them in the new 10.0 report without redoing the report? Thanks in advance for...

I have started getting runtime errors with both Crystal 8.5 and 10.0. The only thing that has changed (significantly) is the Windows XP service pack 2 install. I've uninstalled and reinstalled both programs and still get the problem. Any suggestions? The error is Runtime Error...

I have the following function: Global Numbervar nRecords; nRecords := nRecords + 1 When I display it in the detail line it always displays 1. Why doesn't it increment?

I'm trying to read foxpro databases with an ODBC DSN - .dbf/.cdx files with a free table dsn. When I set up the DSN I see all the files. When I am in Crystal I select the files by selecting the DSN and there are no tables displayed. The same thing happens when I try to link from access 2002...

We have been writing crystal reports against .dbf files for a couple of years - files that are open by a DOS based system written in Clipper. One of the files got some corruption in it that looks like it came from a network or hard drive error. The vendor is saying that Crystal Reports...

I have a CR 8.5 report that fails only on my XP machine. When you move fields out beyond a certain point (appears to be the standard portrait margin), the data does not appear on the report. If you drag the field back within this margin you can see it. Same goes for footers. Its like an...

I need a report that prints a Days Sales Outstanding (DSO) value. This is based on the daily net revenue for a period divided into the total A/R. I need this by billing clerk. The daily revenue comes from one file (Revenue file) and I need to total it by clerk to use when processing the...

I use CR 8.5 and export to PDF just fine. When I compile and put the reports on a customers machine the export to PDF does not work in the viewer. Thanks in advance. Pete Tanguay, www.rock-pond.com www.net-homehealth.com pete@rock-pond.com

I am using a compiled report with Crystal 8.5. I have a date parameter in the report select. When I run this in crystal the parameter is mmddyyyy. When I run this in the compiled version it is ddmmyyyy. Does anyone know how to change this? It looks like there is an international date format...