Search results for query: *

I have the below formula in a report and I am trying to condition for field ({master_cred.first_name}) being null if it is null. If this field is null, the formula below will not work. Rather report brings back nothing. The report does have approx 5 parameters. One of the parameters is for...

I am creating a report based on an access database that has monthly data tables. I am not linking the tables and would like to create a report that shows a change in the differences between months and then show a monthly trend. What is the best way to do this. I would like to create a column...

Refer to thread 149-1529329 I follow the info but nothing is displaying from the table I wanted to flatten. The only alteration i made was to replace table and field in the accum formula. Can you explain what each formula is trying to accomplish so I can modify the accum as you suggested.

I have 123 bug ant 123 bug spider 123 bug worm How can I pick out records set up as above, that dont contain a corresponding field called Ant. The above would not be on the report because one of the corresponding fields is ant so I wouldnt want to see this record.

What formula would I use to determine the length of a string.

I made a formula to show my fields that are not Null or do not contain a space. But it is bringing up records that still appear NULL or contain a space. What other condition could exist in this field. If its not nul and its not a space what else could it be? Thank you

{group_detail.location} in ["MAIN"] and {master_cred.active} = "P" and {master_cred.med_staff_status} = "PCP" and (({master_cred.status} in ["ACTIVE", "part", "hold", "PRAC"] or ({log_column.initial_value}in ["ACTIVE", "PART", "HOLD", "PRAC"] and {log_column.final_value} = "inactive" and...

I would like to use formula expert as selection expert for two groups. What kind of statement would I use so that the formula expert selects the correct records but doesnt demand a typical formula operator.

Our system does not log span dates but rather uses on date field and when customer becomes in active we change status field and the date field . How would I use that date field to show what was active last month versus present info to get percentage diff.

The database does not keep historical span dates of active customers. When someone becomes inactive, we simply change the status date. What will be the easiest way to get number of active customers last month (by date field) and compare to current active customers by same date field

I am using CR9 with an ODBC connection and the field I am trying to insert in the report is a varchar field. The text in the field is stored as rich text and when I try to report on the field, it comes into the report as rich text coding in front of and behind the text. I was hoping there was...

If the middle initial is null the formula brings back empty field. How do I condition formula below to pull even if Middle initial is blank formula ={master_cred.first_name} +" "+{master_cred.middle_name}+ " "+ {master_cred.last_name}+","+ " "+{master_cred.degree_type}

Why , When I use previousvalue formula to supress dupes within detail section of selection expert does it supress all lines of the first line. Example 123 Dog Boxer 123 Dog Boxer 456 Cat Domestic 456 Cat Domestic I see 456 Cat Domestic but not one line of the first row. I sorted...

How can I truncate a free text field and then use that truncated string as paremeter. Example Free text field says Monthly Objective - water garden. I want to use as parameter {?Monthly Objective}

I have on one table1 123 PA 124 MD on another table2 I have 123 PA 123 MD and 124 PA 124 MD. I want occurences where there is no match on table 2. I am getting 123 PA MD 123 MD PA 124 PA MD 124 MD pa. I should be getting none because there is a match

How can I export a cross tab to excel with the spreadsheet looking like steps. domestic longhair cat xxx I want it to look like xxx cat longhair domestic

I have two tables. Here is how data is display. 123 cat domestic 123 cat short hair 123 cat both I want it to look like this 123 cat domestic short hair both Does anyone know how I can write a formulat to do this? Carol