Search results for query: *

Hi, I have text files that store data. Once open (no problem there) I need to read the fourth line from the bottom for use in my program. I'm using text files of varying length so going from the top won't work. Ideas?

I did that and it printed all of them (open and not). What I just did was to add a formula in the supression section of the section expert for that section. Here is the formula I used: {incident_data_all.date_inc_closed} <> Date(1840, 12, 31) It works fine that way. I'm still curious why...

No

I am trying to do a query on all incidents that aren't closed. When an incident is open, it is assigned a closure date of 12-31-1840 (don't ask me why it isn't left null). I have a selection criteria that looks like this: {incident_data_all.date_inc_closed} = Date (1840, 12, 31) and...

I'd like to create something like a cross tab but a cross tab won't work because I want to count summary fields. Right now, I have formulas that count the information that I need but I am having trouble displaying it in a grid. Ideally I would insert a table and then just display the variable...

Wouldn't I want to use a LEFT OUTER JOIN though because I want the query to return a line when there is no record of a treatment plan (and, of course, when there is as well). If I were to use an inner join, wouldn't it only return a record where there is a treatment plan in place? The...

I'm working with CR11 and SQL server DB. I'm doing a report that is supposed to tell me if all of the elements of a treatment plan are in place. The command line has lots of LEFT INNER JOINS because a treatment plan is scattered over several tables. There may be more than one plan in the...

I'm using CR 11. I have a report that, in the details section, makes a list of client problems. For each problem, there should be a responsible staff. At the group level, I've got two running totals - one that counts the number of problems and another that counts the number of responsible...

I'm working in CR 11, SQL server database. I'm trying to find out if employees are entering a required field in client's service record. Its a free text field so when they don't enter anything the field is empty. I've tried to add a formula to the running total in a couple of ways...