Search results for query: *

I might have answered by own question. I conducted a test and was able to import 10,001 values into the list of static values.

Greetings, We know that a dynamic parameter list of values has a default limitation of 1,000 values (although that can be changed via a registry edit). But does anyone know if a static parameter list of values in Crystal Reports has a limitation on the number of values that can be imported...

Hi! I might be missing something here, but could this be achieved by splitting the Details section into 11 sections (Da through Dk) and then placing the same data fields in all 11 sections?

I've seen this parameter behavior before in version 2008, and it appears to be caused by optional parameters. The screen scrolls to the first required parameter in the set parameter order. To avoid the inconvenience, I've moved a required parameter to the top of the set parameter order.

It sounds like the special field Page Number is in a group footer rather than a page Footer. If you move the field to the Page Footer, the page count should appear correctly.

I believe I had a similar problem several years ago, and if I recall correctly, I changed references to the "CurrentDate" to "DataDate". Try that and see if it works.

It always pays to mention what version of Crystal Reports you are using. The <br> notation works for version 2008 - I've used it several times without any problems. I'm not sure what works in other versions.

HTML cannot interpet CHR codes. Try "<br>" as a carriage return, and be sure to format the field to allow it to grow. "Line <b> one </b> and <br> line 2

What I like to do in this type of situation is to make the age range parameter optional with no default value entered. Then, in the record selection formula, code somthing like this: (not hasvalue({?YourAgeRangeParameter}) or {YourAgeValue} = {?YourAgeRangeParameter}) If the user enters any...

Thanks lbass. At your suggestion, I tried the shaded text boxes with the provided suppression formula in a separate section, and it worked. Thanks! However, as you hinted, that approach is not entirely realistic in this situation because the number of rows can greatly vary. In instances where...

Thanks lbass for your response! And I apologize for not including what I had already tried. I can't think of a way either to embed a color background in a formula. I thought about a font color change, and have done that in other reports using HTML code embedded in the concatenated text. But...

Here's a puzzle for Tek-Tips! Using Crystal Reports 2008, with data that looks something like this: Abbrev Name Property_1 Property_2 Property_Etc BTL Long name for BTL 4 5 7 CDV Long name for CDV 7 6 8 EFB Long...

Hi! To more fully understand what you are trying to do, it may be useful for you to provide an example of the data you are working with and the formulas you are using.

If an appropriate date field is included in the data, create a group in the report based on the date field, and in the Change Group Options, select "for each month" in the Change Group Options window. Then in the group footer, insert a summary of the field.

If I'm not mistaken, you can create a Running Total Field. Select the Field to summarize as the {FEE_DUE_AMT} field, the Type of summary as Sum, set Reset to Never (or select a group if you are using groups), and Evalute using the formula {FEE_TYPE} IN ["TS", "PL", etc.].

You can use a series of if... then statements in the formula, or the Select Case control structure, something like: select {ORDERHDR.ORDER_SRC} case 1: "Phone" case 2: "Mail" case 3: "Pick up" default: "Other"

The +1 increments the Month value by 1 month, the 01 represents the first day of the month, and the -1 decreases the Year value by 1 year.

Hi - in the formula for the bottom border of the {assessment_date} field, change the formula to: if {assessment_date} >= Date(Year(CurrentDate)-1, Month(CurrentDate), 01) and {assessment_date} < Date(Year(CurrentDate)-1, Month(CurrentDate)+1, 01) then crSingleLine else crNoLine I think...

Thanks lbass for your idea. I had thought of that, since I used a similar technique in the past to display rows with no data in a Length Frequency Distribution cross-tab report. I ended up using a formula in the Report Header to create the sequence of numbers, and another formula in the...

I've used the Section Expert in Crystal to underlay one section over the other. Just check "Underlay Following Sections" in the section that contains the chart. Put the chart on one side (left or right) and put the data on the other side.