Search results for query: *

Synapse - thanks for your reply. I'll give it a try. Ken - thanks to you, as well. I have purchased material from you in the past and found it excellent. I visit your site from time to time and find I always learn something new. Dennis

I have numeric parameters for Year and Account. In the parameter dialog box, I would like them to display as 2007 (not 2,007) and 123456 (not 123,456). Is this possible and if so, how? Thanks in advance, Dennis

Our test server is down for maintenance right now, so I can't try out the synonym approach. It looks like it will work. I'll try Monday and let you know. Thanks to both of you for your on-target help. I sincerely appreciate it. MDD

Thank you for your reply. I use Crystal Reports XI. I have two DSNs (TEST and PROD) one pointing to an Oracle test server and one pointing to an Oracle production server. To get the SQL Command to work, I have to qualify the table. A simple example for the test server: Select * from...

I have a report based on an SQL Command located on a test server. I would like to move the report to a production server. I have tried various combinations from: Set Datasource Location Verify Database Database Expert Log On or Off Server Nothing works. I have searched Google and...

First off, thanks for your reply. I confess I'm not sure I understand. In my original question, I talked about 'Region' with values 'North', etc. I did that to simplify the question. In the real report, 'Region' corresponds to 'Business Group'. What I want to do is have the Business Group...

I'm fairly new to Crystal. Here's what I'd like to do. Suppose I have a field called Region with values 'North', 'South', 'East' and 'West'. I'd like to create a parameter field to select, let's say, the 'East' region. Actually, I've done this part and it works fine. What I'd really like is to...

I'm struggling with this and I'll appreciate any help. I have a form, frmGLTRANS2, that's populated with an SQL statement. There are many fields, so the form is designed to visually display a single record. The form queries a large Oracle database. Initially, I used "Filter by Form&quot...

It looks like the ";" is the separator to use between addresses. I thought I'd tried this before, but perhaps not.

I have a VB program that e-mails reports. The main portion sends 300 or so e-mails, one at a time. Then I e-mail the entire report to me. So far, so good. Everything works. Now I want to add a second e-mail address to the final report. When I do this, the procedure crashes at the Export False...

I have a VB6 project that I'm trying to move from my local PC to a different PC. The project works on my PC. On the other PC, when I attempt to load the project from the same network directory as the original PC, I get: Error during load. FILE.dsr could not be loaded. The log file has...

I have this problem concerning the Set Location command in Crystal Reports: I created a report based on an Access MDB file. I created a new Access MDB file with revised information. I used the Set Location command to change the location and the name of the MDB file that Crystal Reports is...