Search results for query: *

This used to be a commonly used feature of DOS scripting. I wanted to write a simple app using the Crystal report viewer and have it open a report whose name is passed as a parameter. eg; c:\apps\CrystalView.exe "C:\Docs\Report1.rpt" The app would open and display the...

Another Excel related question.. Rephrased re-posted.. "Totals vanish when exporting to Excel" I'm using the DoCmd.OutputTo method of transferring the contents of a formatted report out to an Excel file. The report contains 6 subreports and I've attempted to line them all up so as...

Another Excel related question.. I'm using the DoCmd.OutputTo method of transferring the contents of a formatted report out to an Excel file. The report contains 6 subreports and I've attempted to line them all up so as to achieve a sense of continuity. Everything is just fine except for...

I'm attempting to pass data from a form to a parameter within a query. In the criteria cell I've entered: Not In ([Forms]![MyForm]![MyTextBox]) MyTextBox contains the literal string "Stoves","Ovens" Yet Stoves and Ovens are still returned. Any Clues? Thanks, Rob Dexter.

CR8.5Dev, Access97, ODBC I'm trying to replicate VB's Nz "null to zero" function within a Crystal formula, is this the correct method? IIF(IsNull({db.Field1}),0,{db.Field1}) Not getting the desired results: Falsepart - formula returns field1 when it is not null - ok that's good...

I'm going crazy here, struggling with selection syntax. FName MName LName ---------------------------- Fred James Flinstone Ted Bertie Beetle Irene Payne Greg Philpott Brady Ron Birdseye I want to exclude all records whose middle names =...

CRDev8.5 ODBC Access97 Client would like to view summarized weekly data inclusive of running sum to display "Period to Date" figures. "Period" could be anything from 2 to 52 weeks. I've atttempted using a crosstab to display the data on an x-axis timeline, it's great, but I...

CR8.5Dev, VB6, ODBC I have a report that is always exported to Excel, always "7.0 Extended" and Column width always based on Page Header, plus I'd also like to control the resulting file name via code as well. This would save users a few extra keystrokes, plus ensure it ends up in the...

CR8.5Dev, VB6, ODBC Are the Crystal export functions controllable by VB code? I have a report that is always exported to Excel, always "7.0 Extended" and Column width always based on Page Header, plus I'd also like to control the resulting file name via code as well. This would save...

CR8.5Dev, VB6, Access97 OK, firstly I've got to apologise for my "Access" mentality and methodologies. I'm trying to recreate a little native Access functionality using VB and Crystal. In Access you can have a form with a command button open a report that includes subreports. The...

Howdy, CR 8.5 dev / MS Access db I'd like to prompt the user for a single date parameter value (?StartDate) and use the value differently over 3 unrelated sub-reports. (Within record selection formula's against a different field for each subreport) I've declared the Shared variable in the...

CR 8.5 dev MSAccess 2000 Does anyone know of any sample Access apps that utilise the RDC? The developers guide that shipped with 8.5 outlines plenty of VB6 examples (and there's a truckload included on the CD), but it informs you to search the developerzone for Microsoft Office samples. When...

Using: CR 8.5 Dev Access 2000 Access 2000 Runtime NT 4.0 sp5 I'm trying to determine whether I can distribute an Access 2000 app inclusive of the ActiveX CRViewer object. I've shelled out for developer versions of both CR 8.5 and Office 2000 and now want to make something-simple work. I've...