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 Chriss Miller 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. Madawc

    Formula for Counting Number of Summarized Fields

    Is that a crosstab or what? In a report, you could group by days, do a summary total for the day using a variable, and then another in the group footer to add 1 when the total is more than 12. The count that. If you're not already familiar with Crystal's automated totals, see FAQ767-6524...
  2. Madawc

    Goodbye for now

    On 6th September 2013, I retire from my regular job. Not necessarily from IT Work: I intend to see how things go with my various pensions. I might later go looking for contract work, but if so, I'll let you know. Definitely not interested at the moment. My working career has mostly been...
  3. Madawc

    Exporting/Formatting Issues

    You've double-posted, but not explained in any detail what you are doing. What export? Are the subreports side-by-side? Also it helps to give your Crystal version - 8, 8.5, 9, 10, 11, 2008 or whatever. Methods sometimes change between versions, and higher versions have extra options...
  4. Madawc

    Crystal Reports Cross Tab

    Depending on your version of Crystal, you should be able to create a formula field and use it in your crosstab in place of the item. Something like if @NotSuppressed then 1 else 0 It helps to give your Crystal version - 8, 8.5, 9, 10, 11, 2008 or whatever. Methods sometimes change between...
  5. Madawc

    Totals based on the same number of weeks for the current year's start date and 2 previous years

    DatePart includes an option to get the week number. [yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
  6. Madawc

    symbols get lost while converting from word 2007 to word 2010, how to fix?

    If you still have the filed before conversion, then use Automatic Replace to change the non-converting symbols to a distinctive alphanumeric string. Change back after conversion. [yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
  7. Madawc

    Grouping by Max Record Value

    PS. If you're going to switch to another forum, please leave a message saying so. Double-posting is not approved of. [yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
  8. Madawc

    Grouping by Max Record Value

    If you do a left-outer join from A to B, but also do a conditional test on B, then it will eliminate anything where there is no B for A. Is that it? If so, test for nulls first. If you're using an SQL Command, you might do better feeding tables into a succession of temporary table. Or you...
  9. Madawc

    Word 2010 Heading and Table Numbering

    Thanks for letting the rest of us know. [bigears] As the article says, Word has a very peculiar numbering system. One that seems based on a belief that there is no intelligent life outside of Microsoft. [yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP...
  10. Madawc

    Crosstab help

    What formulas? If your calculation uses data from more than one detail line, then summary totals will not be allowed. You make a reference to "GF3", but only show two levels. You might consider using a subreport, if a crosstab can't be made to work. Put the totals in group footers. And...
  11. Madawc

    User field will not show up in the report

    First, is the field there in Field Expolorer? (You should be able to display this using the View menu.) If it is there, you should be able to place it on your report. If it exists but is blank, could this be correct? PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11, 2008 or...
  12. Madawc

    Crystal Reports Running Totals By Group

    Sorry, I don't follow. Can anyone else help? [yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
  13. Madawc

    Crystal Reports - Date Range Help

    First, create a formula that gives you the date two years ago, for any current date. Something like DateAdd ("y", -2, currentdate) This could also go in the report header. Then group records for an account - I assume you have several. Suppress the group header and detail lines, and also do a...
  14. Madawc

    Selecting Records with Different Values

    Do something like (payer Id #} in ["5000", "1000"] and "payer" in {payer Id #}) or ("5000" in (payer Id #} and "client" in {payer Id #}) Put @Reportable on your report next to the unselected data, to check it shows True or False in the way you want. Then add @Reportable to your selection...
  15. Madawc

    Help with formula to check month/day range

    DatePart can isolate a month, and DateAdd can add a given number of time-units, anything from seconds to months. But your examples use variable time-spans, so I don't see any short way. Code something like if DatePart ("m", Currentdate) = 11 then if DatePart ("d", Currentdate) < 16...
  16. Madawc

    Crystal Reports Running Totals By Group

    You can make Running Totals conditional. One of the options on the automatic generation function. [yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
  17. Madawc

    XI Subreport(s) in Report Footer(s) not obeying Keep Together

    You say you've unchecked all of the "Keep Together" funcitons. Does that include "Keep Object Together" on the Subreport as viewed from the main report? If not, right-click and choose "Format Subreport". The option is on the [Common] tab. [yinyang] Madawc Williams (East Anglia, UK). Using...
  18. Madawc

    Crystal Reports Running Totals By Group

    Unclear what you're after. Would a crosstab do it? [yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
  19. Madawc

    SQL command copy/paste bombed Crystal Report

    As a general rule, use Save As to make backup copies before any manjor change. Not much use for your immediate problem, but it will pay off in future. [yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
  20. Madawc

    Syntax for dynamic calculated member (for Av) in Crosstab, Crystal Reports 2008

    Which version of Crystal? Mine includes "average" as one of the options for a summed field. You can adjust using the Crosstab experts. Or is it that you need to use different numbers of month? If so, make that a formula field and then use it to average against something else. I've never...

Part and Inventory Search

Back
Top