Solved

Crystal Report (vs 3.0.1.32) problem

Posted on 1998-10-29
3
292 Views
Last Modified: 2008-03-04
Using Crystal Report version 3.0.1 can one write a formula on a memo field. I need this for my application.
Also my fields which are displayed in the details section keeps replicating into thousand's  of records . I ran the same report in CR ver 3.0.1 32-bit and higher and it was working fine. Please help
0
Comment
Question by:PSV
  • 2
3 Comments
 

Author Comment

by:PSV
ID: 1442506
Edited text of question
0
 

Author Comment

by:PSV
ID: 1442507
Edited text of question
0
 

Accepted Solution

by:
eyaltil earned 100 total points
ID: 1442508
ok,
here is the soloution:
1. about the memo field. crystal reports cann't use a memo field for a formula try creating a view/query woth the to_char statment so the crystal reports user this memo field as a string field.

2. about the replication.maby u attached a table with a forien key to the main table and crystal reports is reading from the second table instead of the first one.
try to created a view\query of the fileds u need for the crystal reports and put a distinct in the select cluase.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question