Search results for query: *

I know this has been asked over and over again, but I haven't seen anything specific to Crystal 2011. Is there a way to have a chart grow contingent upon the data returned in the chart? I have a horizontal bar chart that looks great if it produces 20 bars but some charts can have up to 100 and...

I want to create a line chart that shows an employee's sales percentage. It should be sorted by the percentage descending. Problem I am having is I don't want the percentage to show in the x-axis, just the employee's name, in the order of the sales percentage highest to lowest. I attached a...

Thanks much! I'll give it a try.

I have data that looks similar to this: Loc Emp Date Items A 1 11/18/2014 15 A 2 11/18/2014 20 A 3 11/18/2014 84 A 1 11/25/2014 6 A 2 11/25/2014 13 A 3 11/25/2014 99 A 1 12/23/2014 52 A 2 12/23/2014 48 A 3 12/23/2014 43 A 1 12/30/2014 47 A 2 12/30/2014 12 A 3 12/30/2014 8 I...

I figured it out. I moved the employee name to the detail section of the sub-report and hid the remainder of the cross-tab that was in the report header of the sub-report. I could then edit the employee name to display in columns since it was now a detail line. I now display the employee...

Unfortunately, this is not in the Details section but in the Report Header. Format with multiple columns is not an option there. Users are able to select the department from a parameter and the cross-tab returns the employee names vertically and places them in the Report Header.

I have a report that has a subreport in the report header that contains a cross-tab. This cross-tab pulls all members that work in a particular department (chosen via a parameter) and displays their name vertically down the page. Report needs to be one page only. One particular department...

I think I found a way to accomplish what I need. I created a formula called TestDate: Local DateVar DIn:= date ({MyTable.AsOfDate}); //date field Local NumberVar DOW:= 3; //target DayOfWeek Tuesday=3 DIn := (DIn - day(DIn) + 32); // Find a date in the next month DIn := DIn - day(DIn)...

I have a table that contains 15 months worth of data and is added to every Tuesday, making the AsOfDate always a Tuesday. I do a rolling 12 month history and use the formula below to select the months I need: {MyTable.AsOfDate} in [dateserial(year(currentdate),month(currentdate)-12,1) to...

The data labels in my chart are too close to my line graph's series markers. I think years ago I used to have some type of a formula or a command that I put somewhere to increase the gap between the series marker and the data label if they were placed outside the maximum. Also, there was a way...

I have a chart that has 2 Y-axis. One is a bar, the other is a line. I need to format the line and can't find where to do that. I don't want the rectangle that appears in every bar. I just want a continuous red line. I found where I can change the line color, line thickness, etc, but not how...

I have a Crystal Report that has 50 schedules pulling various parameters. I need to make a change to that report to modify one of the parameter's selection list. Is there a way to Save the new report to Enterprise (overwrite the existing Crystal Report) and see those changes within the...

Thanks for not sleeping so I could. I can't get it to work but I haven't spent much time on it either. I'll get back to you next week when I can spend more time on it. Thanks again.

I need to know the first bin location a part was put in. Part can have multiple detail lines. Sample detail: DETAIL PART NAME DATE LOCATION 1 PART_1 1/1/2012 BIN_4 1 PART_1 2/1/2012 BIN_4 1 PART_1 4/1/2012 BIN_4 1 PART_1 6/1/2012 BIN_5 1 PART_1 7/1/2012 BIN_6 2 PART_2 4/1/2012 BIN_1 2...