Search results for query: *

Yeah, I added that line by hand. As I said in my original post, I tried initially to do it by adding the second table in database explorer and linking it, but attempting to do it that way causes CR to crash to desktop on data refresh every single time. I would prefer to do it that way if I...

Help! I'm trying to create a report which compares the ending inventory of two user specfied months. I have that part working perfectly. Every month, we take a snapshot of our ending inventory data and append it in an SQL database. Now, the users want the report grouped by a field that isn't...

Hi all. I'm trying to write a PSQL query in Crystal Reports which will pull only the most current data for each product from a sales history file. The data looks like this (only not sorted), and is contained in a table called ORLINH: Custkey Itemkey Location OrdDate UnitPrice...

Thanks fneily, that worked! I don't know what was different, but pasting that code in got it running perfectly. Thanks again!

Hi Missinglinq, I saw your code in the other thread, and really didn't want to restart a debate of the merits of yours vs fneily's here. I'm going to use his code, if I can get it working. I would appreciate any help you can give me in getting his code to work. Hi TheAceman1, I'm not using...

Hi Fneily, Looking at the VB code, the boxes at the top where I have those 4 lines typed in say: (General) (Declarations). The Form_OnLoad code is also showing under (General) (Declarations). On the left windows, under Alphabetic, the OnLoad has a blank field next to it, whereas OnConnect shows...

Hi, I found a thread I was hoping would solve may problem of how to put a "Record x of y" box on my form, but it's apparently too old for me to reply to directly. The solution which was posted on the thread is below, but I cannot figure out how to make the results show up on the form. I think I...