Search results for query: *

Good afternoon, I have a bubble chart that shows fund names as the bubble. Is there a way to list the fund name as the data label? Thanks Jonathan

I have a report that has some subreports in it. The subreports could be any number of pages long. We have a machine in our mail center that would stuff our statements for us. The barcode formula for this machine consists of 5 characters. Charater 1 and 5 are always an *. Charater 3 is...

Is there a way to do a rolling count of the alphabet per page instead of numbers? So page 1 = A, 2 = B, 3 = C and then repeat once it hits page 26. So page 27 = A, 28 = B. thanks Jonathan

I was looking at another thread titled "Cannot sum a field calculated off a summary total" to solve my problem but was unable to get it to work. I have a report that has two groups. Group 1 = Employer Group 2 = Investment I am summing a datatbase field (balance) on Group 2 and Group 1. I have...

thread767-1596997 lbass The formula's you posted in the thread referenced helped me in my report but I have a question why my original formula didn't work when I did a count on it. I show termination date for a person if they have a termination date and are not active. When I do a count on my...

A department at where I work just converted from crystal 8.5 to crystal 10 for sage. I think that is what it is. Can anyone tell me what Sage is? They are having trouble just writing a simple formula in version 10 that worked for them in version 8.5. It gives them and error of "a statement...

Hello All One of the charts in my report prints flat looking. It prints the data how it is supposed to. Except the bar looks more like a line. The bars on my other bar charts touch at the sides. This one however has big spaces in between the bars. I have two groups in my report. One is...

I dont really know how to explain what I am doing. I have a one sheet excel file that has some participant information in it. When I go in crystal and set my database connection and then click Update I get the following error. "some tables count not be replaced, as no match was found in the...

Is there a way I can get a page footer in a subreport? Thanks Jonathan

I am trying to count the number of participants that my report returns. I have my fields in a group footer sorted by ssn. I suppress the section if their balance is 0. I insert a summary and do a distinct count on the ssn and place it in the Grand Total (report footer). The count I get is...

I have a report that has 4 sub reports in it. The report prints for certain people based on the record selection in the main report. most of the sections in the main report and sub reports suppress based on some database fields. The main report and a couple of the sub reports have personal...

I have a database field that is a number. I am trying to only return something if that database field is an odd number. I tried using the right function to do it but that didn't seem to work for me. What I tried is below. It doesnt like that it is a number. I tried converting the field to...

I am trying to find the last payment date. I can find the last payment date if the frequency of the payment is weekly or bi-weekly but I am having trouble finding the last payment date if the pay frequency is Semi Monthly or Monthly. I posted the equations I have for Weekly and Bi-Weekly...

I am trying to get a date to populate in a report if the currentdate is between a set of dates. I tried to do something like, if the currentdate is >= March 15 and the currentdate is < June 14 then give me a certain date. I could not get this work. The result it gives me is always what is...

I need a formula that populates the correct date based on the date a report is run. I want to be able to run it on a certain date and have it populate the correct date. I wrote the little segment below and that does what I want it to do, but it will only work for this year. I don't want to...