Search results for query: *

Skip, I previously formatted the entire column to date. Following your instructions above, I right clicked on one cell which displayed the date 1/4/2019. In the Format Cells dialog box, I confirmed the category was "Date". I then changed the category to "General" and the number 43469...

Thanks for the responses. However, this field was once recognized as a date in an existing report and is currently embedded in several formulas within that same report. I would rather not create a brand new formula converting the string to a date within Crystal and then have to find each place...

Hi, I'm using Crystal Reports 2013 Support Pack 11 on a 64-bit Windows 7 Professional Operating System. I'm creating a new report using an Excel spreadsheet as my data source. I am using the native Access/Excel (DAO) connection. The termination column in Excel is formatted as "Date"...

Thank you very much LB. Of course, your formula is much cleaner than mine. There were no nested formulas and the formula fields were placed in GF1. I clearly see the minimum function is able to select the minimum from a list of values within an array [] separated by commas. Cool! Much...

Thanks for your help, LB. Let me see if I can clarify a bit. At first I thought Level C would always return the minimum value as well, but because I'm interested in the absolute value, I don't think it will be. For example if @AcctBal = 26,000 then the absolute value of tenK = 16,000, fiftyK...

I'm using Crystal Reports 2013. I've created a formula with three variables which returns absolute values. I need the formula to return the level corresponding to the smallest absolute value. WhilePrintingRecords; Local NumberVar tenK := Abs (ToNumber({@AcctBal}) - 10000); //Level A Local...

I'm just getting back to the office. Again, LBass, thank you for your assistance! Worked perfectly!

It was originally in the GF section because for each department, I want a graphic to display the percent of individuals in that department only who earned more than 50K. The formula returns that let's say HR has 30% of employees who make more than 50K, but I'm not sure how to get the chart to...

Thanks so much for your assistance Lbass. This was perfect. The formula returned the correct percentage and it is listed in the Available Fields on the data tab for my chart. However, the chart (Doughnut) returns with the entire area shaded in. For example, if the returned percentage is 30...

Hi, I using Crystal Reports 2013. I am grouping my report by departments. I've created the following two running totals. #ActiveEmployees Field to Summarize: SSN Type of Summary: Distinct count Evaluate: isnull({Termination Date}) Reset: On Change of Group #1 #FiftykEmployees Field to...

Hi Ken, Thanks for the response. Indeed the issue was identified with your first bullet. There was no data in the subreport's detail section. The data was in the subreport's group footer section. I have resolved the issue by moving the subreport's GF1 fields to the RF and breaking the report...

Hi, I'm working in Crystal Reports 2013. I have a subreport which is placed in the GF1 section of my main report. I'm using the subreport's GH1 section as a page header and 'Repeat Group Headers on Each Page' is selected in both the subreport and the main report. If the subreport spans more...

I was able to resolve the issue. I created the following Boolean formula and named it Suppress InRepeatedGroupHeader = false and pagenumber = totalpagecount and pagenumber >1 I moved the conditional header information from GF1 to PHa. I then conditionally suppressed PHa when @Suppress =...

Hi, I working in CR 2013 I am looking for a way to ensure my GF1 Summary totals get printed with header information. Below are my sections RH & PH Suppressed GH1a ( Grouped by Fund) {FundName} GH1b {Datefield} GH2 (Grouped by Client Status){ClientStatus} GH3 (Grouped by Client last name...

We are using Crystal Reports XI release 2 (bundled with MAS500). I've added a subreport to the page header section of my main report. I also created a shared variable in the subreport and corresponding shared variable in the main report. The shared variable is placed in my Group Footer #2...

Thanks Andymc. I'll take a look around in MAS 500 to see if I can determine where the formula is defined. Again, thank you!

Hi, I'm using Crystal Reports XI with work files created for SAGE MAS 500. When I attempt to view formula expressions (i.e. edit the formula), all that is present is an empty string (""). Anyone seen this before and know if there is any way to access/modify the formula? Thanks!

Hi, I'm using Crystal Reports version 11.5. We're using this version because it is bundled with Sage ERP MAS 500. I'm modifying a report (FSFormat1) and have added a text object into the Report Footer. When I preview the report within Crystal Reports, I see the text object. However, when I...

Is there a more efficient way to write the following code? Basically, I am testing four conditions. Then I want to sum how many of those four conditions are true. Then I'm assigning them values A to E (0 to 4). Once an A to E is returned for each record, I am grouping by this value. Just...

So sorry for the confusion. The challenge is that I had employee hours tracked in three different, and barely related, databases. My task was to create a report where the daily totals (sum of hours) from these three databases displayed for each date in a range which has been specified by the...