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!

Recent content by ekta22

  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

    Thanks mocgp! That definitely got me closer. Only issue with this solution is that it is only exporting the bottom line(PHc) in excel and not the labels in PHa and PHb. So for 'SHORT NAME' label I only see 'NAME' and for 'REC CHANGE DATE' I see just 'DATE'. Is it possible to export the entire...
  3. ekta22

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

    I attached all the labels to guidelines(top/bottom, left/right), made them the same height and attached neighboring labels to the same guidelines. But below are the two situations I am having issue with (top alignment does not look nice in crystal but exports fine in excel - If all the labels...
  4. ekta22

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

    Yea, I have did that. One thing that I probably didn't show correctly above is that I need the labels to be bottom aligned and not top like above. With bottom aligned even if the heading is the same size it does not export it in excel correctly.
  5. 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...
  6. ekta22

    Reset Shading on each new page

    That worked. Thanks!
  7. ekta22

    Reset Shading on each new page

    I just noticed something. The above solution seems to be working great except for certain pages. I have multiple detail sections - Da, Db, Dc & Dd. At the top of certain pages ONLY Da section is highlighted in yellow and the other detail section - Db, Dc & Dd are in white. I see it only on the...
  8. ekta22

    Reset Shading on each new page

    Works great!!!
  9. 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
  10. ekta22

    How to handle string greater than 65534 characters

    Just wanted to update you that I got it to work. Thanks a lot!
  11. ekta22

    How to handle string greater than 65534 characters

    I do have a reset formula in my GH2 which looks like below WhilePrintingRecords; numbervar slno:=0; Yes I am linking on frlPopulate formula and also the parameters from the main report. Log IDs cannot appear more than once. I am going to try your suggestion and get back to you. I actually...
  12. 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...
  13. 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...
  14. ekta22

    How to pass multiple values to a parameter?

    Thanks!
  15. 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
See more

Part and Inventory Search

Back
Top