Search results for query: *

Thanks Mike. That's what I thought but I wanted to double check. Tim

Hi Folks, We are trying to come up with a way to do an If / Then type statement in Act. For example if a field within a large database = A then Print Driving Instructions A. Act Support says that If / Then are not supported but I wonder what people have done with custom reports. Is this...

Hi Smah, Thanks for the response. The IP address I listed had a typo in it. The real IP is 24.199.32.210 and the reverse DNS comes back to my correct domain. Thanks Tim

Hi Folks, This is an odd one that I hope someone has some ideas on... Our Exchange Server has shown up on the CBL. We are not an Open Relay nor have we been infected with anything. Evidently they run a HELOCHECK on Domains that support Email and if the response they receive is "incorrect"...

Hi Esquared, Thanks for the suggestion. Sometimes I overlook the obvious... That suggestion along with a couple of other tweaks have my query working great. And more importantly I believe I understand what is occurring. Thanks, Tim

Hi Esquared, Here you go. Here are real snippets from the table. (Column names shortened to get info to fit...) First: Normal case "Two lines of information" INV, LINE_NO, PO_LINE, PO#, DESC, ACCT_ID, AMT 317, 0, 1, 78, Tree Pruning, 0, 39000 317, 1, 1, 78, <NULL>, 6357, 39000...

Oh, so close. In testing occassionally the right record that I need to return has a ESA2.LINE_NO of 2 or higher. Which led me to the notion that I simply need to alter the command to a MAX aggregate function. I have tried the following: AND ESA2.[Line_No]=(select max(ESA2.SUB_LINE_NO) from...

Hi Esquared, Thanks once again for all of your help. I was able to get the query to work! (I might be figuring out this Self Join stuff yet...). After your last suggestion I scoured the table in question looking for one more unique field that I can base my query on (the table has approx 50...

Hi Esquared, Thanks for the comments. Yes, I can have multiple POs per invoice. Your last snippet of Code returns the same 16 Account Numbers for each Description. Here is the code with the return set: SELECT ESA1.PO_NUM, ESA1.ITEM_DESC, ESA1.INV_AMT, ESA1.LINE_NO...

Hi Esquared, The Outer Join was just the last thing I tried... Thanks for the hint. I altered my query to the following: SELECT ESA.PO_NUM, ESA.ITEM_DESC, ESA.INV_AMT, ESA1.ACCT_ID FROM dbo.ESAINVCD ESA INNER JOIN dbo.ESAINVCD ESA1 ON...

Hi Esquared, Thanks for the challenge. I don't learn anything if I just get the answer... I can't seem to get past a result set that looks like: INV DESC ACCT AMT 1 (null) 1 16.77 1 (null) 2 206.58 1 DESC 0 16.77 2 DESC 1 0 206.58 My last...

Hi Folks, Last week you folks were kind enough to assist me with a situation where a Self Join solved my issue. I thought I understand Self Joins and have been attempting to get one to work without success for the following issue. Return set is: INV Line# PO Desc Acct ID AMT 1...

Hi Esquired, No, I don't understand it yet. This is the first time I have seen a Self-Join in my limited SQL real life. I have my SQL book out and I am in the process of dissecting it. hanks, Tim

Thanks ESquared your suggestion worked! Now I am working on getting the raw SQL to work in Crystal Reports. Thanks a bunch! Tim

Thanks folks. I am exloring both suggestions right now. I forgot to mention one thing. I also need to link Acct # field to Account_Lookup Table so that I can get a real Account Number returned as part of my query. Thanks for the quick response! Tim

Hi Folks, I have a commercial Database Application that I am querying to build a Invoice Report. As part of this report I am building a query to determine how much money is left on a given PO. The PO table (simplified version) is structured as follows... Line_No PO Desc Acct #...

Hi Dave, Awesome. I was just heading down that path. My problem was/is that I am not resetting the page number. Thanks a bunch! Tim

Hi Folks, CR 8.5 newbie here. I have an Invoicing Report working great (thanks for a nudge in the right direction LBass). However, my wonderful accounting folks have made an additional request which is that the Page Footer only appear on the First Page of any invoice that extends to multiple...

Thanks K, Sorry for my vague question. I am just getting up to speed in Crystal. The values being passed are returned as part of my original SQL query. They are simply PO numbers. 90% of the time there is one PO # but sometimes an invoice needs to reference two PO numbers. The subreport...

Hi Folks, I have a Invoicing Report that includes a Subreport that I created and I use a Subreport Link to pass a value to the subreport to display more detailed information. Everything works great as long as there is only one value to pass to the subreport. In rare circumstances there will be...