Search results for query: *

I have to find the median number in columns of data, without counting zeroes. The zeroes are the result of a formula. I tried saying if {@days} > 0, then {@days} else null or "" but that didn't work because of course, the formula expects a numeric value. So my report looks like: JAN FEB...

(Sorry, the search was down for maintenance, so I didn't get to search thoroughly...) I have several rows (not many, just 300 or so) of two columns of data in Excel. One is an error number, the other is a date. What I need to find is the number of occurrences where two numbers fall under the...

Hi, I am trying to show the $REF field in a view. Is there a way? (I need to see the number that is stored in that field on a whole bunch of documents.) Thanks danhauer

I have a series of queries and I just want to run them one at a time without retyping. I have an Oracle script that I modified with a bunch of statements that I could copy and paste 30 times, but I'm looking for a way to place a comment so I can just uncomment them one at a time and run them...

I'm using Office XP, and everthing was fine when I made charts. Then for no "apparent" reason, one day when I went to make a new chart (nothing fancy, just the default chart using the chart wizard) and the plot area was so small I couldn't even find a handle to drag it and make it...

Hello - This seems like it should be easy, but I cannot find a way to write a formula to update a cell with the date/time of the last change on the spreadsheet. I can do it with code, but I need to pass this info on to users. Is there a way? I tried convincing them that they could do a...

This one has been a real stumper... I'm also posting it in the Lotus Notes forum. I created a report using CR (Enterprise ver 8.0.1.1) against a Notes database. The selection is based on all documents created using "frm_pppinput". There are two (maybe more that I don't know about!)...

This one has been a real stumper... I'm also posting it in the Crystal Reports forum. I created a report using CR against a Notes database. The selection is based on all documents created using "frm_pppinput". There are two (maybe more that I don't know about!) documents appearing...

I have a PowerPoint presentation with a link to a Lotus Notes document in it. In PP edit mode, the link works fine. But during the slideshow, it doesn't work at all - clicking on it just takes you to the next slide. In edit mode, if you right click on the Notes icon, some of the options are...

Forcing databases to work together sure doesn't seem easy in CR! Whew! Here is my scenario: I have two Oracle databases. One contains volume used table, plant table. The other is a vendor database with vendor...

Forcing databases to work together sure doesn't seem easy in CR! Whew! Here is my scenario: I have two Oracle databases. One contains volume used table, plant table. The other is a vendor database with vendor information tables. My task: Show volume by site code and vendor name and...

Hello! I have a report with five subreports linked to one server, but each subreport is linked to its own Notes database. Each database requires a login. So, when I go to schedule the data source server, it shows the server that the databases are on, but it only shows the first database name...

Hi! I am making a graph based on the formula =if(a2=a3,a3,null) only the null portion doesn't work, of course. I can't use "" or a space (I even tried just a comma with nothing after it), because the graph interperets anything other than nothing (null) as a zero, when actually on...

I am a newbie to Focus, but with experience in several other db applications. I am going *crazy* trying to do a "many-to-many" or "left" or "outer" (you get the picture) JOIN in Focus. Does anyone have any ideas, or any way around it?