Search results for query: *

Good morning, Experts. Hopefully there's an easy way to do this. I'm trying to create an expression in builder. I have a 'Week Number' field (which is just what it sounds like, the week number of the year for that record). I'd like to get the Monday date for that week number. For example: if...

Good afternoon, Experts. I'm need a formula to calculate COL-C. If both A and B have data, then I need the result (in COL-C) to show both fields separated by a / character. If only one of A or B have data, then I need the result (in COL-C) to show just the one field (no / character). I'm very...

Hello all, I think what I'm trying to do is pretty straight forward, but I'm no excel expert (sadly). I have three columns, I want the average of the contents, depending on how many columns are greater than zero. So, if two of the three cells are greater than 0, I want to divide by 2. If only...

Hello experts - I'm hoping this is a simple request, I haven't had to use too much DOS in recent years so I'm probably forgetting something common. I need to do a basic file copy from one location to another, but I need to target file to get a date extension so that it doesn't overwrite files...

Hi experts, I'm trying to export a crystal report (using CR2013) using the 'Microsoft Excel (97-2003)' option. Unfortunately, I have a column for every day of the year, and a couple more. The export stops on column 256 (IV). This is because crystal automatically exports to an XLS file, instead...

Hello Experts - Haven't used a simple dynamic cascading parameter in a long time. No commands or anything complicated here. Just one table, two fields. Field A (we'll use State for example) drop box should display 50 states then Field B (City) drop box should display all cities for the...

Good morning, experts. I admit to being perplexed. I created a simple command consisting of just two fields from two different tables. When I do a simple listing of the command, it shows the exact number of records that it should show. The fields are COMMAND.DISTRICT and COMMAND.CITY. When I...

Hi All, I am writing an SQL Expressin Field that has to compare two datetime fields, but I'm only concerned about the date portion of each field. In crystal format, my expression would look like this ... date(TABLE1.DATECREATED) = date(TABLE2.DATECREATED) where both fields are defined as...

Hello All, More of a curiousity than an immediate need. I've been using Crystal 2008, and I sometimes use arrays in certain formulas. I know that the max number of elements these arrays can hold is 1000. That always seemed kind of low. I'm wondering if this has been addressed and the max number...

Hello all, is there an 'isnumeric' funtion that I can use in an SQL expression field? I basically need to say something like this ... using a crystal psuedo-code ... ( select max ("table.desiredfield") from "db"."table" where isnumeric("table"."stringfield" ) ) -TS

Good Morning, Experts ... Can I write an SQL expression field that will actually 'write' to an existing table in Oracle? I basicaly need an INSERT statement within my report. I know I can set the privledges on the table to allow a write, but I'm really curious to see if Crystal can do it. Has...

Hello experts, Is there a way to link two tables via one string field ... for example ... Table_A Table_B StringFieldA ------> StringFieldB The problem here is that, while StringFieldA is always uppercase, StringFieldB is often lowercase. I need the link to act as if...

Hi All - I'm trying to create an SQL expression, but I need the filter to include a 'date' field that the user inputs when the report runs (a parameter field). How exactly can I get that into an SQL expression? If it's even possible. To complicate matters a little more, the table field is a...

Hi All - I'm trying to get some SQL expressions to work (using Crystal2008 and Oracle DB) ... I basically need to compare a datetime var in the two tables ... I need the Oracle equivalent to this crystal psuedo-statement ... day(TABLE1.datevar) = day(TABLE2.datevar) and month(TABLE1.datevar) =...

Hi All, I know that 'isnull' is not supported by Oracle ... I have the following SQL expression field that is working fine ... ( SELECT COUNT("TABLE"."OBJECTID") FROM "DB"."TABLE" WHERE "TABLE"."RELATEDOID" = "MYTABLE"."OBJECTID" ) this works, but I need to add another filter ... I need to...

Hello all, I fear this question may be a bit obvious to all but me, but I'm clearly doing something wrong ... Most of our crystal reports (published on SAP BO Enterprise XI) are hitting an Oracle DB, and are all set the same way in the "Default Settings/Database Config" option. I am now trying...

Hello All, I have a datetime field and I need to know the numeric value. By 'numeric value' I'm referring to that individual number that all days have since Dec.30,1899. I think it's something like the DateTimeValue function, but I can't find a good example of it in crystal. -TS

Hi All, I'm writing an SQL Expression field, and I need the Oracle equivalent of the following ... "TABLE"."WORK_TYPE" in ['1', '10', '12'] * I know I can break it down by a bunch of 'OR' lines, but I figured there should be an 'IN' equivalent that I could use. Thanx in advance! -TS

Hi all, I'd like to keep my group (Group 2)together on a Detail report that I'm doing, but I'd also like to ignore the 'keep group together' option on the first page of each parent group (Group 1). The way it is now, I get a blank page (no details) on the first page of the third Group 1...

Hello all, I have a data field (string) that looks like this: 11-aa-333-44-555-6666 While the components of the string can vary in size, I ALWAYS want the 2nd component of the string. 'aa' in this case. In standard formulas, I can just use the split function to parse it out...