Search results for query: *

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

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

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

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

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

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]

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]

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

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

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

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

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

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

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

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

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]

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

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]

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]

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