Search results for query: *

Ref thread1462-1567557 I have the same request/problem as mentioned in this post. Duplex printing where a report has page breaks on a group. Currently new groups can start on the back of a page. Users need all groups start on the front of the page. i.e insert a blank page if the starting page...

>>This is a SQL Server forum... check to see if there is one for Open Edge OK thanks. I forgot this was the ODBC connection to a legacy Progress version - SQL but limited. I will test Row_Number on the newer versions All MS SQL & they need the same updates. Bruce O

>>The important part here is the Row_Number stuff. Thanks for the reply, good to know. Unfortunately not an option in this case. I'm working with an old version of OpenEdge 10.1B via ODBC >>> the ROW_NUMBER function is not supported in OpenEdge and there is currently no equivalent function...

F.Y.I. It turned out I really needed a view and the ability to return multiple records. I couldn't figure out how to get it to work in just one statement. So ended up making one view & calling it in the other as follows. It works but I'd be interested in suggested alternatives -- Sub View...

>>Top 1 Yes, the one row is all I need for what I'm doing. Thanks for the suggestion

Hi, Can you help me with this one? I need to select Revision a parts - from Approved (True) Revisions only - the revision with the MAX Effective date So from these part revisions PartNum___Rev___Approved___EffectiveDate 1234567...C.....True.......1989-07-16...

>> AR Invoices and Cash Receipts Just a followup on an old thread637-1720718 I finally discovered a limitation in the ODBC driver being used. Documentation states.... limit of one left outer join per query. Once I realized this restriction I was able to get the results I needed. Now use...

Hi, I am looking for help in duplicating these values: - "Invoice total" and "Balance" --- for invoice Types CM (and DM). ----- as displayed on the "A/R Invoice History tracker". I've been using the formula below -- it appears to be working OK for type "IN" invoices. --- But I just noticed...

Hi, I'm looking for any suggestions/ideas for allowing MS SQL ODBC access for a limited number of users. This is an new issue since we've recently upgraded our ERP application AND migrated it to a hosted site. As far as I can tell, we're their first client to ask for ODBC and we're not making...

Thanks for the example. I'll test this as soon as (if) I get back to my office .......flights grounded yesterday due to the severe weather on the east coast. .............still stuck at the airport ................. a few more hours & I should finally be out of here. If your in the U.S. I...

Hi, I need a running count of one field AND reset on the change of anther field. Examples below of current output and desired output. My current query returns about 1700 records. The columns/data looks like this: JOB:............Part:.....Level:.....Seq 123:............3659........0.........3...

>>this is not specifically an Excel question, but a query SQL code question. Noted, one of those days... I just happened to be in Excel while looking at the select statements. >>Description field might be, is not a particularly reliable choice to make. Correct, this is a legacy convention on a...

Thanks, You are correct, now I see there are descriptions that begin with YY. Since I don't use Excel that much, I guess I was overthinking. Bruce O

Hi, Anybody know what yy% could be in Excel? Here it is in context: SELECT Part.Description FROM Part WHERE Description Not Like 'yy%' Thanks in advance for any help/insight. Bordway FWI... Reason... I'm converting old Excel spreadsheets that connect to an ERP system via ODBC. Upgraded to...

Nice to have something different to try. I've been sitting on a couple of these & I'm ready to get them out of my queue. Will report the results. Thanks Bruce O

>>> If you are using MS Access... MS Access is just the temporary band-ade. I want to add a Crystal report on the MAS menu Bruce O

Hi, >> some details.... Here is everything I can think of. Thanks in advance for your help. Version: Sage MAS 200 Tables: AR_InvoiceHistoryHeader (as ARH), AR_CashReceiptsHistory (as ARC) and AR_Terms (as ART) This is an MS Access Query that should pull the data I need but... it is too slow...

Hi, Any ideas where to look for settings that could control blank rows during export to Excel data-only? I'm seeing 4 blank rows after a group footer section when exporting to Excel, data-only. --- from a CR runtime, it seems to work OK when exporting from the Developer. I have a main report...

Hi, Hoping someone can help me find better approach to a custom report. I found detail data that would work but.... in three tables without common indexes the report is so slow - it's not useable. Below is the source data I've been using - to get invoices and any payments. Rpt...

Oops!!! I just saw this is already answered... Reference http://www.tek-tips.com/viewthread.cfm?qid=1161484 >> Try suppressing all sections within the subreport. >> Then go to the section expert->section the sub is in->check "suppress blank section". >> Also go to...