Search results for query: *

Just discovered that this feature is not included in the standard edition of the product, which is what I am using.

The repository explorer option is also greyed out on the view menu?

I have some reports using SQL Server, some using .dbf files, some using Access. All connect through ODBC.

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?

Related Question: Is there a way to set Crystal to change the value of special characters in a text field to the &value. For example, all " to &quot? This would solve most of the issues with the XML request above. Thanks. Pete

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...

Bingo. I changed this and the problem was resolved. Now I'll go read and fully understand this option. Thank you so much, this information is HUGE! Pete

This still returned all of the records except the one with no order. The new SQL is: SELECT "HR"."LAST_NAME", "HR"."PAT_TYPE", "HR"."PAT_STAT", "HR"."FIRST_NAME", "OT"."RANK", "OT"."DESCRIP", "OT"."RXTYPE", "OT"."STATUS", "HR"."DELFLAG", "OT"."DELFLAG", "OT"."MRN" FROM "CPR_SQL"."dbo"."HR"...

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 -...

Problem was the report criteria was based on a date and the fields are date-time fields in SQL Server. I was using date(field) >= fromdate and date(field) <= thrudate. The function was not resolved to an SQL where clause and so all the records were returned. I changed to date >= fromdate and...

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've been using Crystal Reports since version 7.0 and have built a successful business on it. With the recent events cited above, Microsoft Reporting Services here we go!!

In fact, that is exactly the problem I've found out. I want to include the object in the page header. Can I use a subreport for this? Thanks.

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've already tried that and it didn't resolve the problem. I've left it set at 2000 compatible just in case. Thanks

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...