Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dleewms

    Excel Datatype Mismatch

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

    Excel Datatype Mismatch

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

    Excel Datatype Mismatch

    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"...
  4. dleewms

    Minimum value of variables

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

    Minimum value of variables

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

    Minimum value of variables

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

    Fomula Field Not An Available Field in Chart Expert

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

    Fomula Field Not An Available Field in Chart Expert

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

    Fomula Field Not An Available Field in Chart Expert

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

    Fomula Field Not An Available Field in Chart Expert

    ...to display percentage of employees per department. @DeptCount if {#ActiveEmployees} = 0 then 0 else {#FiftyKEmployees} / {#ActiveEmployees} * 100 Ultimately, I want to use a chart, perhaps a doughnut or gauge chart, to display the percentage of active employees who earned more than 50K...
  11. dleewms

    No Group Header Prints After Page One of Subreport Although Repeat Group Header Turned ON

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

    No Group Header Prints After Page One of Subreport Although Repeat Group Header Turned ON

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

    Suppress Group Footer when Group Header Prints

    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 =...
  14. dleewms

    Suppress Group Footer when Group Header Prints

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

    Shared Variable Exports Zero (0) to Excel

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

    Formula Syntax Contains Only An Empty String

    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!
  17. dleewms

    Formula Syntax Contains Only An Empty String

    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!
  18. dleewms

    Report Footer Not Printing in Sage MAS500 Report

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

    More efficient formula for sum of counts

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

    Group by Date from Parameter Range

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

Part and Inventory Search

Back
Top