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 "? 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!!
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.