Recent content by INTP

Yes- that worked perfectly- thanks!

Thanks Madawc, I am using CR 9.2 with XP Pro. I used your suggested formulas and tested them by placing them in the details. They all returned a true value. Now, if I understand you correctly, I need to use the count formula against these formulas? so... COUNT @({formula 1)) and do the...

It seems like I may have asked this same question a few years ago... but I can't find it. Date/Time issues always get the best of me. Anyway... I need to find out how many records are processed at our call center between the hours of midnight and 8am by month for the last three months...

Thanks!

Yes, thank you. That did work. Now, just out of curiosity, if I were to change it to a annual, quarterly, weekly or daily report? What would I need to change to get the date to display?

I have a monthly report, and I want the header to automatically display the date range for the month of the data in the report. I tried inserting the DataDate finction from the Document Properties in the formula editor... but it displays todays date rather than the date of the data that I'm using.

Aha! That makes sense to me. Thank you!

Thanks. That worked as well and may be faster (fractionally). Is there a CR rule for putting the "Not IsNull" before the selected field? Is that always the case or is it only when there is a "not"?

Well I should have just kept plugging away at it before asking that last question apparently, the corrected verbiage is not "is like" but rather, it's just "like". I also replaced the "?" with an "*" and it worked fantastically. Thanks for your help!

Okay, this is good. It worked well except for one thing... which is my fault because I didn't mention it. The 8 code is further defined based on whether the service was given free as a donation, a customer service compensation or a promotional. These are further defined as 8, 8d, 8p & 8c so to...

Sorry if this is too basic a question for this forum. My CR education is limited to just one CR level 1 class (2 days), and that was many years ago (I think CR 9 was just coming out). I don't use it often but have been charged with creating a report for work and am stumped. It all sounds like it...

I did see that and I selected Unformatted Text. This resulted in the last item on the office clipboard being pasted into the word document as unformatted text... which is what I wanted. However, it did not paste the previous 11 items on the office clipboard as unformatted text. When I went back...

Maybe I'm not understanding your response. I clarified in my last reply that I am a dork and forgot to mention that my question really pertains to the office clipboard feature of the Office suite. I tried Edit/Paste Special and I did not see an option to make text only the default action for...

Okay- I'm a dork. What I forgot to mention in my original post is that I am copying large amounts of data and am using the office clipboard. It's when I paste from the clipboard that I am not able to get text only.

It seems like I used to be able to do this... I am copying data from Excel to Word. I want to pate text only into the Word document but I end up pasting the cell. How do I paste text only from Excel to Word? I am on Office 2000 at this location but typically work on Office XP. Is this a change...