Search results for query: *

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.

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...

By using UPPER and LOWER, how can I capitalize city names or company names correctly. Examples: "Santa Rosa" or "Steward Financial Group, Inc" I tried: UPPER(substring(City, 1, 1)) + LOWER(substring (City, 2, 99)) but this only capitalizes the first letter in the string.

How do I set a parameter, within a Command, equal to a shared variable...or can I at all? Main report has field called SettleDate. Formula is: shared DateTimeVar ParamSettleDate:= tblW.SettleDate; The subreport, which is a command, the formula is: WhilePrintingRecords; shared DateTimeVar...

This thread is similar to "Trying to sum by type" posted by frankone on 6/6. I have a string field, Fund_type, and a currency field, Amount. What I want is where fund_type in (equity, hybrid), then add the values in Amount. Tried: if {tblMonthlyRsmSummary.FundType} in["Equity", "Hybrid"] then...

Using CE Embedded v10. Trying to modify ASP sample 'ReportPreview' for our environment. The 'ReportPreview' lists a set of reports on the left side of an HTML frame. Clicking on a report selects it to bring it up in a Viewer, however the userid and password for the database is requested every...

I am looking for sql syntax that will pull the last business day(Monday thru Friday), with GETDATE. For example, using GETDATE:If GETDATE was a Monday, I would want it to retreive Friday, or if GETDATE was a Tuesday, and Monday was a holiday, then Id want to retreive the last business day...

Currently I passing start date and end date parameters in a stored procedure. Rather than having to manually enter the parameters, I want to incorporate a sql formula using datediff and/or dateadd, such that it will take today's date and return a period of the last full business week. In...

We are passing a StartDate and EndDate as a Datetime datatype from SQL 2000. The time is formatted as 00:00:00, but Crystal requires the time parameter formatted as 12:00:00. The work around in the stored procedure is convert (varchar,@EndDate,101) but this is going to be a pain. Is there...

What is the APS in Crystal 9 Enterprise installation? We are accessing data on SQL2000. There is a dialog box that asks for the name and password. I know what APS stands for, but how do I engage it? Thank you.

WHat is the best book/manual you have used for learning and troubleshooting Crystal 9.0?

How do I format a column of phone numbers? For example make them all like: (###)###-#### or ###-###-####.Right now the data type is nvarchar (14). Is there a function for this?