Recent content by martinjt

I'm not sure I understand your question but copying is copying whether from subject text or the new copy (code?)area. They both work. I don't like the codes that show on one row however and you must scroll to see it. It is much better to utilize them the way you posted above. Thanks for your...

That's exactly right! I was mulling around in my head how to do it and I finally got it. I used a combination of formulas to split the string into pieces, then I combined the results into the exact string I needed. Here's an example of one of them: If Length ({@SHOWFORMULA}) = 0 then "" Else...

The problem with that is that the key isn't being accumulated in the variable which will only contain the number. It needs to accumulate to make sure the record is used only once in the string.

I'm using Crystal9 with Oracle Server. I'm having trouble extracting substrings from a string that is a result of a variable formula. I have two numbers that are being used and converted to text, the timekey (x) and the number recorded with that key (n). I'm using this approach because I need...

Makes sense. It works fine in one report but I didn't get the results I expected in another one which tells me I need to reconsider what's going on with the other report! Thanks.

LB, I want to double check something. Did you mean to put 8 for this line: if month(dateserial(year(st), month(st)+cnt,1)) = 9 then or is 9 correct? I believe the following line is the clue but making sure I've got it right.

The end date is always the last day of the month so yes, the entire month calculation you gave is perfect and it worked beautifully. THANKS!

Hi - I have CR9 with Oracle. Trying to do a month version of the following formula example that calculates the number of days between the order date and ship date, excluding Saturdays and Sundays: Local DateTimeVar d1 := {Orders.Order Date}; Local DateTimeVar d2 := {Orders.Ship Date}; DateDiff...

Thank YOU!! I could have sworn I tried that before but apparently I didn't. That did the job. No more repeating. Yay!!

On its own means running it outside of the main report. It does not repeat information on the next page. When I inserted it back into the main report it then proceeded to repeat the bottom lines of the page before. It is an issue with the conjunction. The subreport functions normally otherwise.

Thanks. I tried that. The subreport is fine on its own. It still repeats data on the top of the next page.

Greetings - using CR9 with Oracle8 Server. the last 2 or 3 detail items in a subreport at the bottom of the page seem to want to repeat at the top of the next page. I've tried combos of "keep object together" and "keep group together" to no avail. "keep group together" is not a good option as...

Thanks you two. I tried both and LB's worked perfectly. Thank you LB!! Ian, yours was very similar to what I was already trying and you're right - that is what my data was looking like. Thanks again, JT

Using Crystal 9 with Oracle. I am using variables to capture names that are associated with a gift record. The string result can have multiple values or the same value repeated. What I need is for the value to show once in the string result. In the group header I have the reset formula, the...

Thanks lbass! This is working well. The report got further complicated and needed additional grouping. Once I placed the accum formula in the right spot I got the desired result.