Search results for query: *

I have a report that already contains 5 subreports. I want to insert another subreport. When I inserted this report, nothing shows up on the report. If I take the last subreport out the report works fine. So I traced it back to using a report selection in that subreport of monthtodate. That...

I am using 8.5 with an access database. This is a report for a count using a date field. We are just counting how may date records are there. Pretty simple. The following is the report I have: 2003 MONTH YTD January 15 15 February 12 27 March 11 38 April...

I am creating a report of the count of authorization dates for the last two years by month and a running total for the year. I am using 8.5 and an access database. My report so far looks like the following: gh1 2003 gh2 Month YTD...

I am using 8.5 with an access database. We have a record for each transferee we do business with. In that record there is a field with a date in. I need to create a report that will count those dates . I need a total date for the current month and then a YTD total each month. The report...

I am trying to create a new formula to use in my cross tab, however when I create the formula it does not show up in my corss tab available fields. I can go into Formula Editor and it is there, but it is not in the available fields in the cross tab. Any help on this would be great. I am using...

I am working with 8.5 and an access database. I am fairly new at Crystal, but getting better. I need to write a report with a column of just the names of the months. the data will be counts of a date field for 3 years. Each year will be a column. needs to look like this...

I am having to take a report from 9.0 and create it in 8.5. I am using an access database. I had this formula working in 9.0: If Not IsNull({Brokerage_Offer.ReducedAmount})and ({Brokerage_Offer.ReducedAmount}) > 0 then {Brokerage_Offer.ReducedAmount} else {Brokerage.ListPrice} I am...

I have created a report in 9.0. Works fine. I have to convert this report to 8.5. I am recreating it in 8.5. we are using an access database. I have grouped a formula field @DOM by specific amounts using a specified order. Works O.K. Now I need to group the same formula field by descending...

I have to take a report written in 9.0 and convert it to 8.5. Is there and easier way to do this, than recreating the whole report in 8.5. I am using an access database. Thank You.

I have a question. For some reason I cannot get my else statement to work in and if then else statement. I have a multiple statement. When that wouldn't work I have broken it down to one if then else below and the else still will not work. Are there some querks I should know about. If...

I am somewhat new to Crystal. I need to format a Zip Code field xxxxx-xxxx and a phone number xxx-xxx-xxxx. What is my best way to do that. I have looked at the format dialog box and can't seem to find a simple way of doing that. I am in Crystal 8.5 or 9.0. I use both. I am running with an...

I am using Crystal Reports 9.0 and an access database. I need to do a spreadsheet type report using only one data field. The report needs to look like this. 2002 2003 2004 Month YTD Month YTD Month YTD Jan 11...

I am working with 9.0 with an access database. I have created this formula, If Not IsNull({Brokerage_Offer.ReducedAmount}) and ({Brokerage_Offer.ReducedAmount} > 0) then {Brokerage_Offer.ExpireDate} else If DateValue({Brokerage.ExtendDate2}) <> CurrentDate then {Brokerage.ExtendDate2} else...

I am working in 9.0. with an access database. I have this formula that I am using. If Not IsNull({Brokerage_Offer.ReducedAmount}) and {Brokerage_Offer.ReducedAmount} > 0 then {Brokerage_Offer.ExpireDate} else If {Brokerage.ExtendDate2} > CurrentDateTime or {Brokerage.ExtendDate2} <...

I am working in 9.0. with an access database. I have this formula that I am using. If Not IsNull({Brokerage_Offer.ReducedAmount}) and {Brokerage_Offer.ReducedAmount} > 0 then {Brokerage_Offer.ExpireDate} else If {Brokerage.ExtendDate2} > CurrentDateTime or {Brokerage.ExtendDate2} <...

I am not real familiar with creating cross tab report. Below is a what I want to write: 2000 2001 2002 2003 2004 Jan 12 19 11 15 12 Feb 26 25 25 27 17 MAr 43 41 34 38 23 Apr 52 69 44...

My problem is this. I have created a report using Crystal 9.0. It is a listing of Brokers from an Access Database. I have an extensive record selection critera. Now I have a request to do a mail merge for this listing. They want to send out a form letter. I have the form letter in Word...

Here is my problem. I have a database in access. I have done a report for a broker listing using Crystal Reports and accessing that database. I have an extensive list of selection criteria using the record selection in Crystal. The report worked fine. Now i have a request for a mailing...

I have a formula for a date field. I am choosing between various date fields. If there is no table record, I would like to put in "N/A", however I have the formula in my design formatted as a date. Any suggestions on how I can do this. Thanks for any suggestions.

I am trying to write and If then statement. If the Reduced amount field is 0 or no record then I want the list price to print otherwise if there is a record and and amount I want the reduced amount to print. I cannot get the list price to print. It shows up blank. the Reduced amount prints...