Search results for query: *

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

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 ?

I need to display an alert if this period total=0. I have the following formula if Sum ({@ThisPeriodIncidents})=0 then"Complaint" (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...

I have what should be a simple (total) but it doesn't work. I am trying to add a column of 5 for a total. I am using two databases in this report. Remedy, and Access. The count is being pulled from access. When I try to total the 5 specific records shown in my report. I am getting a total of the...

Need help to cculate formula assigning values to data. 0-1.5=dissatisfied. 1.5.1 to 2.5(Not up to expectations.) 2.5.1to 3.5 Fair and arrive at an average

I need help in creating a formula for Company avg. per Location

I need help with a formula for all events that have occured within the past 24 hours. If I use Current Date -1 I get duplicate data.

I have setup a calender within Remedy to populate on-call support for Business hours 8 a.m. to 5.p.m. MON-FRI. After 5:00 the calender switches to the off hours support. The calender includes weekends and holidays these should be populating with off-hours support but it is not working. Any ideas?