Search results for query: *

I have the following formula within my report header: "Date: " & date(Minimum ({DT1.Date})) & ' to ' & date(Maximum ({DT1.Date})) & chr(013) & "Generated: " & currentdatetime; My issue is, the min / max values being displayed are incorrect. I use a boolean formula to select data Example...

I searched the forum without any luck. So, looking for a little help. I have the following data: FIELD1 FIELD2 IDK FAC Primary SLA AKS SLS Primary I am looking to list out the data by it's name, with primary being first. I know I could group it by FIELD2 than by the...

Hello all.. I've been knocking my head against the wall.. I have a birthdate field.. I just need to know who has a birthday coming up within the next 45 days. Thought Dateadd would do the trick, but I can't seem to get it to work.. Thanks for any help given..

I have the following select statment, which fails if the user doesn't enter more then one value for the parameter. Does anyone know of a cleaner way of doing this? Using BOXI against sql if {?Location}[1] <> "" and {Name} like '*'&{?Location}[1]&'*' then true else if {?Location}[2] <> ""...

Hello all, Trying to create my first stored procedure and I am seeking a little help. I need to combined two tables and thought a union would be best. SELECT id, thru_date FROM Hospitals UNION SELECT id, FromDate FROM History; My issue is, the thur_date is a string and the Fromdate is a...

I have setup a multi-column report (details > Format with Multiple Columns). If the column A 'disconnects, runs into column B, I would like the group header information to also display when it carries over. Is this possible? Thank you.

I need to reorder/reverse Example = 123456 needs to be displayed as 563412 So, StrReverse wont' work.. Any ideas? Thank you.

I am in need of an idea on how I can create two groups out of a single value. Here is my formula example: if {Tax_ID} = "591943502" then "Shands at Live Oak" or if {Tax_ID} = "591943502" then "Shands at Starke"; The tax_id the above value is found need to create two separate groups when the...

I have an interesting problem. I wrote a report using a test database - The test db matches the db at the customers location - I then connect to our client (Set the database location within CR) and attempt to refresh the report. The report will continue to run, until it fills up the temp space...

Hello all - I am creating a report to be exported to a text file and I need to create a formula to add zero's to a zip code field if the length of the field is not equal to 9. I am using crystal reports v10 and here is what I have so far: stringvar zipcode :=...

Hope someone can help me with this. I have two fields: ActiveProcess_ID and ArchiveProcess_ID which are located in seperate tables and linked via an outer join to a master/primary table. I attempted to write the following formula, so that I can group on it, but it seems to ignore the...

Hello all.. I have the following formula: If ({RV_Practitioner.Last_Name} in ("A" to "C")) Then {RV_Practitioner.Last_Name} Else ""; When it runs, it only gives me A to B (Cutting off C).. I can't seem to find away around this.. Any ideas? I am running Crystal Reports v10 Thanks!

Hello, I don't write many cross tabs, but that boss lady really wants. Running V10 (Also have XI if needed) I have the following information below: The Payment and Rsvadj are generated from two formulas: (Payment) if {CM_PAYMNT.I_E_IND}="E" then {CM_PAYMNT.PAYMENT_AMT} And (Rsvadj) if...

Hello all, I created a simple report Within my main report I have the detail section split up into two sections (A and B) In section A I have a subreport which returns a shared variable: shared stringvar num := {RV_Practitioner_ID_Numbers.ID_Number}; num; In section B I have a formula to...

I am looking for a formula that will take the description of the record and combined the descriptoin when a matching record ID is found - My data looks something like this Description Record_ID ----------- ----------- Primary 37 Secondary 83 Billing 28 Campus...

Hello All.. I sure hope someone can help me out here. I have the following information within my report Group Header #1: (Specialty) Detail Section: (Process_ID) So, the data in the report looks like this Cardiology 1234 Internal Medicine 59 373 1234 Neurology 34...

I have the following select statement which joins two views together. In one view the First_Name is in all caps, in the second view, the First_Name is stored in lower case. Is there a way I can conver the first_name in lower case to all upper? Thanks for any help given. SELECT...

I was asked the question the other day if I could write 'Advanced Reports' I was wondering, what you guys/gals consider an 'Advanced' report?

I'm looking for a way to accomplish the following If question 1 is equal to No and question 2, 3, 4 are equal to yes, then 'true' else 'false'. Here is want the data looks like Table: ANS QUES Row 1) No 1 Row 2) Yes 2 Row 3) Yes 3 Row 4) Yes 4 Thanks for any help given

I have to create a couple reports that are compatible in both Oracle 9i and SQL 7. The only issue I've come upon is how boolean's are stored. Oracle will store them as 1/0, and SQL will store them as True/False. I could convert them to one or another using a formula, but I was hoping there...