Search results for query: *

Thanks for the replys. Yes I was coding it correct, and all of the suggested solutions were helpful and led me to the real issue: I could only succesfully pass the date if I did so under Group Selection Formula. If I try to pass the same selection formula for records, the report does not...

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

Will do. Joins are not working, so I'll try adding the second lookup table. Manually created labels to get the project done this morning.... Thanks for your response, hopefully this method will work.

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

Thx for the replies. Using very similar code to yours in vb.net Syntax is correct, loops thru all tables, then fails to logon. No problem until I try to send to printer, then Returns an unhandled exception: "Unable to connect: incorrect log on parameters." server, UID, and PWD are correct...

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

Good point. that must be why some reports were OK with the table changes, and others weren't. I'll review all the reports for the setting and hopefully this will work from this point on. Side note: while the updating the table is covered under the verify DB command, I have found verify...

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

No go on formatting the datetimepicker. regardless of the format I try to pass ( need #2007-2-13#) I end up with #2/13/2007#. Can I even pass the correct format with a DTP, or maybe I need to have the user enter the date in a textbox....... The stringvalue dates I am passing work great...

Thanks for the reply. I'll try it out and get back to you.

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

Thanks for the confirmation on the viewer. My app does not need to display anything, just process and print. Thanks again for the reply.

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?

Thanks ! The ODBC connection does make the most sense. I will give both a try, see what works and report back. Hopefully with good news .............. PB