Search results for query: *

Hi, I am using Crystal XI I have two date parameters on my report and I want to be able to make them optional. Currently, crystal forces me to enter the date. How can I do this? Thanks, E

Hi, Version - Crystal XI I am having trouble with exporting my Field Headings in Excel 97-2000 - Data Only format. Excel is messing up the order of the Field Headings. My headings are in PH and some have 3 lines of text, some 2 and some just 1. Excel always puts the fields with 3 lines of text...

I am using the formula below to do alternate shading in my details section. I want that on every new page the first record color should always start with CrNoColor shading first just like on first page. How can I reset this? if RecordNumber mod 2 = 0 then CrYellow else CrNoColor

Hi, I am trying to use a select statement inside the NVL function but keep getting a Missing Expression error. Cannot figure out what I am doing wrong. Below is my code SELECT F.TYPE, L.CODE, L.ID, L.STATUS, L.START_DATE, L.END_DATE, NVL(SELECT ID FROM LOG LY WHERE LY.CODE...

Hi, I am using Crystal XI. I have the formula below in the detail section. This formula gathers all the LOG IDs and then pass them to my subreport. But when large data is returned I get the "A string can be at most 65534 characters long" error. Formula in Detail section - @frlDisplay...

Hi, I have created a lookup table that looks something like below: a - a a - aa a - aaa b - b b - bb I want to use this lookup table in my query. If a user selects a, the query should return values a, aa, aaa. How can I use this lookup to get the above results. Thanks a lot in advance! -E

Hi, Version: Crystal XI I am using an array to gather log ids. But when I run a report with wider search criteria I get an error - Error: String can be at most 65534 characters. How can I get rid of this error? Below is my formula WhilePrintingRecords; Global StringVar Array_Name; numbervar...

Hi, I have a formula that displays the record number for records being displyed on the report. It works fine but I want it to reset on change of the group. How can I do it in the formula below. I tried incorporating the formula in Running total but it does not like the variable in there. This...

Hi All, I have added a water mark to my report and made it to underlay following sections. It works fine except that in my detail section I have done alternate shading on my recrods. if RecordNumber mod 2 = 0 then rgb(246,241,223) else CrNoColor But after adding the water mark my shading...

Hi, I am using Crystal Reports to pass multiple value to my parameter(pSTATUS) declared in my oracle package. Field for this parameter can accept upto three values..'O', 'X' and 'V'. The way it will be passed from Crystal to Oracle is in the following format depending on how many values a...

Hi, I am trying to use the IN clause with my bind variable but with no success. Any ideas on how to do this? Thanks, -E

Hi, I have a datetime field and I was to extract just the hour portion of that in my SQL statement. Any ideas on how to do this? I tried to look around but did not find anything. Thanks, -E

Hi, I am receiving the above error (ORA-24338 statement handle not executed) when an exception is thrown from the stored procedure I am calling. I am using Crystal XI and Oracle 10g. Any ideas why I may be getting this error. My package compiles just fine. Thanks, -E

Hi, I am trying to get the number of days between two dates by using the datediff function. I get the total number of seconds. But then I was to display the total number of seconds in HH:MM:SS format. I have tried it many ways but can't get it to work. My formula below keeps rounding it to just...

Hi, I have created a parameter in my report. I am having little trouble with the code. The way I want this parameter to work is that if the user enters the value "N" for this parameter I want to display all the records from the database where length of the field is 6 and last two characters are...

Hi, I have a parameter in my stored procedure called pCODE. Right now the field this parameter is based can be of variable length and is of type varchar2. . The way I want to use this pCODE parameter is that if the user enters the value "National" for this parameter it should show only those...

Hi, I am using Crystal XI and Oracle 10g. I have a Running Total in the detail section of my report. I have two Groups in the report, Type and Name. The running total works fine except when Name field is NULL. For example if the running total is 10 and Name field is Null it shows the count...

Hi Everyone, I have a CODE field in my database which is of datatype NUMBER. I created a parameter of type VARCHAR2 as user can either enter number or text to get values within a range. pCODE IN VARCHAR2; I tried two things but I get error for both. I did the parameter comparison in my oracle...

Hi, My report is based on an oracle stored procedure. I declare my parameters in my stored procedure something like this pSTART_DATE IN T1.START_DATETIME%TYPE, pEND_DATE IN T1.LOG.END_DATETIME%TYPE, pCC IN T1.CODE%TYPE I use the code below for each parameter in my stored procedure to check...

Hi, I am trying to join two tables and get the result as below Table1 ID 100 200 300 Table2 Group_ID---ID 1----------100 1----------101 1----------102 2----------200 2----------201 I have the query below so far and it gives me 100, 101, & 102 which is okay. But I want to get rid of 100 which...