Recent content by Pete56

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.