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...

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...

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...

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...

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...

Hi, I need to make some reports suitable for export to Excel - data only. I always run into the same issue if I use a subreports. I wonder if anybody has a solution? Here is an example GH_1 - GH_2 ---- subreport Joined by GH1 & GH2, returns shared variables -- Details Column_1...

Hi, I wonder if anyone can explain why a numbervar will change it's value depending on which group section it is placed. I sometimes need a value to show in the next group but find it changes when I move it down. As far as I can tell, none of the component values change so I've not been able to...

Hi, I am working on a Custom Crystal report for AR using the AR_InvoiceHistoryHeader table. (MAS 200) It has almost all the data I need except for an Invoice Amount. Does anyone know if that a stored value or will I need to calculate it from detail tables? Thanks Bruce O

Hi, Just wondering if anybody might know why ODBC on an XP desktop fails while Win2K or Win2003 are fine? This something I discovered while testing upgrades/installs. Sometime I used old desktops because I don't have a spare servers. 1 - OpenEdge 10.1B and ODBC driver installed on an XP system...

Hi, I've been stuck for a while on how to suppress subreport groups if their value matches a line in the main report. Thanks in advance for any suggestions. I want to show backorders on a pack slip. Unfortunately the business rules will not allow a zero quantity line on a shipment. I can't...

Hi, I'm interested in some basic help with an MS Dynamics CRM 2011 implemntation. I have a tight schedule & I think the technical learning curve will be too long. I believe what I need is very basic to get us started. If CRM is successful with sales, we might expand to other departments next...

Hi, >subreport should generally be avoided I was looking thru some old posts saw the statement above. I was reminded that I use subreports all the time but have a nagging feeling about them. Just curious if anybody has any insight into subreports they can share. Thanks BTW, I'm not often...

Hi, I have a question about Group Hide Drilldown OK. Crystal is the report writer for a business application. I use Crystal Developer to write the reports and the application has a Crystal Runtime. In Crystal developer I can hide a group and allow drill down. Drilldown works when I preview...

Hi, I wonder if anybody can give me an idea how to group/summarize some data. I have changing prices that I'd like to total. Keeping the summarized values in order as they change. My raw data looks something like this: Part 9500-1, Price $1.10, Oty 25, 1/1/2011 Part 9500-1, Price $1.10, Oty...

Hi, I have been stumped on a Purchase Order sorting problem. I'm looking for ideas. Thanks ahead of time for proceeding... I have a PO (Purchase Order) report, currently grouped and sorted like this: Group 1 = PO Number -- Group 2 = PO Line ----- Group 3 = PO Release Each PO Number can...

Hi, I have a Legend 7.0 Version 10.0 A user told me he was having trouble with some outside caller not getting through to him. I printed out the details for his extension & I saw one setting that was different from other extensions. It is called "Receive Voice Calls" & is set to OFF. I can't...