Recent content by ChuckVanT

I work with Bearden and was the one to fire off this "report". I checked, and on the Database menu in CR9, there is no 'Verify on Every Print'. However, there is, on the File->Options->Database tab a 'Verify when Database Driver Upgraded'. I am using a different DSN than the original...

I have a report that might be sorted by vendor, or might be sorted by manufacturer. Is there a way that when I give the user a parameter to select the report type, that the sort order can be changed 'on the fly'? Thanks in advance, Chuck

I have a report that runs on a subset of manufacturers, based on a Boolean parameter field. Is there a way to pass the value to the record selection formula in a sub-report? More simply, I guess.... Main Report: IF {?DatedGoods} = True THEN manufacturer in...

Is there a way to get these two features to work in concert? I have several million rows that summarize down to something in the 10's of thousands. Bringing back the whole year's data is, obviously, impractical. The Cross-Tab option fits the report well, and I don't want to re-invent...

I got it, I called Crystal and if you highlight the row-field on the Customize Tab in the Cross-Tab expert, the checkbox to suppress it's sub-total in the Group Options frame is enabled. Thanks again! PS - This one even stumped the gentleman @ Crystal, even he had to ask a co-worker!

I have tried those, and they're having no effect. I'm thinking that this is going to be a Crystal problem, not a Chuck problem. Thanks for the quick help! Chuck

I'm using Crystal 9, and I was wondering how can I remove the total rows in a cross tab report. My report has several contract codes each with several distribution centers for each customer. I've supressed everything Crystal will let me in the Cross Tab expert, but I still have something like...

When adding a boolean parameter, there is a checkbox for Customer Group. How do these groups behave. Help addresses them, but not at length. Any help is greatly appreciated. Chuck

MJRBIM, We are going to implement InfoScheduler this week, on a CE9 box. Would you be interested in sharing your document on that product? If there is too much proprietary info, or you just plain don't wanna share, I understand... Thanks in advance

Here is what I did. I put this in the Running Total Evaluate Formula: Select Month(Today) Case 1 to 3: Year({YOUR DATE FIELD}) = Year(Today)-1 AND Month({YOUR DATE FIELD}) in [10 to 12] Case 4 to 6: Year({YOUR DATE FIELD}) = Year(Today) AND Month({YOUR DATE FIELD}) in [1 to 3] Case 7 to 9...

Did Crystal Decisions see fit to include "LastFullQuarter" in CR9? I'm developing a report that is going to be migrated to CR9, in the very near future. I need to do the calculations to sum stuff for the last full quarter. If CR9 has the LastFullQuarter function, I'll develop it...

I'm trying to export a cross tab to Excel I have 3 headings, each sub-divided into 2 or 3 "sub-columns?". When I export this report to Excel it crashes the crxf_xls.dll. If I take out the "sub-columns" it exports just fine.... Any ideas? Thanks in advance to all!

I'm using both versions, but this project is mired in 8.5. I guess I'm just plain stuck! Thanks!

Is there a way to toggle between Page Header A & Page Header B when I drill down to the Details Section of a report? Thanks in advance for all assistance! Chuck

Actually, I'm using both versions, and the biggest help to me is being to enter the SQL directly into a "Command" object. I've been jumping through hoops to do a Union query in CR 8.5 (ended up using a stored procedure). I'm using one even as I type this, in CR 9. We're also using...