Search results for query: *

Hi all, I have something strange happening with my report running on a SQL Server database. My select criteria includes the following: {LPlusOpenInvoiceHistoryVW.invhst_register_type} like ["NOTE*", "RENT*", "INSTP*"] but the SQL sent to the server (viewed from the Database/Show SQL Query...

Thanks to you both on your answers to this question. I've actually also (since I first posted this morning) run into the same problem with a non-cascading picklist -- any idea why? Thanks. Robin

Excellent, I will, thank you!

Thanks again for your help on this. I worked out a number of steps in converting stand-alone RPT files from being based on tables to being incorporated in the VB app I've mentioned. First I converted the RPT to run on an SQL command, then I generated a TTX file and converted the report to be...

Hi, I've just moved over to version XI from version 9. I'm following the instructions in the George Peck book for setting up a cascading picklist, but for some reason I only get a limited list of values (5) for the first level, when I expected to get them all (approx 50). I can set up a...

Thanks for the response. No, I don't think I'm confusing TTX files with what you mention. I do remember (over two years ago) that I was hoping to move stand-alone reports (either based on tables/views or a SQL command) into the VB application and have the VB app just override the SQL command...

Hi all, I'm converting a VB6 application that runs about 60 CR9 reports on a Pervasive database, to run on SQL Server. I'm using a VB form to generate the SQL for each report on the fly. When I originally built the application I used TTX files, but I vaguely remember that I had to do this due...

I thought it did -- it has each of the three parts, separated by commas, enclosed by parentheses. Can you tell me how my syntax is incorrect? Thank you!

Hi, I need to build a query with a WHERE clause for a Crystal report that essentially tests for something and if true, builds the rest of the WHERE clause one way, and if false, builds the rest another way. I would like to be able to do something like this: WHERE LeaseCompany.LeaseCompanyNum =...

Just got a response on another list -- I was missing a parenthesis after "'CM'))" I needed three rather than just two. Thanks for your willingness to help out.

The error message is: [Pervasive][ODBC Client Interface][Pervasive][ODBC Engine Interface]Syntax Error: 'CM')) AND (OpenivnInvoiceHist.HistTranCode LIKE 'INT%' OR OpeninvInvoiceHist.HistTranCode LIKE 'NOTE%' OR OpeninvInvoiceHist.HistTranCode LIKE 'RENT%' OR OpeninvInvoiceHist.HistTranCode LIKE...

Hi, I'm using LIKE in a SQL statement, as below. Evidently my syntax is incorrect at the end of the statement, however I'm not sure what the problem is -- everything looks fine to me. Any suggestions? Thanks in advance. WHERE (LeaseCompany.LeaseCompanyNum = '09') AND...

Hi all, I'm working with a VB app, using DAO 3.6, that used to generate Access '97 databases using the following code: Set dbsNew = wrkDefault.CreateDatabase(strLPAccessInv, dbLangGeneral, dbVersion30) I was able to have it create databases in Access 2000 by changing "dbVersion30" to...

It seems to have worked, thank you so much!

Hi, I'm just starting to program with VB, so this is a newbie question. I'm building an application where I choose one of a number of reports, and the form for entering that report's parameters pops up, and then calls the viewer to display that report. The code one usually uses to display the...

Not sure if I understand exactly what you want to do, but you could create a union query for the two views, and then feed the recordset to your report via VB. The method for feeding a recordset to a report depends on what kind of database you're using and what kind of driver.

It worked! Thank you so much!

Thanks pgtek, I hadn't used the Picture function before, I'm sure I'll find it useful in the future. Unfortunately it didn't work here though. I went into the DSR and created the formula there, as below: picture(totext({Command.CustPhone}),"(xxx) xxx-xxxx") and then dropped it on the...

Hi all, I have a report that has two number fields that I have to format to display as phone numbers. While both the custom function that came along with the app the database is associated with, as well as my home-grown formatting with "left" and "mid" and "right" work on an RPT file, as soon...