Search results for query: *

Well, I was trying to make that a million times harder than it was. Thanks!

Hi all~ I’m trying to pull data in Crystal and am stuck on how to do so logically. I’ve got a set group of data that I want in every report. I’ve given each record a date value of 09/09/1999 and a series identifier of “DR01” through “DR470” to distinguish this lot. I want the user to be able...

Ian, There was a syntex error in the SQL code/query but I got that fixed readily. I tested it against the database directly directly to make sure it worked. The query works in Access but it is prompting for a parameter. It doesn’t matter what I put in for the parameter - it works fine - but...

Looking at this, I see that Crystal's default is an unenforced Inner Join. When I try to switch to a Left Outer Join on any of the element tables (department, account), I get an error message that the join expression is not supported. Is that maybe part of the issue? SELECT `Agency_Use`.`Agy...

Hi Ian, I'm trying to avoid a manual cross tab at this point, until I try all I can at least. I've seen some references to the IsNull formula and have worked up this - thinking that it should replace null values with zeros, but when I put it into my summary field, I still don't get the headers...

Hi Pete, Yes, I can see how that would work. I've also considered creating a dummy ($0.00) value entry for every account/department combination as a default placement. What I'm really looking for is a technical solution. The issues seems fairly mainstream, but I just can't find the methodology...

Howdy, I'm trying to create a crosstab type report that will display account activity (rows) by department (columns). I want to display the account and department even when there is no amount activity in a period. Here's what I've tried. I have the account and department values in two...