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

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

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

Got it to work. Thanks!

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

Thanks lbass! Will try it out and see how it looks.

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