Search results for query: *

Since the memo field doesn't show up in the list of available fields to use in creating the formula I just typed it into the formula using left({mtpm.description},100). I got the error message saying a memo field isn't allowed in a formula. What diferent should I be doing? kowen@rrwa.net

I am using CR 8.5 Is there ANYWAY I can cheat, fudge or manipulate and sort on a memo field that is 265 characters long? kowen@rrwa.net

I'm using CR 8.5 I have 5 report footers in play here (RFa, b, c, d, and e. Any or all of the first 4 may print or not print in the main report if various conditions in the main report are true or false. On the 5th RF a subreport prints and is the last thing in the report to print and it...

thanks, my problem was I was not testing for null FIRST. kowen@rrwa.net

This is a pretty fundamenal question but I'm hung up....... I am using CR 8.5 I have {Field1}, {Field2}, and {Field3}. I want to multilpy {Field3} by either {Field1} or {Field2}. I have to choose either {field 1} or {field 2} based on whether {field 1} is either 0 or null. If {Field1} is...

After finally getting back to this problem, it is solved. MrBillSC was correct. I want 'Page N of M' to print in both the main report and the subreport. With 'Page N of M' being in Section PHa of main report and the subreport being in section RFh I went to the next previous section which...

hhmm, maybe that's it. It's been so long since I've created it I thought I'd just deleted them. So, the only page headers/footers you have in a sub-report is the carry over from the main report. Now it makes more sense. Thanks kowen@rrwa.net

I'm using CR 8.5 I have a report in which I've deleted the page header. I now wish to add a page header back in. How do I do that? I can't find a place to do it. keo kowen@rrwa.net

I am using CR8.5 I have a main report with one sub-report in report footer (RFh). Both main and sub-reports are multi-page. It starts a new page before starting to print the sub-report. On page header (PHa) of main report I have field{page N of M}. I want it to show only the total pages in main...

I agree with you, it worked perfectly. I copied and pasted your formula. It was just that CR wouldn't accept it till I added a ) and a ;. I didn't mean to imply that it didn't work. thanks for the help keo kowen@rrwa.net

Thanks all for your replies. That worked. FYI: I had to add a :=, a ), and a ;. It then gave me a minus number but formatted it to reverse the sign and it works fine now. Thanks again kowen@rrwa.net

I am trying to calculate the number of days between the scheduled day of a service order and the end of the month. The formula I am using is: Local DateVar tmpDate := {wkaw.sched_date}; (Dateadd("m",1,tmpDate)-Day(tmpDate))-tmpDate With wkaw.sched_date being the scheduled date of the service...

I am using CR8.5 with a Sybase dbase. My question is: I have a field (comm_code) used in the report. This field has many values. In the Report Header I need to list the values of this field that will appear in the report. Can I do this? kowen@rrwa.net

I am using CR 8.5 with a Sybase dbase. My question is: Is it possible to list the tables used in a report someplace in the report, preferably in the header? kowen@rrwa.net

I am using CR 8.5 I have a Work Order table with a text field into which is typed Technicians names. There are 5 dif techs but sometimes 2 or more names might be in the field (ex: Dave, Tyler and next record may be just 'Scott'.) ie: A work order may have either one name on it or several...

I'm using CR 8.0 I have a report that has a date field and a number field in it. I want to pull out the first record shown and the last record shown for each. I will be using these values for further calculations. How do I do this? kowen@rrwa.net

I admitt I didn't explain it very well. I used to use 'Infomaker' and they had an feature where you could actually 'paste' a "Print" and/or a "Query" button on the preview view of 'report' you were running. You could position it any place in a white space of the report. You could click on the...

I'm running CR 8.5 Something that bugs me about CR is the location and size of the menu buttons. I use the 'select' and 'print' buttons many times a day on some forms. Is there anyway to create a floating button that is larger than the standard buttons that I can have float on the page in a...

Can anyone tell me what is wrong with this expression? I'm using CR 8.5 {mtpm.stockno} is a string {mtpm.item_cost} is a number No matter what I do it will give me an error message tellimg me a 'boolean required here'. But it keeps jumping around no matter what I correct...

is there any workaround for detecting if a memo field is null? I have a detail sub section that contains a 2000 character memo field. It is the only field in the section. If it's null I'd like the section to be suppressed but I don't know how to format the section to do that. My reason is...