Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ekta22
  • Content: Threads
  • Order by date
  1. ekta22

    How to make date parameter optional?

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

    Export to Excel - Data Only - Order of field headings wrong in Excel

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

    Reset Shading on each new page

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

    Select statement inside NVL function

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

    How to handle string greater than 65534 characters

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

    How to pass multiple values to a parameter?

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

    Error: String can be at most 65534 characters

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

    Resetting Formula on change on group

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

    Watermark???

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

    Passing multiples value to a parameter

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

    IN Cluase with Bind Variable

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

    Hour portion of datetime field

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

    Database Connector Error:'ORA-24338'

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

    Converting days into HH:MM:SS

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

    Parameter Issue

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

    Parameter issue

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

    Running Total Issue

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

    Datatype Issue

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

    Parameter Issue

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

    SQL Query

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

Part and Inventory Search

Back
Top