Search results for query: *

Creatd report based on date of an action. Having trouble passing date to record selection (literal date) so I created a formula: (will be adding parameters at a later date) Shared datetimeVar dt :={Action.EnteredDate}; If dt = #2011-02-01# then 'T' else 'F' If the date is within...

In the most basic form, I'm trying to add two separate validation sets (the English label related to the actual numeric value) to the same detail line in my report. I can add the first reference to a valset no problem (regardless of which one) but when I try to add a second set from the VSE...

Have been trying to find a working solution to the problem of changing SID at runtime. Like many users we have a TEST and PROD environment. Currently running separate test and prod version of reports in lieu of the ability to change SID at runtime. Have scoured the forum and web with no...

Hello All: I have written an app in VB.NET 2005 that calls 60 crystal reports, refreshes them, sends the needed number of copies to the printer, and exports a single copy to PDF format. The problem is a random number of reports refuse to be called by the .NET program. We can manually...

Hello All: I am calling CR XI reports from Visual Studio 2005 and I have run into a problem regarding verifying the database. The report will hang up and refuse refresh due to a change in the data table. I know this can be done manually thru CR, but want to verify with code. I am using the...

Morning All: I have written an application with VB.Net that successfully prompts and passes STRINGFIELD parameter values through VB to Crystal Reports. Everything is working great, until I try to pass a Datafield value. None of the formats I tried to pass appear to provide the correct format...

Created a program to find, refresh, and printout crystal reports. Works great on reports WITHOUT parameters. Problem arises when I try to access a report with parameters field I receive the error at the bottom, using the code below. code used: Dim Par As...

I am trying to address parameters in my VB.Net app and need to know if the CR Report Viewer is necessary? I am currently printing and exporting using the ReportDocument with success and want to address parameters from the RD as well. I have noticed most of the examples in Tek-Tips (excellent...

While upgrading from CR 8.5 to 9x I ran into a "rowset" error message when trying to access the Oracle DB on only on a few reports ( out of many) At a total loss for the reason why, I did the following: Clicked on the "database" pulldown menu, Selected "Show SQL Query" and clicked the...

We have moved from oracle client 81 to Oracle client 806. I have tested the three folling providers under 806, none of which want to connect successfully. I am using an ADODB connection and trying the following providers: .Provider = "MSDAORA" .Provider =...

Until recently we have been installing Oracle 81 and Oracle 806 client on each desktop. Recently a decision has been made to discontinue the 81 install and just go with the 806. I have several VB apps (VB6 and VBA) that have made the connection to the oracle db through the 81 directory, and in...

Recently created a VB 6 program to call and print reports from CR 8.5. Program works great, compiled normally, but does package up correctly. I am using the active X control 8.0.0.4. The right directories are created in the packaging process, yet when I access them, they are empty. Whats up?

I have an older (1999) proprietary Foxpro database that will only run successfully in administrator mode under XP Pro. Tried User and Power User with no luck Connects to a NT 4 server running IP protocol. Everything else runs fine under basic user mode. Tried the compatability wizard for older...

Want to duplex print a word document from VB6. Entered the following code to set the property: Printer.Duplex = (vbPRDPVertical) returns an invalid property value error msg. Document printer great otherwise. How else does one print on both sides??? Thanks