Recent content by ekta22

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

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

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

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.

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

That worked. Thanks!

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

Works great!!!

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

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

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

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

Thanks!

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