Recent content by granny1

I have inherited a large access database. This database has had very little maintance over the years. Basically no cleanup has been done just more additions. There are tables, query's etc that are no longer being utilized by the database. Does anyone have an easy way to identify the resources...

I have a company report that I need to show in 20 regional folders. Is there any way that I can schedule this report to run one time and have the results show in the 20 seperate folders or do I have to run the report for each folder?

I have the can grow selected. To be more specific the data is a memo field in a sysbase table. I am trying to display the entire text of the memo field.

I have recently had Crystal 9 Installed. I am having a problem with the text field not displaying all the information needed. I thought that version 9 corrected this problem. Any ideas ? What am I missing ?

I have a report that is doing a total on customer count by district, division. Within a district I have 2 locations with the exact same customer count. Crystal is including the first location but dropping the second with the same customer count. This is creating a big problem in my totals. Any...

I have a report that allows users to select a parameter from a drop down list. If there is no data for the specified time frame I need a meesage to appear that displays a message something like "No Data available for the selected Department this reporting period". I do not want any of...

I am using 8.5

I have a number of reports that I need to save as Crystal Reports and I also need to export a copy to PDF format when the reports are run. Any idea on an easy way to do this ?

I have several reports that I need to run based on start date and end date. I want to schedule these reports on Crystal Management Console. I need a way to provide dates in one central place and pass to all reports requiring this date field. Any Ideas ?

You Are correct 254 chars is being shown. I am connecting to a Remedy database using an ODBC driver. How do I use A view to correct the problem.

Thanks for the response. The can grow tab is checked but the text is still not all printing any more ideas ?

I have a memo field that I need to use in Crystal but it is only showing part of the data. How Can I show the entire field ?

if return value is 2 and you have < 3 it works but if you have < 1 and it doesn't return a value it doesn't display. I tried isnull and that did not work.

I need to display an alert if this period total=0. I have the following formula if Sum ({@ThisPeriodIncidents})=0 then&quot;Complaint&quot; (Complaint being the Alert) it does not display when sum is 0. Any ideas.

I need help with a formula that will display cust count when no complaints are noted. My formula is ({LIT_Incident_Tracking.Create-date}>= {?ReportStartDate} and {LIT_Incident_Tracking.Create-date}<= {?CurrentEndDate} and{LIT_Incident_Tracking.Incident_Type}=&quot;Complaint&quot;) If...