Recent content by starbase59

I would like to create a report, that is generated only if there is data. If there is no data, then there is no report to be distributed. I have Bus. Objects Edge, Crystal XI R2. I heard a guy at the Oct 2009 Users conference in Dallas who did this. I can't remember exactly how he did it, but...

I'm using Crystal Reports Professional XI publishing to BO Edge Enterprise. My DBA has created an ODBC for non-I.T. business analyst types like myself, so he can allow permissions on stored procedures. The username and password are set up so that they are not the same as the log-in to the...

Hi, Need help with a Case statement to report figures quarter-to- date.....Could it be similar to the code for month-to-date, such like the code below? For example, if the @paramDate = 01/18/12 then Q1, if @paramDate = 4/18/12, then Q2, and so on. If so, how? Thank you. WHERE ((Date BETWEEN...

How do I eliminate the middle initial and nickname (in parens) in these text string examples? My ultimate goal is to parse a simple first and last name, with no middle initial or other garbage in the string. THOMAS C. (SKIP) HANKS VERN D. (DICK) HOLLYOAK Thanks in advance.

I have 6 columns in a CRXI report (SQLserver 2000), exported to .txt file. In design mode, I've set the size of each field the same with right alignment, but when I open in Notepad, columns are misaligned: RSM Daily MTD MTDNet PA PA_MTD TO 1902 14410 6377...

We have Crystal Reports Professional 11.0 packaged with Business Objects Edge. After an upgrade to a Blackberry server, the CR reports exported to excel, now appear with a colored background when viewed on a Blackberry. They have always appeared black on white, now black on purple. If the CR...

How do I parse a name field? Formats are inconsistent, some have middle names or initials, some do not. Examples: Chris Kimball Paul Richard Revere J. Benjamin Franklin I need a FirstName field, MiddleName field and a LastName field. I have most of the code, but need help with the Middle...

I have a field where the city, state and zip are one text string separated by spaces. I only want the city, in every case, so I'm looking for everything left of the first space. Examples of field: MIAMI FL 33131 EDISON NJ 08837 NEWTON MA 02458 I want: MIAMI EDISON NEWTON Would I use...

I have grouped on the field, Year (e.g. 2008) In Preview, on the report itself, I can format the field to get rid of the comma and decimal places, but they still show up in the directory tree(e.g. 2,008.00) ANyone know how to get the right format in the directory tree.

thank, lbass. yes, I meant and, not or.

Thank you synapsevampire. Makes sense, this is what I was afraid of. I will try soundex.

Thank you, yes all my version have failed. Here's a bit more of the story. I'm calculating an "Other" field. For example, where the text string is NOT one of the following: {HISTORY.COMPLETEDDATE} in lastfullweek and {HISTORY.TYPE} = 262146 and (NOT({HISTORY.DESCRIPTION} like "Left...

I have CR9 and SQL Server db. I want to exclude particular text strings using NOT, and I need to use the wildcard to include spelling errors and/or variations of spelling, etc, within the text string. So far, none of my formulas have worked. Can NOT("X") be used with character data type...

Perfect. Thank you.

Thank you. Perfect.