Search results for query: *

Okay, I had this exact same thing happen when I updated from Crystal 8.5 to Crystal 10, and it really stumped me at first. It had to do with Crystal saving the location of the "favorites" databases in 8.5 without remapping the datasources in 10; I at first thought I could fix this by remaking...

Then I would want it to say "any state beginning with N". I can do this in a macro no problem, but I need it to change while the user is working on it. A more common situation in this spreadsheet would be the user filtering all non-blanks, so I'd want to be able to display that, which I'm not...

I think this one should be easy, but for some reason I can't figure it out. When you autofilter a column, is there a way to refer to the selection criteria elsewhere on the worksheet? For example, let's say I have an autofiltered column with a list of states, and the user selects "Minnesota"...

What is the field type for payGrade?

Hi uby, maybe I'm not understanding you right because this seems really simple. You just write a script to select your second workbook and then insert a row just above the total (or wherever else you want it). So it would be: Dim WhatEverLineTheTotalIsOn 'set this up by default to equal...

If you are using that field often, an easier way to replace null values with a default is using a SQL Expression. Just create a new SQL Expression from the Field Explorer (for example let's name it "NewWOTYPE3") and type in this: {fn IFNULL(TASKS."WOTYPE3","lall")} Then you can use...

Hi jenreb1, I use 8.5 too, it's actually not that tricky. First you go down to "SQL Expressions Field" in the Field Explorer and click on "New" to create an expression. Let's name it "UnMemoChildInstructions" for this example. Don't worry, you don't really need to know any SQL to do this...